How do I make thunkable display a value from my google sheets table?

Questions about Thunkable
1

Hi all,

Apologies if this has already been posted - I couldn’t seem to find it and its a very basic question:

I am trying to get the balance ($1,000) displayed on my label retrieved from my table in a google sheets doc. Why does it display null instead? Is it something to do with not having a green “Row ID” block? Where does this come from?

thunkable
thunkable898×402 23.2 KB

thunkable db

Thanks in advance.

2

Hi, row ID isn’t the position in the sheet but a unique id of the row.
There is a block to get the list of the column you need , also ID column.
If you need the row number 3 of your sheet you have to retrieve the ID in the third position in ID list and use it in the block. The object block doesn’t work with that get value because,with the right value of ID , already give you the value you need .
Instead if you call the entire row you can use the object block to select the right value

3

Hi Goldking, thanks for the response.

“There is a block to get the list of the column you need , also ID column”

Where can I find this block?

4

List of values , click the value to show the menu and select the right column or sheet

Screenshot_20231212-000207~2
Screenshot_20231212-000207~21080×694 54.4 KB

5

Makes sense - if there were multiple rows in my table, how would I tell Thunkable which row in the column to display?

E.g. if the table looked like:

Balance
£1,000
£2,000 ← How could I ensure it returns the value on this row?
£5,000

6

The right or clever structure of the database could give you a big hand :sweat_smile:
Anyway you can use a listview or simile to show your data and easily select the right value, this kind of component already have the row ID connected with the item click.
If you don’t want to use a component to display data you have to search the item manually in the column , with his index go in the ID list and retrieve the ID value .

7

Here the data viewer Docs

In your example there isn’t a connection to make a search . You want the biggest one ? You want the value connected to a username or a date :man_shrugging:t2:
Why you want that value ?
You have to build the table to be able to create a query to find the value you need .
I hope it’s clear :sweat_smile:

8

Got it, thanks for your help!

1 Like
9

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