Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Exact filterByFormula FIND question

Topic Labels: API
Solved
Jump to Solution
1009 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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.