Howdy folks,

I'm part of an online community, and we run weekly events. I'm looking for a way to post an online form (likely google forms) where people can answer about their availability for these events throughout the week. I then want it to populate into an online spreadsheet or calendar automatically so we have an idea of who is available at what times. Suggestions and tweaks welcome.

To be more specific, times are listed for each day of the week, with the following options:

Mornings are best for me (before 11am)
11am-1pm
1pm-3pm
3pm-5pm
5pm-7pm
7pm-9pm
9pm-11pm
11pm-1am
I never sleep (after 1am)

This is a pretty complex spreadsheet based task for me, and the last time I had one like this you all were immensely helpful. Can anyone help a brother out?

Thanks!