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.
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



Very nice solution, worked very well, better than automatisation !
Thanks !!
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.
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 !

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 !

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.
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

Yes I did.
Yes I tried to get the student record but same problem… I don’t understand why

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.
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.
