How to put condition in spreadsheet to get in textbox where the primary key is kodebarang

hello i’m newbie, am using spreadsheet online for my database in mit app inventor, actually i can do post and get but, i have a problem in get where the condition is i want to get a row of name, satuan and asetawal where condition is if my textbox kode barang is filled and then textbox name, satuan and aset awal is auto filled, i neef help

Portal_AGI.aia (40.4 KB)
callconsumdb.txt (1.5 KB)
blocks (1) blocks (2)


You probably want to use a select query on the sheet:
See Taifun’s page on using a google sheet as a database:

Scroll down the page to find the SELECT section