# Search for value in colum (Airtable Spreadsheet)

**URL:** <https://community.thunkable.com/t/search-for-value-in-colum-airtable-spreadsheet/56949>\
**Category:** Questions about Thunkable X\
**Created:** [November 18, 2018, 1:10pm UTC](https://community.thunkable.com/t/search-for-value-in-colum-airtable-spreadsheet/56949 "2018-11-18T13:10:50Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Christian\_Sigge](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/christian_sigge/32/27756_2.png) [@Christian\_Sigge](https://community.thunkable.com/u/Christian_Sigge)\
**Post date:** [November 18, 2018, 1:10pm UTC](https://community.thunkable.com/t/search-for-value-in-colum-airtable-spreadsheet/56949/1 "2018-11-18T13:10:50Z")

</div>

Hello again,  
I’m trying to retrieve a value from a colum “Date\_value” in an Airtable Spreadsheet, the colum contains either 1 or 2, if number 1 is found all values from colum “Kombiniert” should be visible an the List viewer.  
And once again I can’t find a solution…

Here’s my attempt:  
 ![Capture](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/b/8b28e0c183b1e971f75f0bab3d8d804fe83e7bba.png)

Anyone?

---

<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 18, 2018, 3:04pm UTC](https://community.thunkable.com/t/search-for-value-in-colum-airtable-spreadsheet/56949/2 "2018-11-18T15:04:01Z")

</div>

Try to get all the data from the table to begin with using the block. If this does not work, then there may be an error in some parameter to access the table.

![%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/2/b2e3d21dbe9f34f517fce72da7bab611f45316e3.png)

---

<div class="post-metadata">

**Author:** ![Christian\_Sigge](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/christian_sigge/32/27756_2.png) [@Christian\_Sigge](https://community.thunkable.com/u/Christian_Sigge)\
**Post date:** [November 18, 2018, 3:13pm UTC](https://community.thunkable.com/t/search-for-value-in-colum-airtable-spreadsheet/56949/3 "2018-11-18T15:13:27Z")

</div>

Hello Actech,  
the table access is working, with this Block Label3 is displaying a long string with all values from my Spreadsheet.

---

<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 18, 2018, 3:18pm UTC](https://community.thunkable.com/t/search-for-value-in-colum-airtable-spreadsheet/56949/4 "2018-11-18T15:18:43Z")

</div>

Hi, 😉

then check the column name. Your code works fine for me.

Check the block “if then” is executed?

---

<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 18, 2018, 3:28pm UTC](https://community.thunkable.com/t/search-for-value-in-colum-airtable-spreadsheet/56949/5 "2018-11-18T15:28:24Z")

</div>

This block works for me.

![%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/6/e/6ea965dbb0b4600ebf62c0978760214c8e5a63c6.png)

---

<div class="post-metadata">

**Author:** ![Christian\_Sigge](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/christian_sigge/32/27756_2.png) [@Christian\_Sigge](https://community.thunkable.com/u/Christian_Sigge)\
**Post date:** [November 18, 2018, 3:38pm UTC](https://community.thunkable.com/t/search-for-value-in-colum-airtable-spreadsheet/56949/6 "2018-11-18T15:38:41Z")

</div>

Hello Actech, yes that Block is working, just not in the way I want … I think I messed this up,  
wait let me try to explain again what I try to achive.

I have two Colums:

- Colum1: Contains names
- Colum2: Contains either number 1 or 2

I want to display in the List viewer from Colum1 all values that contain the number “1” in Colum2.

---

<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 18, 2018, 3:41pm UTC](https://community.thunkable.com/t/search-for-value-in-colum-airtable-spreadsheet/56949/7 "2018-11-18T15:41:53Z")

</div>

To solve this problem, I would do this:

1. Get all records from table to list
2. Create a loop on a list in which to select all records that satisfy the condition

---

<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 18, 2018, 3:49pm UTC](https://community.thunkable.com/t/search-for-value-in-colum-airtable-spreadsheet/56949/8 "2018-11-18T15:49:30Z")

</div>

Sample

![%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/6/3/634ee20016c133a76dda2ff98b020b181ca3d4dd.png)

---

<div class="post-metadata">

**Author:** ![Christian\_Sigge](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/christian_sigge/32/27756_2.png) [@Christian\_Sigge](https://community.thunkable.com/u/Christian_Sigge)\
**Post date:** [November 18, 2018, 5:10pm UTC](https://community.thunkable.com/t/search-for-value-in-colum-airtable-spreadsheet/56949/9 "2018-11-18T17:10:17Z")

</div>

Hey actech, it worked 😀  
there’s just one strange problem, if I leave the screen and open he screen again the entries in the list are duplicated, they duplicate each time i leave and open the screen again. (Im using drawer Navigator)  
Is’nt there a way to clear the screen before it opens to avoid this behavior?

May I ask where you got your knowledge from, is it just alot of try and error?

Thanks for your help, I saw you are very busy in this comunity.

---

<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 18, 2018, 6:12pm UTC](https://community.thunkable.com/t/search-for-value-in-colum-airtable-spreadsheet/56949/10 "2018-11-18T18:12:19Z")

</div>

Records in the list are duplicated due to the fact that we do not clear the list and records are added to it. In the Screen.Open block add the cleaning block to the list variable:

set app list \<- empty list

If you need to fill the ListViewer only once when starting the application, then fill the list in the initialization block “Screen Starts”.

My knowledge is the result of programming. I do text programming and some time ago I became interested in visual programming using blocks. In addition, I have been studying Thunkable X for a long time and learn a lot of new things by helping users to solve their problems.

---

<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, 11:52am UTC](https://community.thunkable.com/t/search-for-value-in-colum-airtable-spreadsheet/56949/11 "2024-11-08T11:52:43Z")

</div>