I’ve got a couple different Airtable bases that include tracking attendance. In both situation I find myself entering the names of 20–30 people in a field in my attendance tracking table. (More precisely, I’m linking to those individuals’ records in the relevant table.)
The interface seems ungainly, and without the ability to filter records when viewing all of the students who may be attending a certain class based on their schedule, the number of possible attendees is large. It takes a long time to enter 20+ people in the linked field that records their attendance.
A typical spreadsheet approach would be to create a column for each meeting that requires taking attendance and quickly enter an “x” or some other indicator that the person was present. This is really quick and allows for basic calculations, but isn’t very elegant from a database standpoint.
Is there a good way to speed up the process of selecting and adding a large number of records to a linked field?
Am I missing an alternative design that would make things more streamlined?