Re: Automation to add linked record
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 !
Accepted Solutions
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
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
I tried this but I could not do it. It don’t know if there is a problem with Airtable or if it is just me : I tried to search for all the challenges succeeded by the student but when I want to choose the ID of the student, it is impossible to click !
Bumping this too. I'm trying to add the previous values along with the new value but Airtable is giving me permission errors - probably because I am trying to add a list of values which don't exist in the linked record table. If anyone knows how to split the list into individual values so they're recognised by the base, that would be super.
