I am building a matc hmaking app for jobs (offers and requests).
I have two tables : first for job offers and second for profils
in both tables i use many fields but 4 have same options (multi select).
I would like to match those two tables based on the 4th fields, if all have same options then start an automation like email.
Do i need an extrenat tool like parabola or it can be done inside airtable with linked tables for example ? How i can include data from a linked table automatically ?
Thanks a lot for your advicess :slightly_smiling_face:
You could try this with an Automation involving a Script. Trigger the automation on the creation of a new record in one of your tables. The first step will be a script, and your script will need two inputs:
Name: options, Value: [Record (Step 1 Trigger) … MultiSelectField … List of ‘name’]
Name: triggerRecordId, Value: [Record (Step 1 Trigger) … Record ID]
The above script checks the values for the multiselect field against the values of the “same” multiselect field in the other table. If the values match, the script finds that matching record’s associated email.
From there your next step could send an email using the output from the script: matchesEmails