# Filter Data in List View **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner, listview, airtable, dynamic-filter\ **Created:** [December 12, 2021, 6:36am UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268 "2021-12-12T06:36:16Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\ **Post date:** [December 12, 2021, 6:36am UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/1 "2021-12-12T06:36:16Z")
Hi, I’m new at Thunkable…i was stuck at this problem where I want to filter list viewer. The data for the list viewer is taken from airtable spreadsheet, which has 3 columns:- Srno, “Product Name”, and “Colour”. Both "Product Name " and "Colour " are list viewer, So I have multiple colors for same product, I want to show unique records for “Product Name”, and when i select any product from “Prouduct Name” list viewer, then color associated wtih that product should be displayed in “Colour” list box. ---
**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:** [December 12, 2021, 8:24am UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/2 "2021-12-12T08:24:46Z")
Welcome to Thunkable. Please show your work so other members can correct your code or give advices of what you should do. ---
**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\ **Post date:** [December 12, 2021, 8:31am UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/3 "2021-12-12T08:31:35Z")
[https://x.thunkable.com/copy/c6b56ce469c119d6c2f15f2f92e1729a](https://x.thunkable.com/copy/c6b56ce469c119d6c2f15f2f92e1729a) Here is my project.!!! ---
**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:** [December 12, 2021, 8:42am UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/4 "2021-12-12T08:42:01Z")
Will you be willing to share the Airtable tables / base so I can run your project and see what is the issue with your code. When you share a project in Thunkable, the `Data Sources` are not shared with it. This is to protect your data. ---
**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\ **Post date:** [December 12, 2021, 8:42am UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/5 "2021-12-12T08:42:39Z")
How can I share it?? ---
**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:** [December 12, 2021, 8:45am UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/6 "2021-12-12T08:45:27Z")
When you open your base in Airtable, you will have a share button ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/9/09f7d3cf26cca9bf546df58137390d340fbc9dd1.png) ---
**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\ **Post date:** [December 12, 2021, 8:51am UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/7 "2021-12-12T08:51:51Z")
> **[Airtable | Everyone's app platform](https://airtable.com/invite/l?inviteId=invXXQmOTWSBlPBrW&inviteToken=d7cf7fea553473eb86dc17392a60d1525deebc930f7f9131c7cdd9fb9db5dc62&utm_source=email)** > > Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. ---
**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:** [December 12, 2021, 9:54am UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/8 "2021-12-12T09:54:40Z")
I made few changes to the code blocks and to your form. Check it here [https://x.thunkable.com/projectPage/61b5b407f599440011032e0c](https://x.thunkable.com/projectPage/61b5b407f599440011032e0c) **[Note]** The `create row` block, I left it empty so you can fill it after you check the form. ---
**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\ **Post date:** [December 12, 2021, 11:50am UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/9 "2021-12-12T11:50:08Z")
it’s still showing multiple colors for bahubali when it should show only one - rani. i think it’s because the color list is preloaded with full colors at screen open - OR maybe the list viewer should refreshed to point to the selective/filered list at product click time. ---
**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:** [December 12, 2021, 12:26pm UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/10 "2021-12-12T12:26:18Z")
> [@manyone](#): > > multiple colors Each product has multiple colors but I can see changes whenever a different product is selected. | 1 | Panetar | Rani | | --- | --- | --- | | 2 | Panetar | Red | | 3 | Panetar | Rama | | 4 | Panetar | Tomato | | 5 | Panetar | Gajri | | 6 | Panetar | Navy Blue | | 7 | Panetar | Pista | | 8 | Panetar | Firozi | | 9 | Panetar | Mustard | | 10 | Panetar | Fanta | | 11 | Panetar | White | | 12 | Panetar | Grey | | 13 | Panetar | Chikoo | | 14 | Vichitra Check | Jambli | | 15 | Vichitra Check | Pista | | 16 | Vichitra Check | Blue | | 17 | Vichitra Check | Grey | | 18 | Vichitra Check | Uniform | | 19 | Vichitra Check | Fanta | | 20 | Vichitra Check | Rubain | | 21 | Vichitra Check | Rani | | 22 | Vichitra Check | Chikoo | | 23 | Bahubali | Rani | This is the list in the table. You can check if you choose `Bahubali` which had a single color. Then change to another product and see the list repopulated. I made a small change to make it more apparent. Now, every time you select a product, the color label will show **Select colour**. ---
**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\ **Post date:** [December 12, 2021, 5:53pm UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/11 "2021-12-12T17:53:53Z")
Thank you so much!!! IT was a great Help! 🙂 ---
**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\ **Post date:** [December 12, 2021, 6:03pm UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/12 "2021-12-12T18:03:52Z")
Can I select multiple color from the list box? ---
**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:** [December 12, 2021, 6:21pm UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/13 "2021-12-12T18:21:29Z")
By default, the `List Viewer` is a single select component. You will need to create a function to make multiselection. Check this example [https://x.thunkable.com/projectPage/603fe31c6b9fa20011d0afcd](https://x.thunkable.com/projectPage/603fe31c6b9fa20011d0afcd) ---
**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\ **Post date:** [December 12, 2021, 6:29pm UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/14 "2021-12-12T18:29:43Z")
Hey! Sorry but I just checked my data base after filling out the form, all products are getting displayed even after selecting one product. Color is getting displayed as selected. ---
**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:** [December 12, 2021, 7:09pm UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/15 "2021-12-12T19:09:15Z")
I’m not sure I understand what you are trying to explain. Can you explain in more details or share an image of what you are getting? ---
**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\ **Post date:** [December 13, 2021, 5:12am UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/16 "2021-12-13T05:12:28Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/e/ae481f32398a8410775faf84b4e2c348f4a9b1fb.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:** [December 13, 2021, 9:30am UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/17 "2021-12-13T09:30:12Z")
From the record, it seems you have used this in the `create row` block ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/0/b0038bed1630528825a34f1c93121f9b4a626def.png) This will give the available list items in full. You should use these instead ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/5/15cd7ba7ef90b446bad16fc74ea03e5f0d78d70e.png) This will give you the selected item from the list. ---
**Author:** ![naitikjain99wz6mu](https://avatars.discourse-cdn.com/v4/letter/n/7ea924/32.png) [@naitikjain99wz6mu](https://community.thunkable.com/u/naitikjain99wz6mu)\ **Post date:** [December 13, 2021, 9:43am UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/18 "2021-12-13T09:43:02Z")
Thanks! I liked your teaching. I would like to learn more from you. Can you teach me. 😅 ---
**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:** [December 13, 2021, 10:20am UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/19 "2021-12-13T10:20:48Z")
> [@naitikjain99wz6mu](#): > > Can you teach me Thank you for your nice comments. Whenever, you have a question, you can post it in the community forum and the community members are very helpful. Either I or someone else will answer you. We are here to help each other. ---
**Author:** ![dimaurosalvo19717s1y](https://avatars.discourse-cdn.com/v4/letter/d/a87d85/32.png) [@dimaurosalvo19717s1y](https://community.thunkable.com/u/dimaurosalvo19717s1y)\ **Post date:** [December 14, 2021, 9:10am UTC](https://community.thunkable.com/t/filter-data-in-list-view/1652268/20 "2021-12-14T09:10:25Z")
Sorry for the ignorance, but the check how do you make it appear? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/5/f58310e5102fe640e00a77aa3f90b3e4c38b3785.png) [Next page](https://community.thunkable.com/t/filter-data-in-list-view/1652268.md?page=2)