App Script/Help needed to populate data from Sheets to Form

[Aqil Nokman]

Hi all,

I have a google form. One of the questions is to fill-in an enquiry number, which is a running number in a google sheet. I need the enquiry number to be automatically filled in the google form. Appreciate if anyone can help me with the app script required.

Thank you.

[Peter Berkhout]

Maybe you can find your answer here: https://www.youtube.com/watch?v=ZKYvrD-3Ksc

Op maandag 24 juli 2023 om 05:52:13 UTC+2 schreef aqiln...@gmail.com:

[cwl...@gmail.com]

How are you identifying the person filling out the form? Do they fill in their name? Or is the number generated before a form is even filled out for the first time? If it were me, I would create the a unique number (instead of a running number) and add it when the form is generated. Then just add this number to the sheet when the form is submitted.
Otherwise, you will probably have to use a webapp and create your own html form, or do like in the video above.