I am having like this data in google sheet, Suppose if my student enter his number (say 989) and hit search button how can i get remaining details in separate box? (ie. Name in Text box 2, std in text box 3, sec in text box 4)
I was tried with these blocks but unable to get data in text box 2. If get mean reaming box i will adjust it.
Please dont recommend to use cloudsheet extension. I dont want to use paid extensions…
But
I use google spreadsheet for saving some data, and if want to download some value, i use query ex select B where A = text_box1.value. and i got text what i looking for.