Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

filterByFormula contains or like

Topic Labels: API
Solved
Jump to Solution
730 1
cancel
Showing results for 
Search instead for 
Did you mean: 
SynopsisLabs
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

I want to search for 1 item in a table which contains multiple items in a cell - apple, banana, grape.

The filterByFormula with the = only works if there is only 1 item in the cell.  If they are multiple items, I get an error.

I tried using "contains" and "like" but they don't work.  

What should I use?

Thanks

Steve

1 Solution

Accepted Solutions
SynopsisLabs
5 - Automation Enthusiast
5 - Automation Enthusiast

No worries - found an answer - 

?filterByFormula=REGEX_MATCH({column_name, "apple")

See Solution in Thread

1 Reply 1
SynopsisLabs
5 - Automation Enthusiast
5 - Automation Enthusiast

No worries - found an answer - 

?filterByFormula=REGEX_MATCH({column_name, "apple")