Google-sheets – How to get a unique ID when I submitted an answer in Google Form

google sheetsgoogle-forms

I am using Google Form for my customers to submit their opinion. I read this and this, but I have some questions which these two posts haven't mentioned.

Is it possible for my customers to know their submission ID when they see the confirmation page?

E.G.:

Thanks for your response. Your reference no. is #S201501. We will contact you within 7 days.

The second customer will have #S201502… etc.

Can I also check the reference no. in my original spreadsheet?

Best Answer

There is no way to dynamically change the confirmation/thank you message. However, you could use the Autocrat add-on (or adapt its code) to send your customers a confirmation email with the reference number.

Related Solutions

Google Forms – How to Enable Duplicating Questions by User

Something I have done to accomplish this(sort of) is to make a certain number of identical questions. It could be 5 or 10 or whatever you see the max number being. Then I add a question at the end of each of those that asks if the person would like to add another.

So, in your case, you would have Book 1, Book 2, and Book 3. All are separate sections in the form. The person fills out Book 1 recommendation and says yes to adding another. They get routed to Book 2 section. They only have 2 recommendations so they answer no to adding another. They then get routed to the final section in the form which just contains a submit button.

I wish the ability to just add another question like you are asking for existed but until Google adds something like that, this should get the job done for you.

Google Sheets: Sum Row Without Overwriting Formula When Google Forms Adds New Row

Please try:

=ArrayFormula(G2:G+H2:H+I2:I+J2:J)

Best Answer

Related Solutions

Google Forms – How to Enable Duplicating Questions by User

Google Sheets: Sum Row Without Overwriting Formula When Google Forms Adds New Row

Related Topic