# Get URL Element using GetColumn

**URL:** https://community.thunkable.com/t/get-url-element-using-getcolumn/94314
**Category:** Questions about Thunkable X
**Created:** [June 6, 2019, 3:01pm UTC](https://community.thunkable.com/t/get-url-element-using-getcolumn/94314 "2019-06-06T15:01:23Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### 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: [June 6, 2019, 3:01pm UTC](https://community.thunkable.com/t/get-url-element-using-getcolumn/94314/1 "2019-06-06T15:01:23Z")

</div>

I have a spreadsheet with images in column A. I am trying to get all images into a variable and get each url values to be used as background to multiple button.

The json generated looks fine but for some reason its not displaying the images.

The only difference between using GetCell and GetColumn is that

GetCell json format encloses entire string with a single bracket [(xxxxxx)]  
GetColumn json encloses entire string with double bracket [[(xxxxx)]]

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/5/95bf2a7343a3d72c2b88d1829305cf6ef992d1b5.png)

---

<div class="post-metadata">

### Author: ![Mark](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/mark/32/18133_2.png) [@Mark](https://community.thunkable.com/u/Mark)
#### Post date: [June 7, 2019, 12:05am UTC](https://community.thunkable.com/t/get-url-element-using-getcolumn/94314/2 "2019-06-07T00:05:06Z")

</div>

> [@sysads](#):
>
> GetColumn json encloses entire string with double bracket [[(xxxxx)]]

That double bracket syntax for the column indicates that it is a list of lists. For your example above, you’ll want to first get the first item in that list. That essentially will get you what GetCell would provide. Let’s call that `'app PostImage'` Then you can do what I described in [my post about getting image URLs from Airtable](http://community.thunkable.com/t/how-to-retrieve-images-with-a-spreadsheet-component/28670). That is, to get the image URL you’ll want to get the first element of out of `'app PostImage'` and then the ‘url’ property of that object.

-Mark

---

<div class="post-metadata">

### 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: [June 7, 2019, 4:33am UTC](https://community.thunkable.com/t/get-url-element-using-getcolumn/94314/3 "2019-06-07T04:33:40Z")

</div>

Can you show me an example? Thanks

---

<div class="post-metadata">

### 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: [June 7, 2019, 10:03am UTC](https://community.thunkable.com/t/get-url-element-using-getcolumn/94314/4 "2019-06-07T10:03:31Z")

</div>

Holding off my app for now as I need features to help me finish it. When are we likely to see new releases?

For listview, I just need a way to list images one side and text with sub-text or images on opposite side.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/9/6933efa56763d74cae727eaf112c8ba27c06b1d3.jpeg)

---

<div class="post-metadata">

### Author: ![Mark](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/mark/32/18133_2.png) [@Mark](https://community.thunkable.com/u/Mark)
#### Post date: [June 7, 2019, 10:11pm UTC](https://community.thunkable.com/t/get-url-element-using-getcolumn/94314/5 "2019-06-07T22:11:59Z")

</div>

> [@sysads](#):
>
> Holding off my app for now as I need features to help me finish it. When are we likely to see new releases?

We’ve been doing new releases on a regular basis. A list of our latest release notes can be found [here](https://docs.thunkable.com/release-notes).

-Mark

---

<div class="post-metadata">

### Author: ![Mark](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/mark/32/18133_2.png) [@Mark](https://community.thunkable.com/u/Mark)
#### Post date: [June 7, 2019, 10:17pm UTC](https://community.thunkable.com/t/get-url-element-using-getcolumn/94314/6 "2019-06-07T22:17:01Z")

</div>

> [@sysads](#):
>
> For listview, I just need a way to list images one side and text with sub-text or images on opposite side.

We’re in the process of making some changes to our core software architecture that will allow something like what you want (and lots more) to be done quite easily! I think you and the rest of our users will really like it. No promises yet on exactly when this stuff will get released but it is something we are very actively working on.

-Mark

---

<div class="post-metadata">

### 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 10, 2019, 3:52pm UTC](https://community.thunkable.com/t/get-url-element-using-getcolumn/94314/7 "2019-07-10T15:52:27Z")

</div>

> [@Mark](#):
>
> That double bracket syntax for the column indicates that it is a list of lists. For your example above, you’ll want to first get the first item in that list. That essentially will get you what GetCell would provide. Let’s call that `'app PostImage'` Then you can do what I described in [my post about getting image URLs from Airtable](http://community.thunkable.com/t/how-to-retrieve-images-with-a-spreadsheet-component/28670). That is, to get the image URL you’ll want to get the first element of out of `'app PostImage'` and then the ‘url’ property of that object.
> 
> -Mark

Hi Mark, I never got to get around this. Can you show me sample blocks to use to get the nested values.

---

<div class="post-metadata">

### 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-url-element-using-getcolumn/94314/8 "2024-11-08T12:12:16Z")

</div>


