This is a free template that allows you to have your guests use an “Apps Script” as a form that directly edits your google sheets file. Once a guest has changed from “Pending” to “Accepts” or “Declines”, it will not allow them to resubmit.
This should be done at the invitation stage, you should have the final guest list and the dinner options finalized before starting
https://docs.google.com/spreadsheets/d/1KKtFtAgfIcSsXSHXeq-pf676w3DRmWgVLNXyF4tBv3I/edit?usp=sharing
Duplicate the file above
Paste in your finalized guest list from the format below
Use google gemini to make any edits to the form like dinner option, color, headings/subheading copy, and images. I recommend asking gemini to return the full code back with all the edits in one complete file you can copy and paste, not tell you what edits to make.
Index.html
In the google sheets file that you have saved into your own location, go to “Extensions” and click on “Apps Script”
The code above should already be present
Next to the “Debug: button at the top of the code, there should be a dropdown with the option of “setup”. Click “Setup”, and then “Run”
Click “Deploy” and “Test Deployment”
This will give you the current view of the code, using John Doe to test, walk yourself through the process and make a list of edits to ask Google Gemini
Once you feel confident about the test deployment, you can deploy the live link!
Click “Deploy” and “New Deployment”