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?


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.