Display custom message after submitting a Google F

Question

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 1

In order to achieve the above-mentioned goal, you need to get the Google form on your web page. No, I am not talking about embedding the form to your web page but to create a stand alone HTML page. The reason behind doing so is since Google is a third party website, editing any code in Google forms is not possible and there is no other way (at least I could not figure out Yet) to place custom thank you page URL for the Google Form. You can even remove certain codes in your HTML page to make sure it doesn't look like or says Google form. Basically, to have custom URL you need to replace

Code to be replaced for custom Thank you url in Google form

In case you are not a techie, Playing with codes might break the code.This step by step blog for customising Google form might help you.

Answer 2

Google just released a new version of Google Forms. In the settings you can change the confirmation page message for respondents. You can save a link to a web page in the custom message. So if you can create a web page with the data you want displayed, you should be able to save the link in the custom message.

Answer 3

There is no way to add dynamic data to the custom confirmation message after submitting a Google Form. You can change the message in the the confirmation page, but you can't retrieve and concatenate anything into that confirmation message.

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