Get Spesific Result Form TinyDB

Hi everybody,
There is an idea to get data from tinyDB with certain keyword in textbox and result is shown as label? For example, with the keyword “ABC00049719”, the results would be “Project 4” and “Location 4”. Thanks a lot

SS_TinyDB_Result.aia (3.3 KB)

you should show us , how the datas are stored in gsheet… in your aia, on clickg button to get data returns empty value… may be the sheet is not shared or private sheet… allow us to get data so as to assist you…

(During query time always use sample data and sample sheet, never use main sheet )

BTW, do you have too many datas? app disconnects immediatly when the request was made…

This is my sample spradsheet

Thanks for your support

well. so you are having 10k datas. no problem… better use gviz method of query to avoid breaking of app… let me add it wait…

@banyuparikesit test this

SS_TinyDB_Result_1.aia (5.7 KB)

This is searching in tinydb

SS_TinyDB_Result2.aia (6.5 KB)

working perfectly, thank you. you are amazing

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.