Air ticket booking app - importing data from Google sheet

[Taifun]

@Sam77

Let’s say if someone select any travel sector, say from Singapore to Tokyo, how can I bring rest of the relevant data such as the relevant flight no, dates and fares from the excel/ google sheet

Use gviz together with a SQL query
SELECT * WHERE 'travel sector' = 'Singapore to Tokyo'

Use gviz to get and query google sheet data

[gvizscreen1] Guide on how to use the google visualization API to get and query "public" google sheet data Use gviz to get and query google sheet data Note: this approach has been knocking around for years, e.g. https://puravidaapps.com/spreadsheet.php, but I have never seen it "properly" explained like this...

Alternatively use rhe Spreadsheet component

Spreadsheet component. Example. Google Sheets

In order to utilize this component, one must first have a Google Developer Account. Then, one must create a new project under that Google Developer Account, enable the Google Sheets API on that project, and finally create a Service Account for the Sheets API. How to create the Service Account, here: http://ai2.appinventor.mit.edu/reference/other/googlesheets-api-setup.html At the end of the whole process we will obtain a file of the form: app-inventor-338017-8c72fd465555.json We must upload…

Taifun