I do not understand why my search does not work :(

Discuss
#1

When clicking on search in the application it shows the duplicate items more at least this working when clicking on a name open a link next to it in the table … Only the search does not work, could someone help? I want to create a search bar using the airtable in which when searching for a name it shows the result and clicking it opens the link in the next column.

Anota%C3%A7%C3%A3o%202019-07-21%20203022
Anotação 2019-07-21 203022.png1977×783 167 KB

I even had a headache trying to do this, I wanted to understand and learn how to do it.
I used google translator to write this.

1 Like
#2

What I can see that you are using 1 variable for more than one function.
You should create three variable.

1 Like
#3

Thanks for the tip, in case it would be one for the search button and another two stop the spreadsheet? Tomorrow I’ll test, maybe I’m not putting them in the right place either.

I’m trying to do this by looking at videos on YouTube, but there’s no teaching to do with airtable and then clicking open the next column item.

I would like to learn and the main reason to understand the logic so that it works, I will test what you said the most I think I will end up giving up​:disappointed:

#4

I just wanted to find a tutorial … After all, the search bar is fundamental.:sleepy::cold_sweat::worried:

#5

This can help you:

#6

So, I’ve tried this one but it only serves to show what it has in the table, I would like that after fetching the item when clicking on the item it returns the value of the next column.

This is what I’ve been trying to understand, to learn.
Example: When searching for example by Samsung Galaxy S3 when clicking on it open the Samsung website with information from him … That I can not find in any corner teaching.

#7

You are using spreadsheet 1 to get column of name and link.
Change it to spreadsheet2.

Load data on a label and see that all data is loading or not.

#8

Already tried and if I do this when clicking it does not return the value of column 2.

#9

Can you share an apk?

When spreadsheet 1 get column( name) it set list to values and again you are getting value of link column that will delete values of list and set list to links.
And when button is clicked it will clear list and get data of link column and when value is got it will set list to values and do search.In the if condition it will add links that match query to list which means some of the links will be duplicated.
So now…
What do you want???

1 Like
#10

Captura%20de%20Tela%20(21)
Captura%20de%20Tela%20(21)1990×1000 231 KB
Teste.apk (4.6 MB)

Here it is…
And this is a real mess, every time I change something it gets worse :joy::disappointed_relieved:

#11

The thing I want most is learning to make it work.

#12

I swore he was joining, name + links…
So how do I search for names and click on a result to open the next column?
Thank you very much.

#13

No one can do?

#14

I think you have created an infinite loop every time spreadsheet1 will get data it will get data of column link using spreadsheet1 column.
So this will continue until application crashes or user exits application.
What I can suggest?
Change name to spreadsheet 2 of block used in spreadsheet1

IMG_20190723_065529
IMG_20190723_065529.jpg1990×1000 659 KB
and create a new variable list2 and use it for storing links.
And when I tested your app it is not working.

1 Like
#15

Thank you so much, I will try later.

#16

Unsuccessful … I changed Spreadsheet1 and the variable to see if it worked at all.

thank you anyway.

#17

So now what…
You should check api key and base id and other details.
Also try to work with other base and account.

1 Like
#18