# Get Object from json using GetColumn **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [July 10, 2019, 4:05pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730 "2019-07-10T16:05:28Z")\ **Posts on this page:** 18\ **Page:** 2
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [July 11, 2019, 4:57pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/21 "2019-07-11T16:57:06Z")
> [@sysads](#): > > basically i want the images to be displayed as background on each button This is a limit because you are using a limit buttons! Set it the same screen shot I already sent but change the row number with 1 or 2 or 3 ---
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 11, 2019, 7:14pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/22 "2019-07-11T19:14:06Z")
Hmm this didn’t work. What it id was display in each listview the actual URl of the image and not image as listview does not have option for background image ---
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [July 11, 2019, 7:18pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/23 "2019-07-11T19:18:03Z")
I told you to set the button background picture instead of list viewer and set row number to 1 or 2 or 3 etc ---
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 11, 2019, 7:19pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/24 "2019-07-11T19:19:20Z")
Yea I know that but does that mean i have to create 10 to 20 getcolumn for this per button? Is there no easy way of extracting all image url into a list and then for each button background get 1 or 2 or 3 etc ---
**Author:** ![CBVG](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/cbvg/32/32401_2.png) [@CBVG](https://community.thunkable.com/u/CBVG)\ **Post date:** [July 11, 2019, 7:29pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/25 "2019-07-11T19:29:15Z")
If your definition of easy implies “no programming”, then no. You have to do the programming. ---
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 11, 2019, 7:30pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/26 "2019-07-11T19:30:04Z")
hahaha, I think I might have a solution to this once and for all ---
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [July 11, 2019, 8:20pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/27 "2019-07-11T20:20:53Z")
> [@sysads](#): > > Is there no easy way of extracting all image url into a list and then for each button background get 1 or 2 or 3 etc Of course there is. See this screen shot. You can set button 1 and 2 and whatever you like in the same way. ![Capture](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/5/f50fbe10950f8abbf6c88a5e76ba1354f327ecd8.png) ---
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 11, 2019, 8:27pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/28 "2019-07-11T20:27:19Z")
Trust me, this was the very first thing I did and it didn’t work ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/6/46dc37c74c6143ef09bde1813c2869eb95f9b81f.png) ---
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [July 11, 2019, 8:32pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/29 "2019-07-11T20:32:39Z")
> [@sysads](#): > > Trust me, this was the very first thing I did and it didn’t work Please set your blocks as mine exactly and set the Column type in Spreadsheet Air Table to A single line text. It works 100%. You can send me your app link if it does not work with you. Again please follow the steps I told you 100%. ---
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 11, 2019, 8:38pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/30 "2019-07-11T20:38:38Z")
Ah wait a minute, I now see where the issue was. Yes when i changed the column from attachment to single text, it converted the images already in the column to path to the image file but it also added the file name at the beginning. So removing the file name at the beginning fixed it 😆 Wow what a journey but thanks @Hayder for not giving up on me 🤗 ---
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [July 11, 2019, 8:45pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/31 "2019-07-11T20:45:31Z")
🤗🤩 Congrats mate! I told you in the second comment point number 1 to set the type to A single line text but I think you did not notice that. hhhhhhhh Congrats again mate! ![Capture](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/6/f66968d2b8b54ceaf32d317bddcff41af80cca80.png) ---
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 11, 2019, 8:47pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/32 "2019-07-11T20:47:44Z")
Yes I did notice that but like I said, it changed the images to path but also included image filename which I didn’t know at first I needed to remove that and only leave the path to file. BTW, if I need to add more images in future, how will I generate image file path? ---
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [July 11, 2019, 8:50pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/33 "2019-07-11T20:50:30Z")
> [@sysads](#): > > BTW, if I need to add more images in future, how will I generate image file path? Do you want to add images from your app and send them to your spreadsheet table? ---
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 11, 2019, 8:51pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/34 "2019-07-11T20:51:10Z")
No I manually add images to spreadsheet and app will call that image ---
**Author:** ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)\ **Post date:** [July 11, 2019, 9:02pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/35 "2019-07-11T21:02:39Z")
Do you use Media DB or not? ---
**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\ **Post date:** [July 11, 2019, 9:14pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/36 "2019-07-11T21:14:22Z")
no but should i use that? ---
**Author:** ![kartik\_old](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik_old/32/28305_2.png) [@kartik\_old](https://community.thunkable.com/u/kartik_old)\ **Post date:** [July 12, 2019, 12:47am UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/37 "2019-07-12T00:47:28Z")
Hello there, The [Cloudinary DB/ Media DB](https://docs.thunkable.com/media-db), is used for (in general language) **hosting images/videos/audio online**. Instead of doing manually, you can command your app to upload images. Hope it helps! 😉 ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 12:12pm UTC](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730/38 "2024-11-08T12:12:17Z")
[Previous page](https://community.thunkable.com/t/get-object-from-json-using-getcolumn/138730.md?page=1)