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

Tool to help build filterByFormulas for API?

Topic Labels: Scripting extentions
281 1
Showing results for 
Search instead for 
Did you mean: 

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.