Yes, I use a google form. I've enclosed screenshots of the form and then the responses that come with them.
I then create a master schedule based on the conflicts.
I'm sure that if you're really well versed in google sheets you can create some sort of "pivot table" to sort the data, but I don't have time to do that currently.
It's been working for me for a while. Slight pain, but really helpful. I only call students when I am rehearsing them.
Joan
------------------------------
Joan Jubett
(she/her)
Director of High School Fall Play and Spring Festival of Plays
High School Theater Teacher
LREI
New York, NY
------------------------------