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.

Exact filterByFormula FIND question

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

Hey Guys

Is there a do a filterByFormula to find an exact match?

filterByFormula=(FIND(%221234%22%2C%7BProject+Name%7D))

will find records within the Project Name field containing 1234 or 12345 but I need to return the exact match (1234) not the partial match.

Hope that makes sense??

1 Solution

Accepted Solutions
Bill_French
17 - Neptune
17 - Neptune

I don’t believe there is. Here’s how I do this…

  1. Find based on a query that really narrows the result set.
  2. Iterate the results performing matching logic.

See Solution in Thread

1 Reply 1
Bill_French
17 - Neptune
17 - Neptune

I don’t believe there is. Here’s how I do this…

  1. Find based on a query that really narrows the result set.
  2. Iterate the results performing matching logic.