Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

filterByFormula AND FIND

Topic Labels: API
Solved
Jump to Solution
2137 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})))