Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Searching for a string value within an column with array of strings

Topic Labels: API
4704 1
Showing results for 
Search instead for 
Did you mean: 

I have a table with a column which can 0 or more string values. I’m trying to search for all records that contain a certain string value in its that column

I’m using the following in my request URL but never getting any records (this value does exist within the array of values in some of the rows)

filterByFormula=SEARCH("rec6CS1RqOjcYLwXf", ARRAYJOIN(Industries))

Am I doing something wrong?

1 Reply 1

Hi @Jason_Burke - I think the problem here is that you are literally searching for the string “rec6CS1RqOjcYLwXf” in the ARRAYJOIN value, but, I assume, you want to search for a field value associated with record “rec6CS1RqOjcYLwXf”.

(I’m also assuming that your ARRAYJOIN is something like this:

Screenshot 2020-05-13 at 14.55.43

To make it work your formula should read something like:

filterByFormula=SEARCH("Retail", ARRAYJOIN(Industries))

or if the search term is dynamic, then do something like:

let searchTerm = [Get the dynamic value here from a record, table, etc]
filterByFormula=SEARCH(searchTerm, ARRAYJOIN(Industries))