Hi. I am trying to do a search bar that would return a corresponding value to the item i searched in my google sheets. For example, column A in my sheets are names. when i searched “james”, it would return the value corresponding it in column B. I have included a text_input, a label and a search_bu…

The way to do this is to use the find first occurrence of List block ( here ) with the list of values block (in this section of the documentation) from your Data Source and assign that to a variable called something like foundRowNum. Then Get Value from column B using foundRowNum as the row ID. Here…

[image] im so sorry but how do i continue from here

Instead of using the does list contain block, use the find first occurrence of block. You can see how to set that up in the link I provided above.

[image] is it something like this?

That will search the column “Name” in your data source for the Text Input’s text and store the row number in name1. To then get the value from the same row, put name1 into the “for row id” section of the get value block. [Screenshot 2023-05-31 at 9.01.10 PM]

[image] thank you so much. you are so good at this

How should I do if the user enter a person that is not in my google sheets? [image] But it doesnt work. pls advise

Avoid using the [gear list] block. The list of values block is already a list so you don’t need to use that extra list block. [Screenshot 2023-06-01 at 5.27.17 AM]

how do i modify the code such that when a name is entered, it would take the best out of the 3 readings. [image] [image] for example, if i search James, it would return 1.75. if i search Alan, it would return 5.75. however, if i search Mike who only has 1 reading, it will just give me 2.15 whi…

Thunkable and returns a corresponding value from my sheet

Questions about Thunkable X

blvckrosesssppi June 1, 2023, 3:09pm 10

Thank you

How do I filter data from a local database from results from another database?

Topic		Replies	Views
How to create a search engine from text input, based on data from couple columns - google sheets Questions about Thunkable X design , beginner , google-sheets	16	1603	March 23, 2022
Create search bar for Google Sheets data Questions about Thunkable X design , beginner , help	5	2284	December 8, 2021
How to search student details by name from Google Sheet in Thunkable? Questions about Thunkable X beginner , spreadsheets , help , search , google-sheets	2	60	May 16, 2025
Como fazer buscar no thunkable? Questions about Thunkable X	8	239	January 20, 2024
How to get a value from google sheets? Questions about Thunkable X beginner	16	512	June 4, 2021

Thunkable and returns a corresponding value from my sheet

Related topics