Add a timestamp for each Google form response in the adjacent cell in the spreadsheet.

Question

I saw various answers to my question, but no one actually answers it. I tried different things, so I hope someone can help!

I have a Google form with several pages, each of which contains one question. In addition to the last time stamp that appears on the form (which is standard), I would like to determine the time required to answer each question. I found some solutions that add a timestamp when filling out a cell (for example, How to automatically add a timestamp in a Google spreadsheet and Automatic timestamp when a cell is full ), but I believe that the answers from the form are not saved in the spreadsheet until until all answers are provided.

So, I was wondering if anyone knows if it is possible in a script to create a current-time variable after each question on the form and subsequently show it in a spreadsheet after it is submitted?

Thanks.

Nadine

Answer 1

It is possible, but you will have to use several forms.

Google forms are static and cannot be changed or modified using a script during a session (the user opens the form before submitting it). You cannot pull out the values ​​that the user entered into the form before they submitted it.

As a result, you can have an initial form that collects all the values ​​that affect subsequent forms, and then use a script to get the results and create a new form (for example, with 12 fields for 12 secured users in your original example), and then send the link on this form to your end user.