Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

filterByFormula AND FIND

Topic Labels: API
Solved
Jump to Solution
253 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

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

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

See Solution in Thread

1 Reply 1

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

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