Hi
I am trying to run a test to see if my app is searching my google sheet.
I would like it to display if it finds the keyword or not.
Here is the block logic. Could anyone tell me what I am doing wrong here?
Hello @robert.lundelli4pcye
The issue is the variable selected on the following blocks:
Also, the lowercase block should be used on the text, not on the list.
You can find more examples in our community: https://community.thunkable.com/t/new-way-to-add-search-and-filtering-feature-in-to-your-app/3939241
https://community.thunkable.com/t/local-dataviewer-search/4107613
Thank you for answering. I worked on it a bit more and got some of it to work.
I now have a button that change the text and are clickable to open the link in the sheet.
Next step is to have the full google sheet at the homepage as a data viewer list.
I am trying to filter the list so that only the links connected to the keyword is viewed. Something like the one you created.
I am this far in the block logic. Any suggestions on the next step?
Which method are you going to use of the link I shared in the previous message?
Are you going to create an extra table or create a filter view?
First I was thinking just a searchbar like the one with the fruits.
But really liked the one you had created with the filter options. So I think I will dig in to that.
Can I set it up as the one with fruits and go from there and add the filters you created after?
Hi @robert.lundelli4pcye
Yes, you can implement the filter view way for the searching without adding the filters.
The only issue with this method is that “contain” doesn’t exist as a filter.
If you add an equal condition on the table and you need to display all the data in the beginning then you need to add an extra column and condition.
Here is an example: Strict Dataviewer Search - Tutorials and DIY Guides - Community
The only issue with the method above is that you need to type the exact item in the search.
Another variation of this method is below and solves this issue using greater and lower on the conditions, but it fails for items with multiple words: Dynamic Dataviewer Search - Tutorials and DIY Guides - Community
Thank you for taking the time to explain. I will look in to all this examples!
Again thanks!
1 Like