Display custom message after submitting a Google Form

user3545752 picture user3545752 · Jul 27, 2015 · Viewed 42.5k times · Source

I have a Google Form that allows user to enter their information. After they submit the form, the data is inserted to a Google spreadsheet as a new row.

However I want to show a dynamic message right after the form is submitted, overriding the original "thank you" message. The new message would display the information they just filled in, with an number assigned to him.

For example, Mary filled in her data and submit the form. Since Mary is the 5th person to submit this form, the message shows her number as 5.

Is there any way to achieve this? I have been studying Google App Script and HTML service but I am not sure if this is the correct way.

Please note that we have already using email to send out this message for several years however user strongly suggest that showing their ID right after form submission would make lots of things much easier.

Thank you very much!

Update

I have been working on it and now I am able to make a web page that inserts a new row to a spreadsheet. But another question: How to publish the web page? When I open the "/dev" link it works fine; However when I open the "/exec" link it says cannot find "Index.html" and I am sure there is a file called Index.html.

Answer

Alan Wells picture Alan Wells · Jul 27, 2015

There is no way to add a custom confirmation message for the current user of the currently open Form. You can run code to change the confirmation message when the Form is submitted, but changing the confirmation message when the Form is submitted won't take affect until the NEXT Form is opened, and that's too late. So the next person to open the Form would get the confirmation message of the previous user.

You would need to convert everything to a stand alone HTML App for something like that.