filterByFormula AND FIND

[RIck_Allen]

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

[RIck_Allen · Accepted solution]

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

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