Hello everyone!
I’m building a comparator tool and I have created the structure but I’m struggling on the part regarding the dynamic search bar, to be able to show only product based on request made in the search section. Currently my page is structured as follow:
- on the header: input search bar
- below the header: dropdown to sort by price, new, popularity
- on the left: menu with several dropdown to filter results based on several categories
- on the center of the page: repeating group feeded by Airtable
Originally, I had put on the repeating group source several conditions to filter based on the left dropdowns, but since I want to add a dynamic search in the search bar, it is getting in conflict with the other conditions.
Therefore, I believe I have to put the filter already on the API (through the API Conector - on parameters) and I’ve therefore put it as such:
Key = filterByFormula / Value = OR(‘{search}’ = ‘’, FIND(LOWER(‘{search}’), LOWER({Name})) > 0).
This is where I have an issue, this doesn’t provide any response through Airtable (while it is exactly mentioned as such in Airtable). However, when I replace {search} by a specific keyword, I do have returns and products show up in the Repeating group.
I’m stuck here and can’t proceed further so if anyone already experienced the same or made a similar projects and found another way to build this, I’m lookign for your advices!
Thanks!