Hey there!

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

1. Students (Database table, one record per student)



2. Classes (Database table, one record per class)



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