# How to show random image with describe text from google sheet

**URL:** <https://community.thunkable.com/t/how-to-show-random-image-with-describe-text-from-google-sheet/1798605>\
**Category:** Questions about Thunkable X\
**Created:** [March 23, 2022, 3:34pm UTC](https://community.thunkable.com/t/how-to-show-random-image-with-describe-text-from-google-sheet/1798605 "2022-03-23T15:34:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![kethmany.ratsavongy](https://avatars.discourse-cdn.com/v4/letter/k/c57346/32.png) [@kethmany.ratsavongy](https://community.thunkable.com/u/kethmany.ratsavongy)\
**Post date:** [March 23, 2022, 3:34pm UTC](https://community.thunkable.com/t/how-to-show-random-image-with-describe-text-from-google-sheet/1798605/1 "2022-03-23T15:34:31Z")

</div>

I would like to show the random image with its description text that datastore in google sheet, it not working, could any one help, this is my blocks:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/b/4bca0c58e3804240c5a7858522717a74b94f2bc9.png)

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [March 23, 2022, 3:55pm UTC](https://community.thunkable.com/t/how-to-show-random-image-with-describe-text-from-google-sheet/1798605/2 "2022-03-23T15:55:04Z")

</div>

The row id is the row # of the data source. So you have to provide an integer or a row ID (which is a long string of characters that can be found in the list of values column “ID”). You have a blank row id for the set Picture block which is why it’s not working.

---

<div class="post-metadata">

**Author:** ![kethmany.ratsavongy](https://avatars.discourse-cdn.com/v4/letter/k/c57346/32.png) [@kethmany.ratsavongy](https://community.thunkable.com/u/kethmany.ratsavongy)\
**Post date:** [April 5, 2022, 9:46pm UTC](https://community.thunkable.com/t/how-to-show-random-image-with-describe-text-from-google-sheet/1798605/3 "2022-04-05T21:46:46Z")

</div>

thank you Tatiang, I have put the row ID but it is still not working, is this correct or not ?

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/1/81619b46ac708ac61b6458ad382832e8af1651b8.png)  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/3/63cfe5a20ec4200e678cef91b0d5cd3e2d187c3f.png)

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [April 5, 2022, 10:24pm UTC](https://community.thunkable.com/t/how-to-show-random-image-with-describe-text-from-google-sheet/1798605/4 "2022-04-05T22:24:58Z")

</div>

No, that is not correct. The row id cannot be a phrase such as “Image Protein menu”. It should be a number such as 1 or 2. Or a row ID which is _only_ generated by Thunkable, not by you. You can see an example of that here:

> [@\[Solved\] Can I use a variable to store a Data Viewer Row ID?](https://community.thunkable.com/t/solved-can-i-use-a-variable-to-store-a-data-viewer-row-id/581375):
>
> Hi, [https://x.thunkable.com/copy/17f4d8be352460ca73aca03b8aaccb94](https://x.thunkable.com/copy/17f4d8be352460ca73aca03b8aaccb94) Please take a look at the project above. In screen 2, why the “get value from” can’t fetch correct data from the table1 by using a variable in row id slot? It works when assigning row id to a specific number, e.g. “1”. Am I assigning the variable in the wrong way? Thanks

Unfortunately, there is currently a bug with the `get value` blocks. They do not retrieve updated values from Google Sheets or Airtable. I’ve reported the bug here:

> <https://github.com/thunkable/thunkable-issues/issues/1138>
>
> \### Platform
> Drag and Drop UI - web?
> Drag and Drop UI - iOS?
> 
> \### Steps to R…eproduce
> 1. Click the "Get & update values" button to get and display a value from a Google Sheet cell (e.g. 4), and update the value by one (e.g. 4+1).
> 3. Wait a few seconds (or more) and click the "Get new value" button.
> 
> \### Expected Behavior
> I would expect the second time the value is displayed that it includes the added value (e.g. 5).
> 
> \### Actual Behavior
> The second time the value is displayed, it shows the original value (e.g. 4).
> 
> \### Project Link
> https://x.thunkable.com/copy/1feeef38c13e4150815598a95155e283
> 
> \###Community Link
> https://community.thunkable.com/t/cant-get-value-from-google-sheets/1816128
> 
> \`\`\`
> STACK TRACE AND/OR SCREENSHOTS
> \`\`\`

---

<div class="post-metadata">

**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:** [July 4, 2022, 10:25pm UTC](https://community.thunkable.com/t/how-to-show-random-image-with-describe-text-from-google-sheet/1798605/5 "2022-07-04T22:25:26Z")

</div>

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