This is a custom form built with Google Apps Script, Vue JS, and Vue Material. You can make a copy of this spreadsheet to your Google drive and deploy the project as an web app to use it. You also can clone this project to your local directory and deploy it with clasp.
Google Sheet
- Custom form
- Sequential registration number
- Input validation
- Dynamic confirmation message
- Error message
- Valid form in a time frame
- Max responses
- Max responses
const _max_responses = 1500 // max reseponses allowed
- Form valid from
start: new Date(2020, 6, 22, 6), // 27 Jul 2020, 6 am
- Form invalid from
end: new Date(2020, 6, 31, 13), // 31 Jul 2020, 1.00 pm
- Form App
- Form responses and form reset in the spreadsheet
- Form validation
- Confirmation message
More videos about Google Apps Script