I have a checklist of topics that need to be discussed at a workshop. I want to combine this checklist with a form feature where the trainer enters the student name, date of workshop and then checks each topic discussed at that specific workshop. How do I accomplish this?
Currently my checklist of topics is on a googlesheets tab with topics in rows. It would be ideal if each new workshop could be added as a column through the form with the checklist values field referencing the new column with workshop date. But I am not sure how I can have the user add a column for each new workshop.
Or perhaps there is another easier and more elegant way to accomplish this. I can change the configuration of my google sheet to be able to accommodate any suggestions provided.
Thankyou in advance for reading this and for solutions.