
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 25, 2022 12:05 AM
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
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 25, 2022 05:21 AM
Just for future reference, mostly mine when I search for this again!!
AND({Week}="24",FIND("19",ARRAYJOIN({Shot Number})),FIND("22",ARRAYJOIN({PAGE})))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 25, 2022 05:21 AM
Just for future reference, mostly mine when I search for this again!!
AND({Week}="24",FIND("19",ARRAYJOIN({Shot Number})),FIND("22",ARRAYJOIN({PAGE})))
