Airtable integration not working as expected

When asking your question, please include:

:footprints: The steps you have taken
:camera_flash: Relevant screenshots
:link: Any links you have
[ Code { "and": "JSON", "in" : "code block"} ]
:x: Exclude Personal Information.

Hi, I have tried to link a Podio sheet with Airtable and try and continuously update the Airtable base as soon as someone updates something in Podio. I’ve used this scenario but keep receiving this error: The operation failed with an error. [422] The formula for filtering records is invalid: Invalid formula. Please check your formula text.

Any suggestions would be greatly appreciated :slight_smile:

Hi @Dhiresh_Nathwani

This error indicates that the input formula is wrong.

An Airtable formula is used to filter records. The formula will be evaluated for each record, and if the result is not 0 , false , "" , NaN , [] , or #Error! the record will be included in the response.

You can find more information about the formula on Airtable’s website.
For example, to only include records where Name isn’t empty, pass in: NOT({Name} = '')

If you need assistance, don’t hesitate to contact me.

Best Regards,

Msquare Automation
:point_right: Visit our website | :spiral_calendar: Book a free consult

1 Like