# \[Solved\] Displaying images like ads in app from spreadsheet **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** solved, spreadsheets\ **Created:** [July 7, 2022, 3:09am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124 "2022-07-07T03:09:47Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![versatile](https://avatars.discourse-cdn.com/v4/letter/v/c68b51/32.png) [@versatile](https://community.thunkable.com/u/versatile)\ **Post date:** [July 7, 2022, 3:09am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/1 "2022-07-07T03:09:47Z")
How can I retrieve images from spreadsheet and display them one after the other in my app?. currently it displays properly,using the when screen open component,and blocking it to get specific images uploaded to the app files. but i would love to get images from Airtable spreadsheet @tatiang @muneer ---
**Author:** ![zander](https://avatars.discourse-cdn.com/v4/letter/z/ecb155/32.png) [@zander](https://community.thunkable.com/u/zander)\ **Post date:** [July 7, 2022, 5:03am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/2 "2022-07-07T05:03:38Z")
Please don’t tag people, if they can answer they will. 🙂 As for your question, you can connect your airtable as a data source within your app. From there you can loop through each row and display it either through a data viewer or an image placeholder depending on your usecase. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 7, 2022, 7:26am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/3 "2022-07-07T07:26:12Z")
What is available in the Airtable sheet? The URL of the image or the image itself? If the URL is saved in the sheet then you need to loop through the table to display the images by assigning the URL from the table to the `Picture` property of the `image component`. You may need to place this inside a `timer` to change the images every so and then. ---
**Author:** ![versatile](https://avatars.discourse-cdn.com/v4/letter/v/c68b51/32.png) [@versatile](https://community.thunkable.com/u/versatile)\ **Post date:** [July 7, 2022, 6:21pm UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/4 "2022-07-07T18:21:59Z")
The images itself is what I have in the spreadsheet ---
**Author:** ![versatile](https://avatars.discourse-cdn.com/v4/letter/v/c68b51/32.png) [@versatile](https://community.thunkable.com/u/versatile)\ **Post date:** [July 7, 2022, 6:22pm UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/5 "2022-07-07T18:22:56Z")
Noted, thanks ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 7, 2022, 8:05pm UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/6 "2022-07-07T20:05:02Z")
In Airtable, all attachment fields have extra JSON sets which include a private URL for both a thumbnail and a full image which you can use to view the images. **[Update]** The URL generated by Airtable would be looking like this ```auto https://dl.airtable.com/.attachments/1f3d5b146299eff18cc0d43c6827fdb9/e837f5a5/The10Factorsoflive.xlsx ``` ---
**Author:** ![versatile](https://avatars.discourse-cdn.com/v4/letter/v/c68b51/32.png) [@versatile](https://community.thunkable.com/u/versatile)\ **Post date:** [July 8, 2022, 7:57am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/7 "2022-07-08T07:57:33Z")
So how do I block this ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 8, 2022, 8:51am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/8 "2022-07-08T08:51:16Z")
Use the `get row block` to see the added JSON information in the `Attachment` field. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 8, 2022, 10:42am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/9 "2022-07-08T10:42:32Z")
If you have added the image directly to the Airtable column, Airtable will automatically add your image to the Attachment column of your table and will provide the generated URL of your image in the column. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/c/ec6015e15c2b28523c55d6a3e1c94ce52e3dc9a0.png) This way you can get the image URL using the `get value` block or any other `Data Sources` or `Data Viewer List` blocks ---
**Author:** ![versatile](https://avatars.discourse-cdn.com/v4/letter/v/c68b51/32.png) [@versatile](https://community.thunkable.com/u/versatile)\ **Post date:** [July 8, 2022, 10:49am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/10 "2022-07-08T10:49:14Z")
I do add the images but no URL was generated ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 8, 2022, 10:52am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/11 "2022-07-08T10:52:30Z")
> [@versatile](#): > > no URL was generated I wouldn’t be able to give more comments without seeing the actual table. If you can share your Airtable `table` or Airtable `base` then I can see the actual table setup and provides advice of how to go about it. You can send me the share link in DM if you do not want to share it here. ---
**Author:** ![versatile](https://avatars.discourse-cdn.com/v4/letter/v/c68b51/32.png) [@versatile](https://community.thunkable.com/u/versatile)\ **Post date:** [July 8, 2022, 10:54am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/12 "2022-07-08T10:54:15Z")
Ok…I will share that with you now ---
**Author:** ![versatile](https://avatars.discourse-cdn.com/v4/letter/v/c68b51/32.png) [@versatile](https://community.thunkable.com/u/versatile)\ **Post date:** [July 8, 2022, 10:56am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/13 "2022-07-08T10:56:10Z")
Check your DM ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 8, 2022, 10:57am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/14 "2022-07-08T10:57:55Z")
You sent me an invitation link where I have to supply email and password. Please send a share link instead. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 8, 2022, 11:28am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/15 "2022-07-08T11:28:48Z")
See this small demo ![Airtable-Ads](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/7/27e2ed62c1e659d56818039f8638f19419baa233.gif) This is the blocks that goes with it ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/0/c063aab5e8abd42a189deb8bbcf27ff62a87db5d.png) Hope this solves your issue. ---
**Author:** ![versatile](https://avatars.discourse-cdn.com/v4/letter/v/c68b51/32.png) [@versatile](https://community.thunkable.com/u/versatile)\ **Post date:** [July 8, 2022, 11:48am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/16 "2022-07-08T11:48:50Z")
fvck, @muneer you are such a genius thanks this was just the way i want it,of course i will make some adjustments ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 8, 2022, 11:54am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/17 "2022-07-08T11:54:28Z")
You can now safely remove the share from your Airtable table/base. Have Fun Thunking! ---
**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:** [October 6, 2022, 11:54am UTC](https://community.thunkable.com/t/solved-displaying-images-like-ads-in-app-from-spreadsheet/1955124/18 "2022-10-06T11:54:51Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.