Help

Re: Automation to add linked record

Solved
Jump to Solution
3717 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Olivier_N
5 - Automation Enthusiast
5 - Automation Enthusiast

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 :
Capture d’écran 2022-07-27 à 10.56.03

Challenges :
Capture d’écran 2022-07-27 à 10.54.14

Students :
Capture d’écran 2022-07-27 à 10.54.10

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 :
Capture d’écran 2022-07-27 à 10.46.40

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.

Capture d’écran 2022-07-27 à 10.48.19

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 !

1 Solution

Accepted Solutions
Russell_Findlay
8 - Airtable Astronomer
8 - Airtable Astronomer

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

image

image

image

See Solution in Thread

8 Replies 8
Russell_Findlay
8 - Airtable Astronomer
8 - Airtable Astronomer

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

image

image

image

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.

Very nice solution, worked very well, better than automatisation !
Thanks !!

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 !

Capture d’écran 2022-07-27 à 15.40.46

Did you test all prior steps in the automation?

Also, I would do a search for the student record and get the value from there, not a search of the challenges table.

Yes I did.
Yes I tried to get the student record but same problem… I don’t understand why
Capture d’écran 2022-07-27 à 17.51.28

tgrier
5 - Automation Enthusiast
5 - Automation Enthusiast

Bumping this as I have wondered how to do this. In a similar case, I have a form submitted from staff detailing an incident. I or another supervisor compiles a report on a second table. If I want to send the completed report and insert data from the original report, seemingly I have to use lookups or rollups to bring that data to the report table. Seems like an inefficient solution. Would love to be able to automate with "Find Record" and connect without having to muddy up a table.

aclayton
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

aclayton_0-1673391485615.png