Help

Tool to help build filterByFormulas for API?

Topic Labels: Scripting extentions
953 1
cancel
Showing results for 
Search instead for 
Did you mean: 
kirkbross
5 - Automation Enthusiast
5 - Automation Enthusiast

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 1

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.