We are working on a complex student reporting table for an education organisation and we’ve come across this use case:
We have a students table, a programmes table, an attendance table and a results table. We’d like to be able to create a new student, select the programme they are enrolled in and have Airtable automatically create an empty “results row” in the results table and an “attendence row” in the attendance table. Both should have the student name and the programme linked in the relevant link field.
This would save a lot of manual work for the organisation