Hi all ,
I currently have 3 table in 1 database, one "mentor", one "mentee" and a third "pair".
I want to be able to match a mentor and a mentee with 2 criteria such as their cities and their fields of activity and thus insert them in "pairs".
But I can only put a trigger on one table.
Do you have a solution to target 2 tables in the automation?
When record matches 2 conditions
+29Welcome to the Airtable community!
Try using a different trigger based on one table, and then do a “Find Records” action to look for records that match in the other table. For example, the trigger could be when a [mentee] has a city and a field of activity, but no linked [pair]. Then have a “Find Records” action that looks for a [mentor] in the same city with the same field of activity. Note however, if mentees could have multiple cities or fields of activities, it might be difficult to find a partial match (e.g. a mentor in one of the cities with only one of the fields of activities) without scripting.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.