Skip to main content

Tool to help build filterByFormulas for API?

  • May 28, 2021
  • 1 reply
  • 1 view

Forum|alt.badge.img+4

I’m wondering if there is a tool, like the API encoder codepen, which helps build filterByFormula to send to the API via getTableAsync.

The API encoder accepts a filterByFormula, but it doesn’t help you formulate one.

I have a large Vue site with checkboxes (imagine a furniture store where you can choose size, color, dimensions, name, etc.) and I want to build the filterByFormula on-the-fly as people check and uncheck boxes, but I’m not sure the syntax for a long, complex filterByFormula.

1 reply

kuovonne
Forum|alt.badge.img+27
  • Brainy
  • 6001 replies
  • May 28, 2021

Build and test the formula as a formula field in the Airtable user interface. Once you have a working formula in the user interface, the rest is string manipulation.


Reply