I need to track attendance for multiple people from 2 different sites for 12 different classes held on different dates. I currently do this using an excel file attachment via email ( a different sheet for each class) to the site coordinators then run update queries on a participant_course table in my database but was looking for a way to automate this if possible.
I've tried creating a single table in my database with only the data that I would need for a specific class but when I try the "Collect and update data via email" option (HTML form as not everyone has InfoPath) I end up with a blank form.
I want to be able to populate a form with all of the names of the class participants as read only and just have the coordinators update their attendance on the form and email that back to me for each class at each site. We do have Sharepoint and I think there is a way to do this using Sharepoint but I have had no luck convincing our IT deparment to do this project. The database I am using is not connected with Sharepoint nor do I see that happening in the near future either.
I would welcome any suggestions as to the most efficient way to accomplish this task. It works ok the way I do it now but anything I learn just helps me add to my skills and makes my job that much easier.
Thank you in advance!