# How to view an attachment (Excel , word) of a chosen record from airtable

**URL:** <https://community.thunkable.com/t/how-to-view-an-attachment-excel-word-of-a-chosen-record-from-airtable/1078220>\
**Category:** Questions about Thunkable X\
**Created:** [February 1, 2021, 7:11pm UTC](https://community.thunkable.com/t/how-to-view-an-attachment-excel-word-of-a-chosen-record-from-airtable/1078220 "2021-02-01T19:11:30Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![ealalin13s68](https://avatars.discourse-cdn.com/v4/letter/e/e5b9ba/32.png) [@ealalin13s68](https://community.thunkable.com/u/ealalin13s68)\
**Post date:** [February 1, 2021, 7:11pm UTC](https://community.thunkable.com/t/how-to-view-an-attachment-excel-word-of-a-chosen-record-from-airtable/1078220/1 "2021-02-01T19:11:30Z")

</div>

From Airtable I want to view from the first record a ![Screenshot 2021-02-01 194310](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/e/9ea5dbf0fba26cd39a317178185a16d97d46773d.png) excel doc from the column “Attachments”  
From in airtable call GetCell with the rowNum 1 and columnName “Attachments” I get a value when i display it it’s a object I can not pass it into a image the Get propriety of object with the propriety name “attachments” does not show anything

 ![Screenshot 2021-02-01 195645](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/7/f79f748f99a0fbe884cdaf8f2b2ccb01a9c5f8fe.png)  
I can get the JSON format of the Object value.

{“id”:“attG8nPXiowxB70VW”,“url”:“[https://dl.airtable.com/.attachments/1f3d5b146299eff18cc0d43c6827fdb9/e837f5a5/The10Factorsoflive.xlsx",“filename”:"The](https://dl.airtable.com/.attachments/1f3d5b146299eff18cc0d43c6827fdb9/e837f5a5/The10Factorsoflive.xlsx%22,%22filename%22:%22The) 10 Factors of live.xlsx”,“size”:18689,“type”:“application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”,“thumbnails”:{“small”:{“url”:“**[https://dl.airtable.com/attG8nPXiowxB70VW-c90d94a92aef5226-32x32.jpg](https://dl.airtable.com/attG8nPXiowxB70VW-c90d94a92aef5226-32x32.jpg)**”,“width”:32,“height”:32},“large”:{“url”:“**[https://dl.airtable.com/attG8nPXiowxB70VW-49c4d34fb0db2969-320x226.jpg](https://dl.airtable.com/attG8nPXiowxB70VW-49c4d34fb0db2969-320x226.jpg)**”,“width”:320,“height”:226}}}]

If I use one of the URL I can see the excel file passing this URL to a image.

The problem that I get is how to select this url from the JSON file to pass it automatically to Thunkable ?

 ![Screenshot 2021-02-01 200857](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/0/704109fd2240f3f14ce8a0599eab2bbeae9cb4c8.png)

---

<div class="post-metadata">

**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:** [February 1, 2021, 7:49pm UTC](https://community.thunkable.com/t/how-to-view-an-attachment-excel-word-of-a-chosen-record-from-airtable/1078220/2 "2021-02-01T19:49:47Z")

</div>

The correct JSON structure is `thumbnails/large/url` you missed one level.

---

<div class="post-metadata">

**Author:** ![ealalin13s68](https://avatars.discourse-cdn.com/v4/letter/e/e5b9ba/32.png) [@ealalin13s68](https://community.thunkable.com/u/ealalin13s68)\
**Post date:** [February 2, 2021, 3:24pm UTC](https://community.thunkable.com/t/how-to-view-an-attachment-excel-word-of-a-chosen-record-from-airtable/1078220/3 "2021-02-02T15:24:23Z")

</div>

muneer thx for your replay  
I have try it but still does not work

 ![Screenshot 2021-02-02 160247](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/5/e58e2a96388a26cd3c551d76c27693f5aa1feccd.png)

I receive nothing in the ImageEventAttachmentAirT\_Scr6  
I receive nothing in the Text\_Input\_Result\_Scr6 .

It’s strange because when I copy the url and past it manually as text into the ImageEventAttachmentAirT\_Scr6 then I receive the excel image into my screen  
I copy into a text format this : **[https://dl.airtable.com/attG8nPXiowxB70VW-c90d94a92aef5226-32x32.jpg](https://dl.airtable.com/attG8nPXiowxB70VW-c90d94a92aef5226-32x32.jpg)**

 ![Screenshot 2021-02-02 161948](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/f/cf5b9275815df63c50d88eee14a68c0f7adddb73.png)

 ![Screenshot 2021-02-02 161846](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/d/4dd27dc59821bc7208059eddb3ee547bc795027f.png)

---

<div class="post-metadata">

**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:** [February 2, 2021, 3:49pm UTC](https://community.thunkable.com/t/how-to-view-an-attachment-excel-word-of-a-chosen-record-from-airtable/1078220/4 "2021-02-02T15:49:50Z")

</div>

I can spot in the screenshot that the JSON string starts with `[` which means you need to include it in a` Thunkable list` to be able to read it correctly. This was not in the sample text you copied in your earlier post.

> [@ealalin13s68](#):
>
> {“id”:“attG8nPXiowxB70VW”,“url”:“[https://dl.airtable.com/.attachments/1f3d5b146299eff18cc0d43c6827fdb9/e837f5a5/The10Factorsoflive.xlsx",“filename”:"The](https://dl.airtable.com/.attachments/1f3d5b146299eff18cc0d43c6827fdb9/e837f5a5/The10Factorsoflive.xlsx%22,%22filename%22:%22The) 10 Factors of live.xlsx”,“size”:18689,“type”:“application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”,“thumbnails”:{“small”:{“url”:“\*\*[https://dl.airtable.com/attG8nPXiowxB70VW-c90d94a92aef5226-32x32.jpg\*\*”,“width”:32,“height”:32](https://dl.airtable.com/attG8nPXiowxB70VW-c90d94a92aef5226-32x32.jpg**%E2%80%9D,%E2%80%9Cwidth%E2%80%9D:32,%E2%80%9Cheight%E2%80%9D:32)},“large”:{“url”:“\*\*[https://dl.airtable.com/attG8nPXiowxB70VW-49c4d34fb0db2969-320x226.jpg\*\*”,“width”:320,“height”:226](https://dl.airtable.com/attG8nPXiowxB70VW-49c4d34fb0db2969-320x226.jpg**%E2%80%9D,%E2%80%9Cwidth%E2%80%9D:320,%E2%80%9Cheight%E2%80%9D:226)}}}]

---

<div class="post-metadata">

**Author:** ![ealalin13s68](https://avatars.discourse-cdn.com/v4/letter/e/e5b9ba/32.png) [@ealalin13s68](https://community.thunkable.com/u/ealalin13s68)\
**Post date:** [February 2, 2021, 5:35pm UTC](https://community.thunkable.com/t/how-to-view-an-attachment-excel-word-of-a-chosen-record-from-airtable/1078220/5 "2021-02-02T17:35:11Z")

</div>

muneer;  
I had notice it when I had use the [JSON Formatter & Validator](https://jsonformatter.curiousconcept.com/#) to order my JSON file.  
I have already put the string to a list

 ![Screenshot 2021-02-02 182919](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/1/71eb3579f673116def87c68d9d7e4ea2c3ec6523.png)  
I display it in the Text\_Input\_Result\_Scr6 and I still have The !!!

**[**{“id”:“attG8nPXiowxB70VW”,“url”:“[https://dl.airtable.com/.attachments/1f3d5b146299eff18cc0d43c6827fdb9/e837f5a5/The10Factorsoflive.xlsx",“filename”:"The](https://dl.airtable.com/.attachments/1f3d5b146299eff18cc0d43c6827fdb9/e837f5a5/The10Factorsoflive.xlsx%22,%22filename%22:%22The) 10 Factors of live.xlsx”,“size”:18689,“type”:“application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”,“thumbnails”:{“small”:{“url”:“[https://dl.airtable.com/attG8nPXiowxB70VW-c90d94a92aef5226-32x32.jpg",“width”:32,“height”:32},“large”:{“url”:“https://dl.airtable.com/attG8nPXiowxB70VW-49c4d34fb0db2969-320x226.jpg”,“width”:320,"height](https://dl.airtable.com/attG8nPXiowxB70VW-c90d94a92aef5226-32x32.jpg%22,%22width%22:32,%22height%22:32%7D,%22large%22:%7B%22url%22:%22https://dl.airtable.com/attG8nPXiowxB70VW-49c4d34fb0db2969-320x226.jpg%22,%22width%22:320,%22height)”:226}}}**]**  
**strong text**

---

<div class="post-metadata">

**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:** [February 3, 2021, 4:28pm UTC](https://community.thunkable.com/t/how-to-view-an-attachment-excel-word-of-a-chosen-record-from-airtable/1078220/6 "2021-02-03T16:28:28Z")

</div>

The way you use the list is not the correct way. Because I do not have access to your files, I created a simple example here

[https://x.thunkable.com/projectPage/601a3b5409a2110013ef7198](https://x.thunkable.com/projectPage/601a3b5409a2110013ef7198)

I made a JSON list in the variable which is in the place of what you will receive from your Airtable GetCell and then worked on it to show how you read JSON data inside a list.

---

<div class="post-metadata">

**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:** [February 4, 2021, 7:01am UTC](https://community.thunkable.com/t/how-to-view-an-attachment-excel-word-of-a-chosen-record-from-airtable/1078220/7 "2021-02-04T07:01:52Z")

</div>

@ealalin13s68  
I copied the JSON string from your post and inserted it in my project to show you a more meaningful example.

Please copy this project  
[https://x.thunkable.com/projectPage/601b983e69be43059fb7d727](https://x.thunkable.com/projectPage/601b983e69be43059fb7d727)

---

<div class="post-metadata">

**Author:** ![ealalin13s68](https://avatars.discourse-cdn.com/v4/letter/e/e5b9ba/32.png) [@ealalin13s68](https://community.thunkable.com/u/ealalin13s68)\
**Post date:** [February 6, 2021, 4:42pm UTC](https://community.thunkable.com/t/how-to-view-an-attachment-excel-word-of-a-chosen-record-from-airtable/1078220/8 "2021-02-06T16:42:01Z")

</div>

Thx Muneer it help .

---

<div class="post-metadata">

**Author:** ![ealalin13s68](https://avatars.discourse-cdn.com/v4/letter/e/e5b9ba/32.png) [@ealalin13s68](https://community.thunkable.com/u/ealalin13s68)\
**Post date:** [February 9, 2021, 5:02pm UTC](https://community.thunkable.com/t/how-to-view-an-attachment-excel-word-of-a-chosen-record-from-airtable/1078220/9 "2021-02-09T17:02:04Z")

</div>

Muneer hello directly to you because i know that you have the expertise.  
I want to use a link from a link field from my Airtable database:

 ![Screenshot 2021-02-09 164722](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/e/fe5f4f65f960e880e25156a755069e34f14411bd.png)

I receive a JSON answer after a AirTable get row (rouw number 1 in my test) .it’s the first part of the following sentence:

{“Editor”:“Alain”,“Attachments”:[{“id”:“attG8nPXiowxB70VW”,“url”:“[https://dl.airtable.com/.attachments/1f3d5b146299eff18cc0d43c6827fdb9/e837f5a5/The10Factorsoflive.xlsx",“filename”:"The](https://dl.airtable.com/.attachments/1f3d5b146299eff18cc0d43c6827fdb9/e837f5a5/The10Factorsoflive.xlsx%22,%22filename%22:%22The) 10 Factors of live.xlsx”,“size”:18689,“type”:“application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”,“thumbnails”:{“small”:{“url”:“[https://dl.airtable.com/attG8nPXiowxB70VW-c90d94a92aef5226-32x32.jpg",“width”:32,“height”:32},“large”:{“url”:“https://dl.airtable.com/attG8nPXiowxB70VW-49c4d34fb0db2969-320x226.jpg”,“width”:320,“height”:226}}}],“Notes”:"Info](https://dl.airtable.com/attG8nPXiowxB70VW-c90d94a92aef5226-32x32.jpg%22,%22width%22:32,%22height%22:32%7D,%22large%22:%7B%22url%22:%22https://dl.airtable.com/attG8nPXiowxB70VW-49c4d34fb0db2969-320x226.jpg%22,%22width%22:320,%22height%22:226%7D%7D%7D%5D,%22Notes%22:%22Info) modifie”,“Name”:“Modified”,“URL”:“[Https://cloudinary.com](Https://cloudinary.com)”,“Photo”:“[http://res.cloudinary.com/ealalin2020/image/upload/v1611863376/piiujiqce6euhdeknr1f.jpg",“ID”:1,“Date”:“2021-01-02”,"\_id":"recS8STL42p9rIJ80](http://res.cloudinary.com/ealalin2020/image/upload/v1611863376/piiujiqce6euhdeknr1f.jpg%22,%22ID%22:1,%22Date%22:%222021-01-02%22,%22_id%22:%22recS8STL42p9rIJ80)”}

{  
“Editor”:“Alain”,  
“Attachments”:[  
{  
“id”:“attG8nPXiowxB70VW”,  
“url”:“[https://dl.airtable.com/.attachments/1f3d5b146299eff18cc0d43c6827fdb9/e837f5a5/The10Factorsoflive.xlsx](https://dl.airtable.com/.attachments/1f3d5b146299eff18cc0d43c6827fdb9/e837f5a5/The10Factorsoflive.xlsx)”,  
“filename”:“The 10 Factors of live.xlsx”,  
“size”:18689,  
“type”:“application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”,  
“thumbnails”:{  
“small”:{  
“url”:“[https://dl.airtable.com/attG8nPXiowxB70VW-c90d94a92aef5226-32x32.jpg](https://dl.airtable.com/attG8nPXiowxB70VW-c90d94a92aef5226-32x32.jpg)”,  
“width”:32,  
“height”:32  
},  
“large”:{  
“url”:“[https://dl.airtable.com/attG8nPXiowxB70VW-49c4d34fb0db2969-320x226.jpg](https://dl.airtable.com/attG8nPXiowxB70VW-49c4d34fb0db2969-320x226.jpg)”,  
“width”:320,  
“height”:226  
}  
}  
}  
],  
“Notes”:“Info modifie”,  
“Name”:“Modified”,  
“URL”:“[Https://cloudinary.com](Https://cloudinary.com)”,  
“Photo”:“[http://res.cloudinary.com/ealalin2020/image/upload/v1611863376/piiujiqce6euhdeknr1f.jpg](http://res.cloudinary.com/ealalin2020/image/upload/v1611863376/piiujiqce6euhdeknr1f.jpg)”,  
“ID”:1,  
“Date”:“2021-01-02”,  
“\_id”:“recS8STL42p9rIJ80”  
}

Here is the bloc of my test:

 ![Screenshot 2021-02-09 174131](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/4/c4ab84e79bb81f5dd20e22aa2202560a278e48de.png)

I don’t receive in the label the name of the editoor , and I don’t receive in the button test the text from my URL in this case " [Https://cloudinary.com](Https://cloudinary.com)" !!!  
what I want to do is receive the URL in the text Button and when I will push to the button I will open a link with this URL . But first I have to receive this URL information .  
It’s to notice that the answer from JSON have no " "

---

<div class="post-metadata">

**Author:** ![ealalin13s68](https://avatars.discourse-cdn.com/v4/letter/e/e5b9ba/32.png) [@ealalin13s68](https://community.thunkable.com/u/ealalin13s68)\
**Post date:** [February 9, 2021, 5:05pm UTC](https://community.thunkable.com/t/how-to-view-an-attachment-excel-word-of-a-chosen-record-from-airtable/1078220/10 "2021-02-09T17:05:26Z")

</div>

The JSON answer have no “[” and no “]”

---

<div class="post-metadata">

**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:** [February 9, 2021, 5:50pm UTC](https://community.thunkable.com/t/how-to-view-an-attachment-excel-word-of-a-chosen-record-from-airtable/1078220/11 "2021-02-09T17:50:09Z")

</div>

Please note that both Editor and URL are outside of the list and therefore you can call them this way

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/e/7e01fa3680ac0ba410f7c6e42cad3ee75f9710b3.png)

The answer is this

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/c/7cb3c5e603964e9e0bdb59d567f419d8d3153898.png)

Hope this is clear

---

<div class="post-metadata">

**Author:** ![ealalin13s68](https://avatars.discourse-cdn.com/v4/letter/e/e5b9ba/32.png) [@ealalin13s68](https://community.thunkable.com/u/ealalin13s68)\
**Post date:** [February 9, 2021, 8:27pm UTC](https://community.thunkable.com/t/how-to-view-an-attachment-excel-word-of-a-chosen-record-from-airtable/1078220/12 "2021-02-09T20:27:19Z")

</div>

Thanks very much muneer; it works

---

<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, 1:29pm UTC](https://community.thunkable.com/t/how-to-view-an-attachment-excel-word-of-a-chosen-record-from-airtable/1078220/13 "2024-11-08T13:29:37Z")

</div>