Here's what I want to do:
In a Google Sheet, I will have a list of times. Each time is either available or unavailable.
In a Google Form, upon loading the Form, a drop down list is populated with times that are available at the time of Form load based on the Google Sheet. The user will choose a time slot and enter his unique ID.
On click submit, the program will first check if this user has already signed up. If so, it will acquire a write lock on his previous time slot, make it available, and release the lock.
It will now check if the new slot is available or not. If not available, it will inform the user the time is no longer available, reupdate the drop down list with the new state of the sheet, and return to the form.
If the new slot is available, the program will get a write lock on the selected time slot, write to make it unavailable, and then release the write lock. Afterwards, the form will close.
This seems like such a simple and common thing to do, but how can it be accomplished/can it be accomplished with Google scripts?
I ask because I want to accomplish this in a day or so.
Any help appreciated.
In a Google Sheet, I will have a list of times. Each time is either available or unavailable.
In a Google Form, upon loading the Form, a drop down list is populated with times that are available at the time of Form load based on the Google Sheet. The user will choose a time slot and enter his unique ID.
On click submit, the program will first check if this user has already signed up. If so, it will acquire a write lock on his previous time slot, make it available, and release the lock.
It will now check if the new slot is available or not. If not available, it will inform the user the time is no longer available, reupdate the drop down list with the new state of the sheet, and return to the form.
If the new slot is available, the program will get a write lock on the selected time slot, write to make it unavailable, and then release the write lock. Afterwards, the form will close.
This seems like such a simple and common thing to do, but how can it be accomplished/can it be accomplished with Google scripts?
I ask because I want to accomplish this in a day or so.
Any help appreciated.