I am starting to test out Airtable as a replacement for the Adalo database. Can anyone help with how to create a filter based on the search term value?
I have a field that I have called “Search Index” with a handful of keywords in it. I want the list to filter based on any of the keywords appearing in the search term(search bar value).
I cannot seem to figure out how to create a formula that is CONTAINS instead of =.
My Search Index value looks like this: value1 value2 value3
GOAL: My only goal here is to have a list where the records can be searched by multiple properties. (i.e: first name, last name, title, etc.).