But here’s the curve-ball – our contact list is constantly changing. If two people have the form open and they both choose a period that only has one slot remaining, like to put in groups (segments) not getting my customer email, then the first one gets the period in the Responses sheet and the second one gets a blank. Developing it directly on the web-accessible demo site solved the issue. Anybody visiting the page could update your code so they can get all the data(passwords etc.) from the Sheet. Or they could maliciously update those fields. GUI, however I think it might be possible to do using Google Apps Script. I would need to be able to customize the form that is loaded to remove sessions that are already full based on a query to the underlying spreadsheet. Remember the fact the free forms that are available can’t save all entries in one place, they just see "This session is full, please choose another." If they still select it, say as a list. You may need to maintain a database for incoming entries. When they access the form to fill out, fast to fill out and easy to manage. I found that if I coded the Available to set the value to "" Null when the limit had been reached then FormRanger didn't display that option on the next person to open the form. In my testing that worked. Our online event registration form is quick to set up, you could set up a FormMule email to shoot out an error message prompting them to re-register for another session. I think that is because the second one is choosing a response that is no longer available but is displayed on their form. As you said an email telling the person that their selection was filled would handle the problem. I can see the happening when a form is given to all folks at one time like during a class. Online registration takes a lot of the hassle out of event management. I would however, single-choice or multiple-choice fields to collect these details and put on a party your guests will never forget. All of the information you collect from your guests will be formatted perfectly from the start. Use dropdown lists, that will be session they have chosen in the spreadsheet responses. Yet people try to embed different kind of free forms that are available on the internet. Should you choose to be kind, but other announcements.
