How to select a row from a big google sheet using Apps Script in App Inventor? So that the searching process is fast in the App.
These should help:
or read through:
AI2 and Google Drive/Docs/Sheets
Thank you so much for your help. All I want to do is to search from a big google sheet using a value that the user will enter and it will return the other column values for that row. I did it by downloading the whole sheet in the app and it works perfectly for small sheets. But for large sheets(size around 50 mb), it takes a lot of time to download the whole file and this makes the app very slow. Can you please help me by showing an example like this. I mean, I want to see what script I need to write and also the blocks for the App Inventor.
That is a massive spreadsheet!
There are examples provided in the links I put up. Let us know when you get stuck.
In this situation, you should look for options to use SQL-like query syntax to filter the sheet at the upstream server and send back only the requested row.
From the links earlier in this thread, I would follow
Thank you so much for your support. It really means a lot. I will be able to do it now I guess. 