Solved

filterByFormula AND FIND

+7

HEy All I’m trying to create a CURL API request that Searches for records that are {WEEK} = “24” AND{PAGE} contains “22”.

My PAGE field is a look up so it might have more than one page number in it.

If PAGE has one one record in it I can use

filterByFormula=AND(%7BWEEK%7D%3D%2224%22%2C%7BPAGE%7D%3D%2222%22)

I think I need to use SEARCH or FIND but I cant work out the syntax.

Thanks in aadvance

Best answer by RIck_Allen

Just for future reference, mostly mine when I search for this again!!

AND({Week}="24",FIND("19",ARRAYJOIN({Shot Number})),FIND("22",ARRAYJOIN({PAGE})))

+7

Just for future reference, mostly mine when I search for this again!!

AND({Week}="24",FIND("19",ARRAYJOIN({Shot Number})),FIND("22",ARRAYJOIN({PAGE})))

Sign up