Here how you should do.
The first three screenshots are related to the Airtable database setup
The last three screenshots are related to the Softr studio setup
You can see at the end a GIF on how it works live (with very basic data, from the Airtable tables I showed above)
Does it fit your need? The assignments are set by courses or by student? One assignment per student/course or multiple assignments per student/course?
