Hi. I have a spreadsheet from my health insurer that lists 250 thousand UPC numbers (13 digit string) for products it pays for through it’s OTC program. I want my family to be able to answer two questions with this app.
- Snap a picture of a UPC bar code in 1. the store and return “Covered by Insurance” (found it) or “Not Covered”. Maybe a few hundred times a year.
- Search the table for text and see the results to help find covered substitutes for not-covered items.
I don’t need to make changes to the list or manage users. I’ll update this list no more than four times a year. We want to query
There’s no business model here, no scaling of users beyond my family. Just trying to save hours of headache and heartache at the Rite-Aid, Walgreens, and Walmart in-store checkout.
Can I even do this on Glide? Within the limits?