# Filtering Data off Airtable/Set Viewname to **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner, airtable\ **Created:** [April 18, 2022, 7:35pm UTC](https://community.thunkable.com/t/filtering-data-off-airtable-set-viewname-to/1837240 "2022-04-18T19:35:41Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![dpacewarlgjh](https://avatars.discourse-cdn.com/v4/letter/d/a9a28c/32.png) [@dpacewarlgjh](https://community.thunkable.com/u/dpacewarlgjh)\ **Post date:** [April 18, 2022, 7:35pm UTC](https://community.thunkable.com/t/filtering-data-off-airtable-set-viewname-to/1837240/1 "2022-04-18T19:35:41Z")
Hiya! I’m working on a hospital appointment manager app for school. I’m using airtable for the back end. On airtable I have a patient table, and an appointment table. The appointment table is a list of all the available appointments, with each appointment being linked to a patient by means of the patient ID (primary key). I have been trying to use list viewers to list the dates and times of all the appointments by patient ID. I have tried using the ‘temporary list’ method but to no avail (screen remains blank when I run it), and I’ve also tried using the ‘change view’ feature for airtable (to pull pre-filtered data directly from airtable), but the feature doesnt seem to work either. Can anyone help please? ---
**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:** [April 18, 2022, 8:52pm UTC](https://community.thunkable.com/t/filtering-data-off-airtable-set-viewname-to/1837240/2 "2022-04-18T20:52:14Z")
You’ve explained the problem clearly but provided no examples of how you’ve actually set up anything. Please include screenshots of your blocks and/or a link to the project (and specify which screen you are referring to). ---
**Author:** ![dpacewarlgjh](https://avatars.discourse-cdn.com/v4/letter/d/a9a28c/32.png) [@dpacewarlgjh](https://community.thunkable.com/u/dpacewarlgjh)\ **Post date:** [April 19, 2022, 6:13pm UTC](https://community.thunkable.com/t/filtering-data-off-airtable-set-viewname-to/1837240/3 "2022-04-19T18:13:56Z")
Sorry about that! Below are my blocks, and my sample table from airtable. The appointments table is a list of all the appointments. …I followed this step by step: [How to Add Data to AirTable from Your Thunkable App - YouTube](https://www.youtube.com/watch?v=bnUX2zCQTHo&list=PLArgGKS_QtY6Pyo-6TJQNusmI6Uzt-37U&index=5) ![Screenshot 2022-04-19 at 20.04.52](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/6/c602b9e07c3b466c43f4351ecfcaac2181f7e1e1.jpeg) ![Screenshot 2022-04-19 at 20.06.44](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/3/b36bdfdcb59d91aeaf31f8cfc6f127928a4bb181.jpeg) ---
**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:** [April 19, 2022, 8:51pm UTC](https://community.thunkable.com/t/filtering-data-off-airtable-set-viewname-to/1837240/4 "2022-04-19T20:51:58Z")
Those blocks look correct to me. Are you able to get individual values from that Airtable database from within Thunkable? That is, separate from your loops and just as a debugging step, can you access something like the ID value for the first row (819472M)? What about the Data/Time value for the first row (1/4/2022)? ---
**Author:** ![dpacewarlgjh](https://avatars.discourse-cdn.com/v4/letter/d/a9a28c/32.png) [@dpacewarlgjh](https://community.thunkable.com/u/dpacewarlgjh)\ **Post date:** [April 20, 2022, 3:44am UTC](https://community.thunkable.com/t/filtering-data-off-airtable-set-viewname-to/1837240/5 "2022-04-20T03:44:25Z")
So I tried the get cell function on a seperate screen just for testing… ![Screenshot 2022-04-20 at 05.42.12](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/8/e87e4a8a092a5275c673556a0176ab99f61fd437.png) When I run screen 2, it returns ‘úndefined’ maybe something wrong with API configuration? ---
**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:** [April 20, 2022, 4:17am UTC](https://community.thunkable.com/t/filtering-data-off-airtable-set-viewname-to/1837240/6 "2022-04-20T04:17:51Z")
What happens if you try to get the cell value for row 1 of Patient\_ID? If that doesn’t work, double-check your Airtable authentication (see [Airtable - Thunkable Docs](https://docs.thunkable.com/spreadsheet)). It’s best to make sure you can get something really simply to work with Airtable (or any data source) before trying to do something complicated. Otherwise, you introduce too many variables that could be causing the problem. ---
**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:** [April 20, 2022, 7:27am UTC](https://community.thunkable.com/t/filtering-data-off-airtable-set-viewname-to/1837240/7 "2022-04-20T07:27:42Z")
From your previous screenshots, **ID** is not a column in the table you are using. It is a reference column and Airtable treats it differently. Use this block with a column from the table and it should work. The other issue, you are using the `Airtable` component which requires the table name to be written as text in the component properties so make sure you spelled it correctly and using the correct case because it is case sensitive. It would be better to use the `Data Source` connection to connect to you table because it is easier to test. ---
**Author:** ![dpacewarlgjh](https://avatars.discourse-cdn.com/v4/letter/d/a9a28c/32.png) [@dpacewarlgjh](https://community.thunkable.com/u/dpacewarlgjh)\ **Post date:** [April 20, 2022, 1:36pm UTC](https://community.thunkable.com/t/filtering-data-off-airtable-set-viewname-to/1837240/8 "2022-04-20T13:36:06Z")
> [@muneer](#): > > From your previous screenshots, **ID** is not a column in the table you are using. It is a reference column and Airtable treats it differently. This was my issue! Thank you so much! I duplicated the Patient\_ID column in Airtable, and changed the data format of the copied column to single line text, and managed to filter correctly. My question now is, is there any way to convert the value in the reference column to a string to be used for filtering within thunkable? ---
**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:** [April 20, 2022, 2:30pm UTC](https://community.thunkable.com/t/filtering-data-off-airtable-set-viewname-to/1837240/9 "2022-04-20T14:30:42Z")
To see how Airtable treats referenced column you need to obtain a row as a JSON object and then use the reference to get the data of that column. ---
**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:** [July 19, 2022, 2:31pm UTC](https://community.thunkable.com/t/filtering-data-off-airtable-set-viewname-to/1837240/10 "2022-07-19T14:31:32Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.