Im trying to learn more about Airtable best practice in terms of overall schema/base design and structure. My question is: How can I more quickly add data to tables and cut out some manual work? Here’s the specific context.
I currently have a document with three tables
Students (Database table, one record per student)
Classes (Database table, one record per class)
Enrollments (Junction table, handling the many-many relationships between students and classes)
Currently, the junction table only has three columns (Name, Student, Class)
But to add a New Enrollment, it feels very clunky and like there is a lot of manual work. You have to select both the student and the class each time.
What If I need to add a lot of students to classes at once? Is there any easy way to do that? For example, could I batch select 35 students and with one action add them all to a target class?
What if I want to continually add x amount of students to the beginner class? Is there an easy way to not have to keep selecting the beginner record in the class column every time? For example, could I set a “value for new records” so every time I create a new record, it populates the class with the desired selection and then all I have to select is the student?
I know I can do that with an automation, but I need the solution to be more agile. Because in 1 minute I may add 15 students to a beginner class, and then 5 minutes later I may add 20 students to the intermediate class
Here’s how Im currently doing it, but it still feels like a lot of clicks