# How do I make thunkable display a value from my google sheets table? **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner\ **Created:** [December 11, 2023, 9:18pm UTC](https://community.thunkable.com/t/how-do-i-make-thunkable-display-a-value-from-my-google-sheets-table/2746910 "2023-12-11T21:18:57Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![grant.mccallum](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/grant.mccallum/32/210541_2.png) [@grant.mccallum](https://community.thunkable.com/u/grant.mccallum)\ **Post date:** [December 11, 2023, 9:18pm UTC](https://community.thunkable.com/t/how-do-i-make-thunkable-display-a-value-from-my-google-sheets-table/2746910/1 "2023-12-11T21:18:57Z")
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](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/5/c575f24b93709b81646fb123dea3954c75b86e59.png) ![thunkable db](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/4/b4f778bd8cf9476927ab1eedb560fd0558777fb6.png) Thanks in advance. ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [December 11, 2023, 10:42pm UTC](https://community.thunkable.com/t/how-do-i-make-thunkable-display-a-value-from-my-google-sheets-table/2746910/2 "2023-12-11T22:42:02Z")
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 ---
**Author:** ![grant.mccallum](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/grant.mccallum/32/210541_2.png) [@grant.mccallum](https://community.thunkable.com/u/grant.mccallum)\ **Post date:** [December 11, 2023, 10:53pm UTC](https://community.thunkable.com/t/how-do-i-make-thunkable-display-a-value-from-my-google-sheets-table/2746910/3 "2023-12-11T22:53:57Z")
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? ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [December 11, 2023, 11:03pm UTC](https://community.thunkable.com/t/how-do-i-make-thunkable-display-a-value-from-my-google-sheets-table/2746910/4 "2023-12-11T23:03:57Z")
List of values , click the value to show the menu and select the right column or sheet > **[Data Sources Blocks](https://docs.thunkable.com/blocks/app-features/data-sources-blocks)** ![Screenshot_20231212-000207~2](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/8/e898b08d62790a05f90204b768150aa7bd114ce3.png) ---
**Author:** ![grant.mccallum](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/grant.mccallum/32/210541_2.png) [@grant.mccallum](https://community.thunkable.com/u/grant.mccallum)\ **Post date:** [December 11, 2023, 11:13pm UTC](https://community.thunkable.com/t/how-do-i-make-thunkable-display-a-value-from-my-google-sheets-table/2746910/5 "2023-12-11T23:13:28Z")
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 ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [December 11, 2023, 11:20pm UTC](https://community.thunkable.com/t/how-do-i-make-thunkable-display-a-value-from-my-google-sheets-table/2746910/6 "2023-12-11T23:20:43Z")
The right or clever structure of the database could give you a big hand 😅 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 . ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [December 11, 2023, 11:25pm UTC](https://community.thunkable.com/t/how-do-i-make-thunkable-display-a-value-from-my-google-sheets-table/2746910/7 "2023-12-11T23:25:44Z")
Here the data viewer [Docs](https://docs.thunkable.com/app-design/ui-components/data-components/data-viewers) 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 🤷🏻‍♂️ 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 😅 ---
**Author:** ![grant.mccallum](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/grant.mccallum/32/210541_2.png) [@grant.mccallum](https://community.thunkable.com/u/grant.mccallum)\ **Post date:** [December 11, 2023, 11:39pm UTC](https://community.thunkable.com/t/how-do-i-make-thunkable-display-a-value-from-my-google-sheets-table/2746910/8 "2023-12-11T23:39:40Z")
Got it, thanks for your help! ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [March 10, 2024, 11:39pm UTC](https://community.thunkable.com/t/how-do-i-make-thunkable-display-a-value-from-my-google-sheets-table/2746910/9 "2024-03-10T23:39:55Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.