# View only items related to specific User ID from Airtable **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [April 17, 2021, 7:11am UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157 "2021-04-17T07:11:09Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 17, 2021, 7:11am UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/1 "2021-04-17T07:11:09Z")
Hi. I am following a tutorial trying to filter out the data coming from Airtable to show only items that match the current user (which I get through Firebase and is stored in a variable called “User\_ID”. Can anyone here see what is wrong with this block? Id doesn’t work for me. ![Screenshot 2021-04-17 at 09.08.14](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/f/7f8796a97cc40b36084d4d6e635701bd9852f7ac.png) Any ideas? Or do you need more from me to be able to see anything? Or, does anyone have any other idea how I can filter this out? Thanks! ---
**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 17, 2021, 9:31am UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/2 "2021-04-17T09:31:16Z")
From the blocks it seems to me that you want to create a list of items for that specific user. If this is correct then you don’t need to do two loops and you can do it in just one loop ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/c/4cd3b3603b5fa7a969593a2378df38c6e25008ca.png) However, you need to be sure that there are rows in your table and the “User ID” is actually matching before you add to the list the “Items” of the matched row. ---
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 17, 2021, 9:54am UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/3 "2021-04-17T09:54:20Z")
Thanks, I’ll have a look at this! 👍 ---
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 17, 2021, 10:33pm UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/4 "2021-04-17T22:33:31Z")
I just wanted to say that I got this to work and the reason it didn’t work properly first was that I had forgot to add this information: ![Screenshot 2021-04-18 at 00.12.06](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/7/d75433d008d88149b887e7e02d880f62bb31dd74.png) This was added for me when I first created a DataViewerList with Airtable, so I didn’t thought of put it here as well. Do you guys know if it is possible to do this User ID filtering with Data Viewer List as well? How can I do that? Can I just replace that last line some how to something for DataViewerList component? Like this? But if so I am not sure what to put in the “row id” block(?) It shouldn’t be for any specific row? I mean, I want this filtering for ALL my rows… ![Screenshot 2021-04-17 at 23.56.23](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/f/cfbae7d423ac2247c472ca747ec026f7207d3e1b.png) Can someone give some guidance? (may I ask, In general, if you want to set what to view in a ListViewer you use this block: ![Screenshot 2021-04-18 at 00.17.10](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/a/3a08a700f0a8f45d7de4281b5e0dc659f2c25442.png) and for DVL I am using this? ![Screenshot 2021-04-18 at 00.17.31](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/c/bcfede42f0afdffba3ae21fae76d13acec636721.png) is there anyhing I need to do before I add anything to the DVL in general? Like some kind of formatting etc?) Thanks for any help! Thanks! ---
**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 18, 2021, 10:34am UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/5 "2021-04-18T10:34:04Z")
> [@andreas.sjdtomypv](#): > > (may I ask, In general, if you want to set what to view in a ListViewer you use this block: Yes this is correct. The DVL is all in design stage and there is nothing to add to it in the coding stage. The data displayed in DVL is the underlying table and therefore you can always search the table directly. The “row id” of the DVL is the row block in the DVL click or the “row id” of the row in the table. ---
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 18, 2021, 8:49pm UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/6 "2021-04-18T20:49:46Z")
Thanks muneer. That makes sense. So to add something to the DVL I need to add it to the data source? So, in this case maybe the “update value in”-block would be a good go? I want to do something similar to this but in the DVL: ![Screenshot 2021-04-18 at 22.01.34](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/1/0112b2dfd0ed57a26cfb68d233edb5cef79a1030.png) (cause I know this will work if I use a ListViewer. But now I want to use the DVL. I tried to add this to the “When Screen Starts”-block, but I am still confused about the “row id”. ![Screenshot 2021-04-18 at 22.18.18](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/5/75f18a8f80641db576d70f9942b2db010a2a458b.png) First of all, we are talking about the Tables “row id” here, and not the apps row id, right? Tables row id: ![Screenshot 2021-04-18 at 22.20.59](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/f/ff76164ae5f20abeed65e8b021fadde66c74b30a.png) apps row id: ![Screenshot 2021-04-18 at 22.21.37](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/2/f22d403e9089b92c5d308c9404154a2d6c05931d.jpeg) How can I specify “for ALL rows”? Is there any way to do that? Like in Google Sheets, you can type ex A1:A, that would give you ALL the column "A"s rows starting from “1”. Is there any similar to do in Thunkable? Now I tried to just type the Table’s name (just to try, but that didn’t work obviously). What I want to happen is that we will compare the current logged in user with the user ID in the “User ID”-column in the Airtable sheet. And then we will create a list with only those items ONLY, and put them in the tempList variable. Then I want that tempList to be the source data for my DVL. Hope this makes any sense? Maybe there is a much eisier way to do this? Thanks! ---
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 18, 2021, 9:11pm UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/7 "2021-04-18T21:11:20Z")
deeper thought… “update value in”-block does not feel right… I don’t want to change any data in the database, I only want to view the filtered data in my DLV. …🤔 Any ideas anyone? I am still falling back in this block: ![Screenshot 2021-04-18 at 00.17.31](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/c/bcfede42f0afdffba3ae21fae76d13acec636721.png) Thanks! ---
**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 18, 2021, 11:22pm UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/8 "2021-04-18T23:22:45Z")
Will make you a sample project tomorrow to reflect your idea. ---
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 19, 2021, 5:25am UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/9 "2021-04-19T05:25:45Z")
Thanks muneer! 😊👍 that’s really nice of you… ---
**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 19, 2021, 10:23am UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/10 "2021-04-19T10:23:44Z")
Let’s start and use the connection to the table in Airtable with the Data Source method by clicking on the “+” as seen here ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/d/3d917668607de509272b763c6b4dd47b858d7333.png) This should show a dialog like this ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/4/4477e652a70ee2c522c8fcd32c59feecde21ca37.png) If you have already connected your table then selected from the list. Otherwise, click the Create New button Choose Airtable Supply the API key Choose the Airtable base This will give you an entry under Data Sources with your base so you can choose the table to work with. I have created a table in my account similar to the table you showed “AT\_Table” to work with it In the screen, I added a list viewer to give a list of users and underneath it a DVL to show the “items” of the selected user. I also used the Data Sources to create a Local Storage (Create your own table) table to connect with the DVL ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/0/d0625818d87c62d2cf56b3fc9ab10cc3d9229ca2.png) This is how the table looks ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/f/cf316590948380c0f247f683c5e82f22c7535c9f.png) The open screen just lists the available User IDs without duplicates ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/5/656ce0fa810349e527b474f1a0c5f681a5ffda0e.png) When the user select an entry, the process is to clear the local table and loop through the table in Airtable looking for matching “User ID” and take the “Items” field and add it to the local table ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/f/5f0aed34784074fd981f3502a558b292ee530fa7.png) Hope this helps ---
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 19, 2021, 11:01am UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/11 "2021-04-19T11:01:01Z")
Thanks Museer! Really!! I will have a proper look at this ASAP! 😊 ---
**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 19, 2021, 11:03am UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/12 "2021-04-19T11:03:27Z")
[https://x.thunkable.com/projectPage/607d4c9e4c9d29073e54fd9f](https://x.thunkable.com/projectPage/607d4c9e4c9d29073e54fd9f) This is the project link. You need to connect the Airtable in your side and go through the blocks and refresh them to use your table ---
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 20, 2021, 8:07am UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/13 "2021-04-20T08:07:56Z")
Hi Thanks a lot for this demo! Even though it was not completely how I wanted to do I still got a lot of ideas and did some tweaks to get it fit in my project. Now I am really close!! What I has been focused on since this demo is to actually “mirror” the list in my ListView (with the AirTableData) to my DVL (With my LocalData). Just like you do in the demo but I want the Items to be “mirrored” Since I already got the UserID filtering functions in the ListViewer. So, now I have managed to get that “mirroring” on place BUT it all ends up un the same row in my DVL. Do you have any idea how I can “split” these to 1 item per row? ![Screenshot 2021-04-20 at 09.53.26](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/2/c21638d279d758f980c52d6b05df237742e620b5.png) So, all the items in the list at the bottom are items that are belonging ONLY to this current logged in user. And I can see all these items in the DVL at the top as well, but all in one and same row as you see. This is simply what I did to get this work, inspired by your demo =) ![Screenshot 2021-04-20 at 09.53.37](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/a/fa4f62ad6cf741b682731ab910e6af2df7bec7af.png) Should I use some “for each item J…”- block to get these “split” one row per item? How can I do that? Any ideas? Thanks! ---
**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, 2021, 8:54am UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/14 "2021-04-20T08:54:30Z")
You are creating a row and assigning “tempList” to the field in the “myitemList” table. This means you are adding the full List with all items in one single record. You need to do “for each item J…” for the list “tempList” to add each element at a time. ---
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 20, 2021, 9:13am UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/17 "2021-04-20T09:13:16Z")
Hi. Thanks, yes I do add a list, and this is the reason why all the items ar at one row, I understand that. Great! Then it is a “for each item J…”-block I should use then! Thanks. Well, at the moment I can not do anything cause my app is crashing (but only on desktop it looks like…) I will try to log in and log out again to see if that helps… Thanks! login-logout worked 😊 Wanted to share: I think I got it working: ![Screenshot 2021-04-20 at 11.12.11](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/e/3e484973992c42fa5f1ca32a51eb19831383acf2.png) …with this code…: ![Screenshot 2021-04-20 at 11.10.59](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/c/ec9060f25087e7c67c4b9741b323981ffb97537a.png) ---
**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, 2021, 9:15am UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/18 "2021-04-20T09:15:27Z")
👍 ---
**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, 1:25pm UTC](https://community.thunkable.com/t/view-only-items-related-to-specific-user-id-from-airtable/1229157/19 "2024-11-08T13:25:11Z")