# Problem reading an Airtable row

**URL:** <https://community.thunkable.com/t/problem-reading-an-airtable-row/2304404>\
**Category:** Questions about Thunkable X\
**Tags:** airtable\
**Created:** [March 2, 2023, 2:51pm UTC](https://community.thunkable.com/t/problem-reading-an-airtable-row/2304404 "2023-03-02T14:51:10Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![markettopandou4](https://avatars.discourse-cdn.com/v4/letter/m/90db22/32.png) [@markettopandou4](https://community.thunkable.com/u/markettopandou4)\
**Post date:** [March 2, 2023, 2:51pm UTC](https://community.thunkable.com/t/problem-reading-an-airtable-row/2304404/1 "2023-03-02T14:51:11Z")

</div>

Hi everyone,  
I read a row of Airtable with Get Row Object Form. I go to view directly with a Lable but it writes me [object Object].  
Now I wonder how to display the value of a single column (eg Local\_ID). I tried with objects but failed. Could you please send me an example or tell me how I can solve it. I’ve been banging my head for 3 days.  
Thanks Marco

---

<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:** [March 2, 2023, 6:04pm UTC](https://community.thunkable.com/t/problem-reading-an-airtable-row/2304404/2 "2023-03-02T18:04:24Z")

</div>

That is correct. You used the `Get Row Object` so you are using an object not a simple text.

One way of displaying the content of an object is to convert it to JSON using  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/5/65bb6561058172b4b45b49c5638ad2d5f2819c4a.png)

---

<div class="post-metadata">

**Author:** ![markettopandou4](https://avatars.discourse-cdn.com/v4/letter/m/90db22/32.png) [@markettopandou4](https://community.thunkable.com/u/markettopandou4)\
**Post date:** [March 6, 2023, 8:14am UTC](https://community.thunkable.com/t/problem-reading-an-airtable-row/2304404/3 "2023-03-06T08:14:49Z")

</div>

In the meantime, thanks for your cooperation.

Another question:  
for example, Marco which is my value on db airtable appears to me as “Marco” on the app.  
Can I avoid the quotes?

It occurred to me to remove head and tail but that’s more work for the app.  
Is there any other method?

Thanks Marco

---

<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 6, 2023, 8:22am UTC](https://community.thunkable.com/t/problem-reading-an-airtable-row/2304404/4 "2023-03-06T08:22:02Z")

</div>

What format is the Airtable column? Post a screenshot of the blocks you are using to get the value “Marco” from Airtable. It should be [get property “column name” of object], where the object is the row.

---

<div class="post-metadata">

**Author:** ![markettopandou4](https://avatars.discourse-cdn.com/v4/letter/m/90db22/32.png) [@markettopandou4](https://community.thunkable.com/u/markettopandou4)\
**Post date:** [March 9, 2023, 4:15pm UTC](https://community.thunkable.com/t/problem-reading-an-airtable-row/2304404/5 "2023-03-09T16:15:52Z")

</div>

Here are the blocks in the picture.  
I see the variable Name\_Region with quotes.  
Instead of Marche I get “Marche”.

Thanks Marco

 ![Immagine](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/1/b19fb613dabc17eb835738e7f5127750615ee053.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 9, 2023, 5:58pm UTC](https://community.thunkable.com/t/problem-reading-an-airtable-row/2304404/6 "2023-03-09T17:58:20Z")

</div>

So the trick here is that @muneer is correct that to convert an object to text, you need to use the [generate JSON from object] block. But in your case, you’re already doing that with the [get property of object] block. That block converts the row object to text but then the [generate JSON from object] block formats it as JSON and adds the quotes ("). So you need to remove the [generate JSON from object blocks] in your screenshot above.

Is there a reason you aren’t using the Get Value blocks in the Data Sources category?

If you keep using [get row object], I recommend that you set a variable to [get row object] and then use that variable in place of the other [get row object] blocks in your project. Because the way you’re doing it, each [get row object] block is a separate call to Airtable. The way I’m suggesting, you make **one** call to Airtable and then use the data over and over in a local variable.

---

<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:** [June 7, 2023, 5:58pm UTC](https://community.thunkable.com/t/problem-reading-an-airtable-row/2304404/7 "2023-06-07T17:58:26Z")

</div>

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