Time to complete for each respondent

@Diego - from another user here.. 

the only thing i have been able to see in Google Sheets connection data push is the submit time. not the start or completion time

des

then, at the moment, it looks like you will need to download the response data from the dashboard and, if necessary, port it into a Google sheet/tab to be able to link to your survey data. 

hopefully, since it is something that is recorded into the results inside Typeform, that we can request it be put on the product drawing board to have it incorporated into the Connect capability. 

@Liz @Mariana - can we have this added to the product enhancement list please, if it is not already there?? 

ie the ability to obtain the start date/time, as well as the submit data/time as @vickioneill has mentioned above, that is available in the results section of the typeform

thanks

des

@ValdemarQ - what i had to do for a client is split form into two separate sections/typeforms and push the data from both to a google sheet. I could then capture the timestamp of the submissions, and subtract the first from the second to get the duration. Works for my client this way

des

@ValdemarQ - what i do is have the user put in name and email in the first form and redirect on submission is set (the submit button text has been changed to “start the quiz now”

i connect that quiz to a google sheet. when the response is submitted i have the ‘time they started the quiz’ that is to be measured. 

the second form is connected to the same google sheet but sends data to a different tab. 

both have timestamps

i create a third tab for reporting and use the email address as the lookup value to pull data from both of the other tabs into the reporting tab… then i take the timestamp of the quiz submission and subtract the time of email/name submission form to get the duration. It is not Olympic timing accurate but is close enough for the needs of the client. 

the start time of loading a form is often irrelevant and impossible to accurately capture - ie i can load the quiz to my desktop, go get a coffee or a bio break, then start doing the responses. what is the appropriate start time?

I am currently working on a version of the client quiz that has 5 timed components in the entire quiz and we have 6 forms in the sequence.. it works

des

Right, if someone is still looking, how we are handling currently this issue.

We have created Hidden field start_time
and once users click on the link top open typeform, we simply add it to url
 

'start_time='+new Date().toISOString();

Though, given Typeform does store in Typeform logs start and end times, it should definitely export the start time, so users have less trouble. I believe this is probably due to this feature is available to premium users only, but if you have a premium plan, why is it not exporting start times? 

Hi @monalisharma happy Monday! I’ve moved your post here where we have an existing conversation about this. 😀

Hi @ReneNL I don’t believe there are any updates to this feature, but I will check with the product team and get back to you 😊