Creating an automation to find records based on condition

Topic Labels: Automations
682 1
Showing results for 
Search instead for 
Did you mean: 
7 - App Architect
7 - App Architect

Hi everyone,
I’m creating an automation to find records based on various conditions from a table.
I have two tables let say Entrepreneurs and Midwest Investors.
when a form submitted in Entrepreneurs then I am trying to find a records from Midwest Investors that matches with new record in Entrepreneurs. Here are the condition

Conditions are:
Midwest Investors with Entrepreneurs

Investment stage has any of Investment stage

Investment verticals has all of Industry

Ideal revenue is Annual Revenue
(Projected This year)

Investment Geography has any of What region’s doe’s the
Company operates in.

The above 2 condition should always match to proceed further but in airtable automation all conditions are either in “AND” or “OR”.

So, how to achieve my goal here?

Also, how to create document with matched data for entrepreneurs(if its possible to create sheet).

1 Reply 1

I've recently asked Airtable developers to add the addition of grouped conditions to Automations so that we can structure such And/Or queries without the need for creating a view (or some kind of formula field workaround).

I think you're best bet may be to construct the validation in a Grid View, protect that view from being edited by users, and then use that view with your automation.