Airtable formula issue: search records

[Fan_Zhang]

Hi,

I have connected my Airtable to make and need to search records in it to automate a workflow.

I need to in this case match the value of the column of my Airtable called “Suppliers” with a field in a Jotform (which is already connected) called “Supplier Name” (in red) and use all records of these rows if another column in my Airtable “Photos submitted?”=‘No’

I have added the module “search records” and the formula: ({{30.Suppliers}} = ‘{{1.request.q6_supplierName}}’) AND {{30.Photos submitted?}}=‘No’

It seems Airtable does not allow [Array brackets], but Make adds these by itself when I reference the Airtable in the formula.

Can anyone help me and tell how to make this module work?

[dilipborad]

Hello @Fan_Zhang,
Welcome to the community.

Airtable Search is working with FilterByFormula.

I’ve already given multiple answers on this topic about how to use Airtable FilterByFormula with Make.
Please check this answers where I’ve also attached multiple related to it.

I cant fix the formula in the airtable "Search Records"

Hello @Santos, The formula you write on the Airtable Formula box in Make, Is not the same as you write on Airtable Formula Field. This formula in the make follows the specific syntax of the airtable formula that you can check here. https://support.airtable.com/docs/airtable-web-api-using-filterbyformula-or-sort-parameters As of now try to remove the surrounded if and use AND() only. Also, please check my answers related to this topic. :light_bulb:P.S.: Always search first, Check Make Ac…

[422] The formula for filtering records is invalid: Unknown field names: false

Hello @cleanbooks, There are 2 solutions you can do. As per Current Setup The Airtable Search Module formula field needs a formula syntax based on the airtable formula check this Airtable Web API - Using filterByFormula or sort parameters In your case, you need to use airtable functions AND, SEARCH or any of the Regular Expression. Please try both of these because the field {temp4} returns a boolean(true or false). Not sure that quote ("), is needed. Add these to your airtable field formula…

Airtable: [422] Unknown field name: true

Hello @Scottinabox, Instead of that try this AND({Status}='Done') Instead of AND you can use OR, SEARCH, or REGEX_MATCH. But it all depends on the requirements. The things you’ve tried were not matched with the Airtable formula structure. You need to match with airtable formula syntax. Read more on these help docs and community articles.

---

P.S.: Always search first, Check Make Academy. If this is helpful, Mark Best as Solutions and give
If you need expert help or have questions? Contact or comment below!