Skip to main content
Solved

Exact filterByFormula FIND question

  • February 4, 2020
  • 1 reply
  • 23 views
R
Forum|alt.badge.img+7

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??

Best answer by Bill_French

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.

1 reply

B
Forum|alt.badge.img+19
  • Bill_French
  • Inspiring
  • 3263 replies
  • Answer
  • February 5, 2020

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.


Terms & ConditionsAccessibility statement