Automation to add linked record | Airtable Community

Hi,

I have three tables :

- students

- challenges

- attachments

There is a form that allow students to submit challenges in the table attachments. When I receive a challenge submitted by a student, I review it and if it is correct, I manually link the challenge from the table challenges to the row challenges done in the table students.

Here are screenshots for an exemple. In this example, student 1 submitted challenge ex3 and it was correct so I added ex3 to the list of challenges done by student 1 in the table students.

Attachments :

Challenges :

Students :

I want to automate this. When I click on success for a row in the table attachment, I want to automatically add the challenge succeded in the row challenges done in the table students.

I chose this as a trigger :

But when I automatically update the record, it replaces the list of linked records in the row challenges done by the new challenge only instead of adding the new challenge to the existing list of challenges done by the student.

Do you know how I can automatically add a linked record challenge to the list of linked records (like clicking on a “plus” button) instead of replacing the list of linked records by the new linked record ?

Thanks for your help !

Page 1 / 1

Hello - i think i can help here without an automation by using roll-ups if i have understood correctly.

Attachments is effectively a junction table between students and challenges - and is effectively their submission.

When a student submits their challenge - you need a way of linking this to the student and to the challenge.

This can be done by getting the students to select their name and the challenge number in the form (we will improve on this later)

Then you have the attachments linked to both the student and hte challenge.

You now need a way of marking the success or otherwise (could be as simple as a check box field - or single select or a mark % etc) - lets go with check box for now - your success box)

For a successful attachment (submission) you check this box.

Now in the challenges table - you create a LOOKUP field of Attachments which selects the name of the students CONDITIONAL on when the record is ticked as success

On the students table you create a LOOKUP field of attachments with the name of the Challenge CONDITIONAL on being successful.

Now it may not be great practice for students to select themselves from a list in the form (as they may pick the wrong person) - so you can use emails (with an automation to link to the correct student) or unique reference numbers (which you can make as a field which also creates an automation to link to the student - so that in the attachments (submissions) table you are connecting both STUDENTS and CHALLENGES

When you update the record, you have to include the existing linked records along with the new linked record, using a comma separated list.

In order to get the existing linked records for the student, you need to do a “find records” action to get the data for that student. Then you can pull the existing linked records for the student from the find action using the plus sign.