Sep 30, 2022 11:58 AM
I’m really hoping for some help here as I’m struggling to find the solution.
Here is my problem:
I’m running a survey into multiple schools / classes, and I can’t link the # of the survey to the students in each class automatically.
So on one hand I have a table with the surveys that I will be running in each school and class. On another hand I have a table with all my students with the class they are in as well as the school.
If I would be in excel, I would create a basic concatenate of the unique combination of school+class and link to the student table.
In Airtable I’m able to link yes. But by doing this through the link to a record field, I need to manually associate the students to to the other table, which when I will have 2000 students it’s going to be a huge problem.
I’m attaching screen shots… thanks for the help!!!
Sep 30, 2022 08:15 PM
Hey Patrick, maybe you could try creating that concatenation you mentioned of school + class for both the
Students tables, create another table called
Classes, and then link everything together via that value with automations? You’d then be able to pull over the survey value via a lookup field
Oct 03, 2022 10:08 AM
Thanks a lot @Adam_TheTimeSavingCo that’s very very helpful!
One question for you… when you create the “link to table school” on the classes table, do I need to pick the school every time ? Or can it be automatically recognized ?
That’s my concern, is that I still need to manually select the school each time.
Or am I mistaken?
Thanks a lot!
Oct 03, 2022 08:26 PM
You’d use an automation to link it up, and it’d depend on where your records were being created
For example, if your records are primarily being created in the
Students table, then you’d have an automation that would trigger when a record in that table’s
Classes field was empty and its
Concat field was not empty, and the action would be to paste the value in the
Concat field into the
Classes field, which would automatically link them together, does that make sense?
Oct 04, 2022 04:22 AM
It makes perfect sense !! Thank you very much again for the help, very appreciated!