Gary, I have a challenge that many others may also have.
I run an Aikido dojo and wish to use Numbers to register attendance at classes. I wish to use a data entry form to do so, where the form would be on my iPhone and the data would accumulate on a spreadsheet that I would review on my iMac. The title of the iPhone form would be the date of the class; the first column would consist of the names of my students and the second column a check box; I would check the box if the student was present at class. Upon checking the box, this would transform into a “1” in the spreadsheet, allowing me to count the number of classes attended by each student at the end of the year.
The first column of the spreadsheet would include the students’ names and the top of each column would show the date of each class. The cells in the table would be populated by the “1s” showing each student’s attendance.
Is such a process possible using Numbers? Thanks so much for considering this challenge!