Airtable for Teachers - using it to record grades and assignments for multiple classes

239 5
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I saw this video on using air table for schools, and tried to copy the design she talked through at the end - but since it was all in groups and I am pretty new to air table, I couldn't get the automations to work, or see how the grade and assignment tables were actually set up.

Does anyone have a base design for recording assignments and grades for students - something where once the assignment is created student record lines are automatically created for the students in that assignment's class  in the grades table for scoring data to just be added?

This is the podcast I watched and really failed to imitate - from 46 minutes onwards. 

5 Replies 5

Hmm, does this look right?
Screenshot 2024-07-04 at 11.06.18 AM.png

Screen Recording 2024-07-04 at 11.07.16 AM.gif

If so, try setting up your automation like this:

Screenshot 2024-07-04 at 11.07.42 AM.png

Link to base

4 - Data Explorer
4 - Data Explorer

Kind of, but somehow I think I've messed this up too.

I tested out the automation, just by creating a quiz in assignments. I checked the check box and then activated the automation - but I only got this. 





Do I need to list the assignment in the student table grades field too for this to work? 

I feel I am missing something so simple. This is what the original looked like in the podcast- though I don't need it to be quite this detailed. 



re: Do I need to list the assignment in the student table grades field too for this to work? 

Nope, once you hit the checkbox it'll create one record in the "Grades" table per student found in the "Student" table, linked to the Student and the Assignment

I just tested my base again with a new assignment and it created 3 new Grade records as expected.  If this is what you want to happen and you need help troubleshooting your setup could you provide a read-only invite link with some example data to your base so I can set it up for you real quick?

4 - Data Explorer
4 - Data Explorer

Apologies for the delay, end of term and things kept happening. read only link is below:

Thanks for the link!  Hmm, I duplicated your base and ran the automation and it created one record per Student:

Screen Recording 2024-07-08 at 11.32.01 AM.gif

Resulting in this in the "Grades" table:

Screenshot 2024-07-08 at 11.33.55 AM.png

Not sure why it wouldn't work for you, sorry!  I'd recommend just turning the automaton on and off again, and then testing the trigger again