Search entire airtable spreadsheet

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?


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).