Mar 29, 2021 05:08 AM
Hello,
I am building a service that lets users hire experts to answer industry-specific questions.
And this is how the workflow would look like:
I have two tables called User and Expert.
User fills in an Airtable form that asks the following questions:
Airtable automation finds an expert meeting the criteria by matching the Industry/Topic column along with the Location column and sends them an email requesting them to answer the question.
Here is the problem I am facing,
How do I devise the automation in such a way that it matches the right expert with the user based on the Industry and Location?
Currently, the problem I am facing is that I am unable to match using multiple topics from a single multiple select field.
For example,
User question: How does Bitcoin work?
Industry: Bitcoin, Cryptocurrency
Location: United States of America
Now, I want the automation to match it exactly to an expert in Bitcoin and Crypto in USA.
How would I do that?
Examples of how the tables are setup:
Clients Table:
Experts Table
Mar 29, 2021 06:44 AM
You could probably use the “Find Records” automation action to search for what you need, but after that, you would need conditional logic to figure out what to do if your searches result in more than one matching result. For example, which expert would you email if there was more than one result?
Conditional logic is not currently possible with Airtable’s native automation support, and Airtable’s automations only supports emailing ALL of your found matches (not just ONE of your matches).
So, if Airtable’s automations aren’t robust enough to handle your needs, you would have to accomplish this in another way. You could:
or
(Note that I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat link contains my personal referral code.)