Home › Forums › Google Sheets & Forms › Can I use Google Forms for parents to purchase tickets to the school production? › Reply To: Can I use Google Forms for parents to purchase tickets to the school production?
November 28, 2018 at 1:04 pm
#5596
![](https://members.learningarchitects.com/wp-content/uploads/avatars/1/5d1d85374968e-bpfull.jpg)
Keymaster
Hi Anne,
Because you have multiple days in which people can sign up, I think you will need to use Form Ranger and a series of formulas in the Spreadsheet.
I’ve made a new tab in the spreadsheet for this for you. Some notes:
- You need a formula to count the performance as it is submitted to the form. This is a COUNTIF formula 😉
- Once that is done, you can figure out the remaining seats for each performance.
- Then, FormRanger can pull this data through to the form and present it almost perfectly dynamically.
Check out the video I posted earlier about an RSVP system using FormRanger, and let me know how you go!
Rob
-
This reply was modified 5 years, 9 months ago by
Rob Clarke. Reason: Added URL to tutorial for countif