Making an app for a gym with classes where I want someone to be able to sign up, remove themselves if they decide they cant attend but also want to be able to count how many people are signed up.
The checkbox/boolean is easiest for attending/not attending but that alone wouldnt let me count how many people signed up (which would trigger when to close the class to new sign ups).
I was originally doing a +1 on the form when they sign up and a -1 when they remove themselves but this created issues with visibility of form-buttons if they decided they wanted to re-sign up for the classes.
Ideally I would want them to remove themselves from the class and still count how many are remaining. I understand that me manually deleting the row would solve most of the steps of the solution i am seeking. Perhaps just another form where their request to be removed goes to another Sheet where i can see the entry and take action.
go to your form then you will see a section called special values
unique id ,current date and email of current user
qith the email special value you can get the mail of the person filling the form
without asking for it
note your app has to be public with email
Have a form writing the user’s email and the class’ name/ID to your registration sheet.
Count the number of unique emails via rollup over the relation matching the class name/ID with themselves.
Add a boolean column to let user un-sign up as you wish, in the class screen filter the list of users by boolean column is not True (True = they have un-sign up).
If they want to join again, they just need to turn off that boolean column via a switch.
If you want to count how many users have un-sign up, you can make a template column joining the class’ name/ID and “False”, make a relation matching that with itself, then use a rollup to count the number of values that match the template column.