Add a timestamp for each answer of a Google Form in their adjacent cell in the spreadsheet

Nadine picture Nadine · Dec 4, 2014 · Viewed 12.3k times · Source

I've seen various related answers to my question but none that actually answers it. I've tried different things so I hope anyone is able to help!

I have a Google Form with multiple pages that each contain one question. In addition to the final time stamp that appears on the form (which is standard) I'd like to measure the time it took to answer each question. I've found some solutions that add the time stamp when a cell is filled out (such as How to automatically add a timestamp in google spreadsheet and Automatic timestamp when a cell is filled out) but I believe the answers from the form are not stored in the spreadsheet until all answers are provided.

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

Thanks.

Nadine

Answer

user7545009 picture user7545009 · Feb 10, 2017

This is possible, but you would have to use multiple forms.

Google forms are static and can't be edited or altered with script during a session (user opening a form until they submit it). You can't pull out values that a user has entered into a form until they have submitted it.

As a result you could have an initial form which collects all the values which would influence subsequent forms, then use a script to take the results and create a new form, (e.g. with 12 fields for the 12 provisioned users in your initial example) and then email a link to this form to your end user.