# Another idea about Search & Filter Airtable **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [August 13, 2019, 12:12pm UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918 "2019-08-13T12:12:38Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Yukold](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/yukold/32/35122_2.png) [@Yukold](https://community.thunkable.com/u/Yukold)\ **Post date:** [August 13, 2019, 12:12pm UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/1 "2019-08-13T12:12:38Z")
As usual to illustrate my idea well I will put pictures So let´s go! Here is the app ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/9/79d8ef1b6c73991e480b5d115ca064f37a1c83ea.jpeg) As you can see, there is a red and a blue square … I would like when I typed what is written in these squares it filtered and only cloned the products that have these characteristics … follow the example ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/e/7e2d15fb7183d19e0f035386661ebd97a0df09df.jpeg) or ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/5/755df652718f6eda37b9d663ec0de25d0176227a.jpeg) I created this block just to try to expand my thinking from it, but I’m not sure if it’s possible ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/6/76a0819bdc44ae15585f147ac95df040d4555568.png) All information comes from airtable on these blocks: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/e/7e33f89d486d45ff6fdd0e2a53c62854c03bc2b4.png) Based on these ideas, using only “contain (the searched name) in the list” is it possible to clone only those that have such a feature? ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [August 14, 2019, 11:07am UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/2 "2019-08-14T11:07:17Z")
An example of filtering is on the screen scrAirTable and scrFinder. [https://x.thunkable.com/projects/5d370bd8814895afb4300c50/project/properties/designer/](https://x.thunkable.com/projects/5d370bd8814895afb4300c50/project/properties/designer/) ---
**Author:** ![Yukold](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/yukold/32/35122_2.png) [@Yukold](https://community.thunkable.com/u/Yukold)\ **Post date:** [August 14, 2019, 11:47am UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/3 "2019-08-14T11:47:08Z")
I can´t search the scrFinder and the scrAirTable show only this: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/3/8390475834d9e1050e061d978789680111eb88fb.jpeg) ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [August 14, 2019, 12:15pm UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/4 "2019-08-14T12:15:30Z")
Good. I will explain in words. Do you have a data list? There is. You need to create a loop throughout the list and add to the other list only those options from the original list that satisfy the user’s choice. To do this, use “if then” blocks 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/1/a/1a0d8e994c9b2da11e25a13bc044668a9b91b4c0.png) ---
**Author:** ![Yukold](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/yukold/32/35122_2.png) [@Yukold](https://community.thunkable.com/u/Yukold)\ **Post date:** [August 15, 2019, 5:56am UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/5 "2019-08-15T05:56:10Z")
“Do you have a data list?” Yes, see here a example ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/e/ae5448a6ef5efd571e827c51f432643aab2c92e9.png) “and add to the other list only those options from the original list that satisfy the user’s choice.” Do I need to create other lists that only have these options? Because if so I will need to create more than 50 lists 😱 ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [August 15, 2019, 7:45am UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/6 "2019-08-15T07:45:10Z")
Suppose you need to filter records from this table, where Sabor1 = Banana. How to do it? 1. Save all records from the air table to List1 2. Create an empty temporary tmpList list 3. Loop through all the records of List1 and add to tmpList those records in which Sabor1 = Banana 4. List all entries from tmpList in ListViewer Do you understand this algorithm? I improved the example of working with scrAirTable. Click on the Filter button and see the blocks of how the filtering works. [https://x.thunkable.com/projects/5d370bd8814895afb4300c50/project/properties/designer/](https://x.thunkable.com/projects/5d370bd8814895afb4300c50/project/properties/designer/) ---
**Author:** ![Yukold](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/yukold/32/35122_2.png) [@Yukold](https://community.thunkable.com/u/Yukold)\ **Post date:** [August 21, 2019, 9:25am UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/7 "2019-08-21T09:25:34Z")
Sorry for a long time no post… But now i will try do this perfect now… So, just do test´s and implement in the future, I created a new project just to test these search and filter functions … Here is the list… ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0fdc2171264ccb80d53f18555920e485333d337e.png) The blocks ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/5/05802a0093ea3b8346c27f115d7b03b504e0a3c8.png) And result ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/9/898d9105622211aa970eee7318be1797bd01e7f9.jpeg) It worked very well, except that it came repeated … it’s possible can’t repeat? And its possible in the same list he get value´s from “Sabor 2” and “Sabor 3” too? ---
**Author:** ![kartik\_old](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik_old/32/28305_2.png) [@kartik\_old](https://community.thunkable.com/u/kartik_old)\ **Post date:** [August 21, 2019, 9:29am UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/8 "2019-08-21T09:29:52Z")
Hello there, Do u want to get only selected values which contain a keyword? ---
**Author:** ![kartik\_old](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik_old/32/28305_2.png) [@kartik\_old](https://community.thunkable.com/u/kartik_old)\ **Post date:** [August 21, 2019, 9:31am UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/9 "2019-08-21T09:31:47Z")
Like if if **Sabor1 = Maracuja** -\> then only get values from **Sabor2** & **Sabor3**? else - look for the next item in **Sabor1** Thanks! ---
**Author:** ![Yukold](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/yukold/32/35122_2.png) [@Yukold](https://community.thunkable.com/u/Yukold)\ **Post date:** [August 21, 2019, 9:34am UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/10 "2019-08-21T09:34:30Z")
Yes, If Sabor 1 = Maracuja he only can get from Sabor 2 & 3 if Sabor 1 = Maracujá ---
**Author:** ![kartik\_old](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik_old/32/28305_2.png) [@kartik\_old](https://community.thunkable.com/u/kartik_old)\ **Post date:** [August 21, 2019, 9:37am UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/11 "2019-08-21T09:37:48Z")
Okay. I’ll reply u in 5 mins 🙂 ---
**Author:** ![kartik\_old](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik_old/32/28305_2.png) [@kartik\_old](https://community.thunkable.com/u/kartik_old)\ **Post date:** [August 21, 2019, 9:48am UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/12 "2019-08-21T09:48:17Z")
# Here u go 👍 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/7/37234be173968b14f6fc3b2eff9e9aa0ec703ed9.png) * * * # Thanks! 😄 ---
**Author:** ![Yukold](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/yukold/32/35122_2.png) [@Yukold](https://community.thunkable.com/u/Yukold)\ **Post date:** [August 21, 2019, 10:50am UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/13 "2019-08-21T10:50:22Z")
This will not work, the list I said was just an example, the original list has over 1000 items … so many words are repeated … ---
**Author:** ![kartik\_old](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik_old/32/28305_2.png) [@kartik\_old](https://community.thunkable.com/u/kartik_old)\ **Post date:** [August 21, 2019, 11:01am UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/14 "2019-08-21T11:01:38Z")
Ok. Like above I added the check of word : **Maracujá** What word do u like to add? ---
**Author:** ![Yukold](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/yukold/32/35122_2.png) [@Yukold](https://community.thunkable.com/u/Yukold)\ **Post date:** [August 21, 2019, 11:08am UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/15 "2019-08-21T11:08:35Z")
Abacaxi Açaí Alfajor Ameixa Amendoim Amora Anko Avelã Bala Banana Baunilha Blueberry Cacau Café Canela Capuccino Caramelo Cereja Chá Chiclete Chocolate Chocolate Branco Coco Cola Conhaque Coquetel Cranberry Damasco Doce de Leite Eucalipto Framboesa Frutas Frutas Tropicais Gelado Gengibre Goiaba Guaraná Kiwi Laranja Leite Lichia Licor Limão Maçã Maçã Verde Mamão Manga Maracujá Melancia Melão Menta Menta Azul Menta Verde Mirtilo Morango Nozes Pepino Pera Pêra Pêssego Pistache Pitaia Quentão Romã Rum Sorvete Tabaco Tangerina Tequila Toranja Tutti Frutti Uva Uva Passa ---
**Author:** ![kartik\_old](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik_old/32/28305_2.png) [@kartik\_old](https://community.thunkable.com/u/kartik_old)\ **Post date:** [August 21, 2019, 11:15am UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/16 "2019-08-21T11:15:37Z")
😱 Will these be in a listview and you have to select a name and look for it? ---
**Author:** ![Yukold](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/yukold/32/35122_2.png) [@Yukold](https://community.thunkable.com/u/Yukold)\ **Post date:** [August 21, 2019, 11:24am UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/17 "2019-08-21T11:24:56Z")
For better information… Here is the app ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/d/ad20d48597eb99e9d58e23c40a9a3e33a6343054.jpeg) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/5/154a79004a7841eb4f6826099c24b78473a04c66.png) when you type something here, it will show all options based on what you are typing … With each letter placed it will show all possible options from this list… ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/5/e50fae1032aee4542d3820e907fdc009d320fc28.png) In this text input… ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/5/452ed9dd18e432948ffa844604de6f05a8c5c356.png) Only this ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/b/1bbf4a564df3293cee3b278703a367754bbe0966.png) And in this: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/c/bcd00b9aaae14b383014da1377de8b835624f1de.png) All this options: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/9/59e2367b5f05b68a4b7ad8b13e60d9800e25349d.png) so that would happen … ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/d/0d0ebdf5b2d615479f65190a1e793b82d4262698.jpeg) ---
**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, 12:11pm UTC](https://community.thunkable.com/t/another-idea-about-search-filter-airtable/179918/18 "2024-11-08T12:11:49Z")