Skip to main content
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?

Welcome 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 nmentee] has a city and a field of activity, but no linked kpair]. Then have a “Find Records” action that looks for a smentor] 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.

Reply


Terms & Conditions