Automation to link multiple records upon output of a form submission

[olireynoldson]

Hi all,

Wanted to see if anyone had any ideas why the following isn't working.

Background

• I have a table of issues each with a specific code
• I also have a table that takes form submissions for the yes/no output of questions in the form.
• When the a question is answered "yes" I want to create a link in a lookup field to the issues table to record the specific issue found.

Issue

• Upon the form submission the automation I have set up only works for the first question. After the first question none of the other questions answered yes are linking to the specific record.

Any ideas why this is?

[TheTimeSavingCo]

Ah, once the first criteria gets met the automation stops running I'm afraid. 

If you could provide some screenshots of your form table and your issues table perhaps we could find a workaround?

[kuovonne · Accepted solution]

You can create a helper formula field that creates a comma separated list of the records to link to. Then have the automation copy the formula result to the linked record field. The formula does the heavy lifting of determining which records to link to, and the automation just creates the link.

You can see a write up of this solution in my my Guide to Airtable. 

On the other hand, even if this solution works for you, you might want to run your base schema by an experienced Airtable consultant. It looks like you have a lot of linked record fields.

[olireynoldson]

Good to know re the automation.

In the form table I am trying to automate the linking of specific records from another table if the question in the form is answered yes. Essentially the specific question will always link to the same record. There's around 14 questions in total.

 

 

[olireynoldson]

Thanks Kuovonne - let me take a look at this method and come back to you

[TheTimeSavingCo]

Roger that.  Looks like you're exploring a possible solution already; happy to help further if needed

[olireynoldson]

Got it to work and seems to fit the bill. Appreciate the help!