Help

filterByFormula contains or like

Topic Labels: API
Solved
Jump to Solution
616 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")