# 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:** 1

<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 12, 2018, 3:45pm UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/1 "2018-11-12T15:45:54Z")

</div>

Beginner here. I am making a map for our school. It is for a school project. Since we would be working with many rooms, I decided to make a spreadsheet that contains 4 data about the room. **However, i cannot seem to get data from my airtable at all…** The list viewer turns white, then thunkable live restarts over and over again… need help here!

---

<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 13, 2018, 7:21am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/2 "2018-11-13T07:21:48Z")

</div>

To get started, try to get the records from the table using the browser (examples of this are in the help). After that, try the Thunkable X app just to get all the records in Label. If this does not work, then you set the wrong parameters for accessing AirTable.

---

<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 13, 2018, 4:13pm UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/3 "2018-11-13T16:13:04Z")

</div>

> [@actech](#):
>
> get the records from the table using the browser

could you help me step-by-step, i cant seem to do what you told me

---

<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 13, 2018, 6:23pm UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/4 "2018-11-13T18:23:24Z")

</div>

![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/c/1cfbceb0e7988ea79be916e2113dbf54515e54ef.png)

 ![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/7/b7fa097094bb45237d145287b771f6b400435e36.png)

 ![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/9/99d90ae40eebd03e3965432c05b2a8c272018766.png)

If the data from the table display, AirTable works on all do as written in the documentation.

[https://docs.thunkable.com/thunkable-cross-platform/create/components/data/spreadsheet](https://docs.thunkable.com/thunkable-cross-platform/create/components/data/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 14, 2018, 2:03am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/5 "2018-11-14T02:03:27Z")

</div>

I have done it but it shows this:

 ![thunkablepromblem](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/a/6aec4528e8a52fce895cd4b869921edf52f61bc0.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 14, 2018, 6:55am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/6 "2018-11-14T06:55:32Z")

</div>

All right Now create an application in which all the records from this table are displayed in the Label using the SpreadSheet.GetAllRows block.

![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/d/2d8dc552da0219d80bf2587c43f2e2a11d1ed79b.png)

---

<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, 5:35am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/7 "2018-11-16T05:35:03Z")

</div>

It shows [] then QUICKLY restarts the app

---

<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, 6:49am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/8 "2018-11-16T06:49:38Z")

</div>

This means there is an error in the access parameters for your table. If you give me a link to your project and access parameters to AirTable, then I will try to solve the problem.

---

<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, 7:54am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/9 "2018-11-16T07:54:15Z")

</div>

> [@actech](#):
>
> If you give me a link to your project and access parameters to AirTable

How may i do this

---

<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, 7:55am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/10 "2018-11-16T07:55:19Z")

</div>

[https://airtable.com/shre85huqdcRaUKT6](https://airtable.com/shre85huqdcRaUKT6)

---

<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:05am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/11 "2018-11-16T09:05:22Z")

</div>

You gave me the wrong link. To get a link to a project, do this:

 ![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/1/a129193c9c2015f804fb926f9cc24e6e6cca9d65.png)

 ![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/a/8aa1c9e0a3ba11b3aed0dede78d15ef34dd74316.png)

---

<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:07am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/12 "2018-11-16T09:07:27Z")

</div>

OK then wait

---

<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:11am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/13 "2018-11-16T09:11:20Z")

</div>

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

 ![Screenshot%20(5)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/9/395680282ff8056e3e286e731e9934e90c2c92ce.png)

APIKEY: keymcjiOwQqCsRBRm  
BASEID: appHVtx7d1OWJDSpZ  
TABLENAME: App Data  
VIEWNAME: Grid View

---

<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:12am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/14 "2018-11-16T09:12:43Z")

</div>

Ok

---

<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:21am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/15 "2018-11-16T09:21:10Z")

</div>

Delete from your table 3 and 4 the record that left two records - 1 and 2

---

<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:24am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/16 "2018-11-16T09:24:18Z")

</div>

what do you mean  
??

---

<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:27am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/17 "2018-11-16T09:27:19Z")

</div>

In the AirTable table, leave only the first two rows. Remove all other rows from the table using the AirTable control environment so that it turns out.

 ![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/5/252acfe45b971b38756a55d472420ae5f63445c5.png)

---

<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:28am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/18 "2018-11-16T09:28:34Z")

</div>

![Screenshot%20(7)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/4/747bd5d4eb3f59547ff075605f4f54a7978fe258.png)  
like this?

---

<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:30am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/19 "2018-11-16T09:30:04Z")

</div>

Yes, delete the Bialogy Laboratory entry and under it so that only 2 first entries remain in the table

---

<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:31am UTC](https://community.thunkable.com/t/problem-with-airtable-and-spreadsheet-component-in-thunkable/56129/21 "2018-11-16T09:31:33Z")

</div>

![Screenshot%20(8)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/9/69e7e6588bad7301964ad5bafd003fa668cec515.png)

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