Another idea about Search & Filter Airtable

Yukold · August 13, 2019, 12:15pm

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 · August 14, 2019, 11:07am

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

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

Yukold · August 14, 2019, 11:47am

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

actech · August 14, 2019, 12:18pm

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 · August 15, 2019, 5:56am

“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 · August 15, 2019, 8:08am

Suppose you need to filter records from this table, where Sabor1 = Banana. How to do it?

Save all records from the air table to List1
Create an empty temporary tmpList list
Loop through all the records of List1 and add to tmpList those records in which Sabor1 = Banana
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 · August 21, 2019, 9:27am

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 · August 21, 2019, 9:29am

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

kartik · August 21, 2019, 9:31am

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

Thanks!

Yukold · August 21, 2019, 9:34am

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

kartik · August 21, 2019, 9:37am

Okay.
I’ll reply u in 5 mins

kartik · August 21, 2019, 9:48am

Here u go

Thanks!

Yukold · August 21, 2019, 10:50am

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 · August 21, 2019, 11:01am

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

Yukold · August 21, 2019, 11:08am

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