Scan Multiple Bases

[slyfox]

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.

[slyfox · Accepted solution]

Solved with a use of if functions.

[Lucas_Ravassall]

With an API, here is the best way to do it

https://community.airtable.com/t5/development-apis/search-multiple-bases/td-p/187372