Help

Scan Multiple Bases

Solved
Jump to Solution
1237 2
cancel
Showing results for 
Search instead for 
Did you mean: 
slyfox
6 - Interface Innovator
6 - Interface Innovator

I need to search records in multiple databases and if the search result is not empty then set a variable for that particular organization. I will then compose an email using non empty variables.

  1. Scan Airtable A base, if the output is not empty, set the variable Clinic A to results.

  2. Scan Airtable B base, if the output is not empty, set the variable Clinic B to results.

  3. Compose email that includes non empty variables:

Hi John Smith,

Please submit the following items:

Clinic A variable (has value - not empty)

[Clinic B variable is not included as the variable in the previous scenario was empty due to no search results)

Can’t figure this one out as Integromat requires everything to go in a flow as I am using filters to filter in or out empty search results. But if search results for variable A are not passed then the rest of the flow does not happen.

1 Solution

Accepted Solutions
slyfox
6 - Interface Innovator
6 - Interface Innovator

Solved with a use of if functions.

See Solution in Thread

2 Replies 2
slyfox
6 - Interface Innovator
6 - Interface Innovator

Solved with a use of if functions.

Lucas_Ravassall
6 - Interface Innovator
6 - Interface Innovator