# Problem with Airtable and Spreadsheet Component in Thunkable

**URL:** <https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129>\
**Category:** Questions about Thunkable X\
**Tags:** beginner\
**Created:** [November 12, 2018, 3:45pm UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129 "2018-11-12T15:45:54Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [November 16, 2018, 9:33am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/22 "2018-11-16T09:33:21Z")

</div>

Ok, I will continue testing

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [November 16, 2018, 9:56am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/23 "2018-11-16T09:56:27Z")

</div>

I have your table works. This is a good idea.

---

<div class="post-metadata">

**Author:** ![\_GD\_ETJ](https://avatars.discourse-cdn.com/v4/letter/_/838e76/32.png) [@\_GD\_ETJ](https://community.thunkable.com/u/_GD_ETJ)\
**Post date:** [November 16, 2018, 9:57am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/24 "2018-11-16T09:57:34Z")

</div>

so what should be the code? to make it work

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [November 16, 2018, 10:03am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/25 "2018-11-16T10:03:30Z")

</div>

I’ll think about what the problem is

---

<div class="post-metadata">

**Author:** ![\_GD\_ETJ](https://avatars.discourse-cdn.com/v4/letter/_/838e76/32.png) [@\_GD\_ETJ](https://community.thunkable.com/u/_GD_ETJ)\
**Post date:** [November 16, 2018, 10:04am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/26 "2018-11-16T10:04:28Z")

</div>

Please after you done take picture of code

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [November 16, 2018, 10:05am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/27 "2018-11-16T10:05:58Z")

</div>

It seems that some parameter to access the table is incorrectly specified.

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [November 16, 2018, 10:07am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/28 "2018-11-16T10:07:22Z")

</div>

Check it

[https://x.thunkable.com/projects/5bee8961da92751e195f3246/project/properties/designer/](https://x.thunkable.com/projects/5bee8961da92751e195f3246/project/properties/designer/)

---

<div class="post-metadata">

**Author:** ![\_GD\_ETJ](https://avatars.discourse-cdn.com/v4/letter/_/838e76/32.png) [@\_GD\_ETJ](https://community.thunkable.com/u/_GD_ETJ)\
**Post date:** [November 16, 2018, 10:08am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/29 "2018-11-16T10:08:37Z")

</div>

![Screenshot%20(9)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/7/177e374b1a28ce5f2b594b3b41e148647a2384ea.png)

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [November 16, 2018, 10:09am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/30 "2018-11-16T10:09:52Z")

</div>

Check it

[https://x.thunkable.com/projects/5bee8961da92751e195f3246/project/properties/designer/](https://x.thunkable.com/projects/5bee8961da92751e195f3246/project/properties/designer/)

---

<div class="post-metadata">

**Author:** ![\_GD\_ETJ](https://avatars.discourse-cdn.com/v4/letter/_/838e76/32.png) [@\_GD\_ETJ](https://community.thunkable.com/u/_GD_ETJ)\
**Post date:** [November 16, 2018, 10:15am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/31 "2018-11-16T10:15:19Z")

</div>

It now shows undefined

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [November 16, 2018, 10:19am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/32 "2018-11-16T10:19:57Z")

</div>

You in my project checked the availability of the AirTable API key for? When you copy it is removed. Check all the fields in the access AirTable in my project and run it. Everything should work fine.

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [November 16, 2018, 10:25am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/33 "2018-11-16T10:25:03Z")

</div>

Did you manage to see all the data from your spreadsheet?

---

<div class="post-metadata">

**Author:** ![\_GD\_ETJ](https://avatars.discourse-cdn.com/v4/letter/_/838e76/32.png) [@\_GD\_ETJ](https://community.thunkable.com/u/_GD_ETJ)\
**Post date:** [November 16, 2018, 10:36am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/34 "2018-11-16T10:36:09Z")

</div>

I did but then it shows this…

 ![Screenshot_2018-11-16-13-30-52](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/0/500d9368415974d87653895ea4ea22dec9549546.png)

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [November 16, 2018, 10:38am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/35 "2018-11-16T10:38:01Z")

</div>

All right Now you can get the field values ​​using blocks for working with the object

---

<div class="post-metadata">

**Author:** ![\_GD\_ETJ](https://avatars.discourse-cdn.com/v4/letter/_/838e76/32.png) [@\_GD\_ETJ](https://community.thunkable.com/u/_GD_ETJ)\
**Post date:** [November 16, 2018, 10:38am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/36 "2018-11-16T10:38:40Z")

</div>

Like how

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [November 16, 2018, 10:43am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/37 "2018-11-16T10:43:45Z")

</div>

Check it

[https://x.thunkable.com/projects/5bee8961da92751e195f3246/project/properties/designer/](https://x.thunkable.com/projects/5bee8961da92751e195f3246/project/properties/designer/)

---

<div class="post-metadata">

**Author:** ![\_GD\_ETJ](https://avatars.discourse-cdn.com/v4/letter/_/838e76/32.png) [@\_GD\_ETJ](https://community.thunkable.com/u/_GD_ETJ)\
**Post date:** [November 16, 2018, 10:46am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/38 "2018-11-16T10:46:09Z")

</div>

OMG…

Thank you actech for helping me,

it works 👍

Thank you!!!

---

<div class="post-metadata">

**Author:** ![\_GD\_ETJ](https://avatars.discourse-cdn.com/v4/letter/_/838e76/32.png) [@\_GD\_ETJ](https://community.thunkable.com/u/_GD_ETJ)\
**Post date:** [November 17, 2018, 7:39am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/39 "2018-11-17T07:39:08Z")

</div>

i have some questions

1. could you explain the code and
2. what is the j variable?

---

<div class="post-metadata">

**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\
**Post date:** [November 17, 2018, 9:29am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/40 "2018-11-17T09:29:51Z")

</div>

The rows block contains a list of objects. For this reason, we can immediately use this block in a loop (if instead of the list of objects there was a JSON string, then first it would be necessary to create an object using the “get object fron JSON” block). The value of the variable j is an object (because we have a loop on the list of objects, not simple values). If j is an object, then we can get the value of any of its properties using the “get property” block. In my example, we get the value of the “Room Title” field, which is then added to the “app list” list. After filling the list, it is assigned to the ListViewer component for display.

---

<div class="post-metadata">

**Author:** ![\_GD\_ETJ](https://avatars.discourse-cdn.com/v4/letter/_/838e76/32.png) [@\_GD\_ETJ](https://community.thunkable.com/u/_GD_ETJ)\
**Post date:** [November 17, 2018, 9:30am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/41 "2018-11-17T09:30:44Z")

</div>

Ok thank you again

[Previous page](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129.md?page=1)

[Next page](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129.md?page=3)
