Hi,
I've connected my Airtable to callin.io and need to search records within it to automate a workflow.
Specifically, I need to match the value from my Airtable's "Suppliers" column with a field in Jotform (which is already connected) called "Supplier Name" (highlighted in red). I also need to include all records from these rows where another Airtable column, "Photos submitted?", is set to ‘No’.
I've added the "search records" module and used the following formula: ({{30.Suppliers}} = ‘{{1.request.q6_supplierName}}’) AND {{30.Photos submitted?
}}=‘No’
It appears Airtable doesn't support array brackets, but callin.io automatically adds them when I reference Airtable in the formula.
Could someone please assist me in getting this module to function correctly?
Hello,
Welcome to the
community.
Airtable Search is functioning with FilterByFormula.
I have provided several answers on this subject regarding how to use Airtable FilterByFormula with callin.io.
Please review these answers where I have also included multiple related resources.
P.S.: Always search first. Check callin.io Academy. If this was helpful, Mark Best as Solutions
and give
If you have any questions or need further assistance, please feel free to ask or comment below!