Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Exact filterByFormula FIND question

Solved
Jump to Solution
781 0
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.