Another idea about Search & Filter Airtable

[Yukold]

As usual to illustrate my idea well I will put pictures
So let´s go!

Here is the app

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

or

I created this block just to try to expand my thinking from it, but I’m not sure if it’s possible

All information comes from airtable on these blocks:

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?

[actech]

An example of filtering is on the screen scrAirTable and scrFinder.

https://x.thunkable.com/projects/5d370bd8814895afb4300c50/project/properties/designer/

[Yukold]

I can´t search the scrFinder and the scrAirTable show only this:

[actech]

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

[Yukold]

“Do you have a data list?”
Yes, see here a example

“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

[actech]

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/

[Yukold]

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…

The blocks

And result

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?

[kartik_old]

Hello there,
Do u want to get only selected values which contain a keyword?

[kartik_old]

Like if
if Sabor1 = Maracuja -> then only get values from Sabor2 & Sabor3?
else - look for the next item in Sabor1

Thanks!

[Yukold]

Yes, If Sabor 1 = Maracuja he only can get from Sabor 2 & 3 if Sabor 1 = Maracujá

[kartik_old]

Okay.
I’ll reply u in 5 mins

[kartik_old]

Here u go

---

Thanks!

[Yukold]

This will not work, the list I said was just an example, the original list has over 1000 items … so many words are repeated …

[kartik_old]

Ok.
Like above I added the check of word : Maracujá
What word do u like to add?

[Yukold]

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

[kartik_old]

Will these be in a listview and you have to select a name and look for it?

[Yukold]

For better information…

Here is the app

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…

In this text input…

Only this

And in this:

All this options:

so that would happen …