I have a Google form that allows the user to enter their information. After submitting the form, the data will be added to the Google spreadsheet as a new line.
However, I want to show a dynamic message immediately after submitting the form, overriding the original thank you message. The new message will display the information they just filled in with the number assigned to it.
For example, Mary filled in her details and submitted a form. Since Mary is the fifth person to submit this form, the message shows her number as 5.
Is there any way to achieve this? I have studied the Google App Script app and HTML, but I'm not sure if this is the right way.
Please note that we already use e-mail to send this message for several years, but the user strongly suggests that showing their identifier immediately after submitting the form will greatly facilitate a lot.
Many thanks!
Update
I am working on this and now I can create a webpage that inserts a new row into a spreadsheet. But another question: how to publish a web page? When I open the "/ dev" link, it works fine; However, when I open the "/ exec" link, it says that it cannot find "Index.html", and I'm sure there is an Index.html file.
source
share