Thanks for the update. The way I see this working the most efficiently is with each record representing a single date that someone is available, along with their task choices (multi-select) and desired work hours (two single-selects for start and end times). That’s fairly easy to collect via form if someone can only work one day. If they want to pick the same tasks and work hours across several days, it becomes trickier from a data collection standpoint.
The brute force method is to build a form where the volunteers will need to fill out the form once for each date they wish to work. For example, Volunteer A will fill out the form three times—once each for 6/6, 6/13, and 6/27—choosing “Hang Signs” and “Direct Vendor to Parking”, and also choosing a start time of 11am and an end time of 3pm each time.
To reduce the headache for the volunteers, the form could be designed with a series of date fields—let’s say 5—that are conditionally revealed based on the number chosen in another field; e.g. if the volunteer says they can work 3 days, only 3 date fields are revealed. All of those date fields are only temporary, though, because the form would be submitted to either Zapier or Integromat for processing, with each of the entered dates leading to the creation of a new record with the same tasks and work hours. So the user fills out the form once listing three dates, and the integration system makes three records, one for each date. It’s the same end result as above, a little trickier to set up, but easier on the volunteers.
Once you’ve collected all the data, you can sort and/or group by date to see who’s working each day.
