Help

filterByFormula AND FIND

Topic Labels: API
Solved
Jump to Solution
2011 1
cancel
Showing results for 
Search instead for 
Did you mean: 
RIck_Allen
6 - Interface Innovator
6 - Interface Innovator

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
RIck_Allen
6 - Interface Innovator
6 - Interface Innovator

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
RIck_Allen
6 - Interface Innovator
6 - Interface Innovator

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

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