Then, we will use Google Apps Script to update the Google Form with the number of seats each time the form is submitted. We will need to use Google Sheets to store our bookings and do some manipulation of the data. Google Forms can’t do this for you out of the box. We will even create a live list of attendees that we can embed on our website using Google Sheets. If all seats have been booked for all seminars, then the Google Form will close. If all the seats have been booked for a seminar, then that seminar will not appear on the form. Take a look at the example below (click to expand the image): It will contain a registeree’s name and the session that they wish to attend.Įach time a registeree submits a request to book a seat for a session, that seat is taken from the list displaying only the remaining seats for that session for when the next user submits the form. In this tutorial, we are going to build a simple seat booking Google Form. Google Forms, Google Sheets, Google Apps Script: SpreadsheetApp, FormApp
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |