Skip to content
Airtable formula is...
 
Notifications
Clear all

Airtable formula issue: searching records

2 Posts
2 Users
0 Reactions
4 Views
Fan_Zhang
(@fan_zhang)
Posts: 1
New Member
Topic starter
 

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?

 
Posted : 13/05/2025 11:37 pm
dilipborad
(@dilipborad)
Posts: 28
Eminent Member
 

Hello,
Welcome to the

:make:

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.


:light_bulb:

P.S.: Always search first. Check callin.io Academy. If this was helpful, Mark Best as Solutions

:white_check_mark:

and give

:+1:

If you have any questions or need further assistance, please feel free to ask or comment below!

:backhand_index_pointing_down:

 
Posted : 15/05/2025 4:47 am
Share: