Discount coupon system

[manyone]

if your table is static and used as reference table (input only, no update), then you can use google sheet and apply the techniques in this article to use SQL-like queries to lookup any record.

Quiz App using google sheet via google's visualization API Query Language (instead of Data Source)

i’ve just recoded my earlier quiz app which used airtable as datasource into a new version using google sheet as source of the quiz but NOT as a data source. Instead i’m using Google’s Visualization API Query Language to read the worksheet (see this recent discussion in the forum ). It’s a different approach for working with google sheets, but i like it! below is the contents of my worksheet. ( Note - in order to use the query language, the worksheet must first be shared such that anyone wit…