I’m struggling to know how to structure a Tap Forms Pro database to compose class rosters.
Right now I have several forms, with forms linked using a joining record. The forms I currently have are…
Students form for student demographics, with the Teacher as the joining field.
Classes/Periods form for the day, period, and day, with Teacher as the joining field.
Calendar for the quarter, week number, day of the week, and date.
What I want to end up with is a traditional daily (weekly in my case) attendance roster, with names down the left side, and dates across the top. When printed out, I will write in attendance/grades in the intersecting “cell”. (I don’t currently have plans to record grades or attendance in this database. This database is intended only to generate printable attendance rosters.)
I already have this in a Numbers on Mac spreadsheet but want to transfer this into Tap Forms Pro.
I need a class/period associated with a subset of students (e.g. all the students assigned to a particular teacher) and a subset of dates (e.g. all the Monday dates from Quarter 1). The info needs to be layed out in a traditional roster format.
I can imagine how to get a list of names down the left side for a particular class. Where I’m struggling most is how to get the dates to run across the top and get the attendance grid.
I have attached an anonymized screenshot as an example from my Number spreadsheet. Thanks for any ideas on how to structure this!
Attachments:
You must be
logged in to view attached files.
.
