What do I need to change for the search to search the entire Airtable spreadsheet
1 Like
Typically, a search would be done on a single column. Why do you need to search the entire spreadsheet?
2 Likes
If I have one column that is keywords, one for the title, one for the address, or a key word in one of the descriptions … all the columns can be searched to bring up that item.
Yes, I can search all of the columns I just need to know how to do that correctly.
The only way I know how to do it is to search each column individually. But there may be a way that’s more efficient… I didn’t see anything in the Airtable API that suggested there is.
What I would probably do is to loop through the rows in the spreadsheet and get each row object. Then, check the row contents for the search key word(s).
2 Likes