How to send email to an entire coloumn on another sheet if some conditions met via zapier or make?

Hi @FIRAT_BAYRAM_BAKIR ,

Welcome to Airtable Community !

This can be done very easily.

I would however make sure the country is not a single text field, i.e.: they cannot change the capitalization.

Second, using Zapier newly added Line Items support you can search for the country in the vendors table and send emails using Loop in Zapier.

Thanks for the reply.

Currently I am doing this but don’t know how to filter by country.

You can use the Search Records and input something like that in the formula

@ScottWorld would be much better at this though as he works more with Make.com. I use Zapier.com usually

@FIRAT_BAYRAM_BAKIR

For your “Search Records” step, you would just use a normal Airtable formula, but be sure to insert the value from the first module in quotation marks to compare to your Airtable field. Something like this:

{Your Country Field}="🟦🟦🟦"

Replace the blue boxes with your desired value from the first module.

Hey Scott!

Thanks for the reply.

I am getting an error= The operation failed with an error. The formula for filtering records is invalid: Invalid formula. Please check your formula text.

This is the requests:

This is the Vendor airtable:

and lastly, this is the search formula:

Any input is appreciated

You need to put {curly brackets} around your field name, not (parentheses).

Tried that as well =(

Post a screenshot of the error you’re getting.

Sure!

If you are sure of the table and base, then I would assume the field name has a space or something in the end. Try copy pasting the name