Create an attendance list for the exercises

Hmm, if you could go into detail about the workflows you have in mind I could try to help?  What difficulties are you facing specifically?

I also do free half hour calls and we can hop on and get some stuff done together if you’d like, and you can schedule a time here!

As ​@TheTimeSavingCo said, the more details in your problems, the easier it is for us to help.

That said for some broad advice on your second/third things mentioned…

• For scheduling trainings + indicating attendance, I usually build this as two tables, one for the actual training programs(call this A) and the other for registrations (B) to the programs. Where I have this in production, A has a date as it’s primary field and B has free text name as it’s primary. I have a view in A that filters out past sessions, and then in B I have a form view and the linked record field between them in that form view is filtered by the present->future view in A. That way people only sign up for upcoming sessions.
• B is modelled for every registration (so people show up over and over again) and there’s a ✅ field for attendance. In A there's two rollup fields summing total registrations and registrations where attendance is checked.
• My production is for smallish (30-40 attendees monthly) public events, so I have an automation that checks my contact table (table C) for any registrants where their email address already exists and ties that together. This requires a bit of manual checking but it’s not too onerous. 

Just trying to intuit your needs from your short post, I see the staffing level calculations as basically separate from training/registration. You could probably roll it all into the same base though. For your staffing, is this a volunteer fire station and people are signing up for shifts or are they being assigned? 

Hello,

I would suggest putting together an Operational Database which will help you organize your stations data much more efficiently.

First I would create a base for your station and then

• Have a table listing all your Employees
• A table listing training sessions
• A table with Staffing Levels
• A table for Attendance

Make sure to link your Employees table to the Training Sessions and Staffing Levels table.

In the attendance table you would have fields for Employee, a Checkbox field for Attendance and training session.

You would then create an automation that would create a new record in that Attendance table with every employee who is registered and the training session. 

Additionally I would create separate views with a Filter on the Attendance table for that specific day, etc. so you could easily check off all of the attendees.  You could further customize this with a form for each signup which adds flexibility.

Thank you for all these replies. I'll try implementing AnthonyXRay's solution. I'll come back for advice if I can't get it to work. Have a good day.