Tool to help build filterByFormulas for API?

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.

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.

2 Likes