sheet and Google Form can be used to RSVP for events especially useful in this kovat 19 social distancing time so you can define your event in this spreadsheet and when you fill in a form let's say I want to go to the mini event I will sign up with four people and submit and now when I try to submit again you saw that there were four seats left and now the mini so now the mini event is wait-listed so a bit of intelligence in the in this event list and you can see it in the here as well there is a availability of minus one and it also shows in the in the list of that signed up and got filled through the Google Form submission so to do this this script is run every time a form is submitted and it will update the list of available events to choose from and one frame if you copy this sheet I will set a link in the video description you must manually add this trigger so a trigger whenever a form is submitted the update selection function should be run so please leave a comment if this is helpful for you or your events I would appreciate it thank you and goodbye