How can I see 'seconds' in Timestamp?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Our company has a form that it uses to review products (its basically a checklist of things to look for).  They open a new review, go through the checklist for that particular product and then hit save.  A timestamp is created each time a reviewer completes a review, however, we wanted to be able to track their productivity and the best way to do this was to time from when they started the review to when they completed the review. 

Our solution:
Our form currently provides a time stamp of when the Reviewer selects a product ID, making it the start time.It then provides a time stamp of when the Reviewer goes through the checklist and hits save, i.e. this would be the end time.

The problem is not being able to capture the “seconds” in the time stamp for the start time, it only provides Hour and Minute of start time ....Also tried adding a duration calculation, however, the calc goes off of the rounded time figure as well.  Looking for a way to either: Add the seconds to the Start time or Fix the duration calculation to provide duration between start time and end time that includes the seconds.




Photo of Ezequiel

Ezequiel

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
Time/Date field do not appear to preserve seconds when entered into the control on a form. Try it yourself with these two entries:

8/12/15 3:04:05
8/12/15 3:04:55

You should note that QuickBase only displays 8/12/15 3:0 AM for both cases. The internal representation likewise appears to be truncated as you can see from using ?act=API_DoQuery:

<qdbapi>
  <action>API_DoQuery</action>
  <errcode>0</errcode>
  <errtext>No error</errtext>
  <dbinfo>
    <name>aa</name>
    <desc/>
  </dbinfo>
  <variables></variables>
  <chdbids></chdbids>
  <record>
    <ts>1439370240000</ts>
    <update_id>1439373442942</update_id>
  </record>
  <record>
    <ts>1439370240000</ts>
    <update_id>1439373453784</update_id>
  </record>
</qdbapi>

So if you want to track the time a form is open I would suggest you use the image onload technique and some JavaScript to capture the start and end times and capture the difference into an appropriate filed that will allow you to display the time between start and end in seconds. Another reason to do this in JavaScript is to conceal the fact that your are tracking the user's productivity down to the second.