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:
- Name (Single Line Text)
- Question (Long Text)
- Industry/Topic (Multiple Select)
- Location (Multiple Select)
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.
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: