Get Spesific Result Form TinyDB

[banyuparikesit (abiyyuyunanalfadhl)]

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)

[Still-learning (1-2-3-4...)]

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…

[banyuparikesit (abiyyuyunanalfadhl)]

This is my sample spradsheet

Data QR Code

Thanks for your support

[Still-learning (1-2-3-4...)]

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…

[Still-learning (1-2-3-4...)]

@banyuparikesit test this

SS_TinyDB_Result_1.aia (5.7 KB)

This is searching in tinydb

SS_TinyDB_Result2.aia (6.5 KB)

[banyuparikesit (abiyyuyunanalfadhl)]

working perfectly, thank you. you are amazing