Thanks for your time. I’m looking for some help with a form that allows facilitators to sign up for training sessions. These sessions happen every week and require multiple facilitators. I’m asking for their help, so I want them to have to do them minimum amount of form-filling possible.
My ideal situation is:
- A form in which facilitators can select their name from a drop down list (that bit is fine)
- A form which lets them select which sessions they are able to attend (this bit is where I’m having issues)
- And a backend system in which I can see which facilitators are attending a session easily.
I’ve been experimenting with three potential situations
The facilitator chooses the date from a date field on the form
Upsides: I know it works
Downsides: They might choose the wrong date, and they also have to submit multiple forms in order to share their availability with me
A linked table with the specific dates already input
Upsides: No danger of facilitators entering the wrong date. Easy for me to organise/admin in the backend
Downsides: Still have to submit multiple forms per facilitator
A long multiselect list with the 40 dates for this year that facilitators can select.
Upsides: Allows facilitators to select as many dates as they can do in one form submission (yay!)
Downsides: doesn’t allow me to view each individual date and who is signed up. I can’t group by date because the ‘group by’ option groups by each selection, so it would only group by facilitators who have chosen all the same dates, not by individual dates.
So with option 2 I’m annoying my facilitators and with option 3 I’m making life hard for myself. Is there any way I can fix this situation for us all? I’m on the free plan, but I can upgrade if I need to.