Feb 08, 2021 08:56 AM
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.
Scan Airtable A base, if the output is not empty, set the variable Clinic A to results.
Scan Airtable B base, if the output is not empty, set the variable Clinic B to results.
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.
Solved! Go to Solution.
Feb 09, 2021 06:01 AM
Feb 09, 2021 06:01 AM
Solved with a use of if functions.
Jun 18, 2024 08:22 AM
With an API, here is the best way to do it
https://community.airtable.com/t5/development-apis/search-multiple-bases/td-p/187372