I want to be able to take live notes during a video recording, and then be able to go back into the recording and find things easily.
More specifically, imagine a user:
Opens empty table
Types text into record 1, time is noted in adjacent cell as ...
It would appear that the ‘Date’ field does not record seconds.Here’s why I think this:Here are the formulas I’m using to expose this:DATETIME_FORMAT({Date (no secs?)}, ‘DD-MM-YYYY h:mm:ss’)DATETIME_FORMAT({Created Time}, ‘DD-MM-YYYY h:mm:ss’)I hope I...
It would appear that the ‘Date’ field does not record seconds.
Here’s why I think this:
Here are the formulas I’m using to expose this:
DATETIME_FORMAT({Date (no secs?)}, ‘DD-MM-YYYY h:mm:ss’)
DATETIME_FORMAT({Created Time}, ‘DD-MM-YYYY h:mm:ss’)
I ...
Thank you for the reply. The issue I’m experiencing is that the Timestamp field starts with seconds from the system time, not 0. This throws the timestamp off by however many seconds after 0 the current system time is.
That is an awesome trick, and it works! Now the issue is that the first record creates a timestamp of the actual clock time, not :00.
Here’s the formula I’m using:
DATETIME_DIFF(LAST_MODIFIED_TIME(),{Actual Start Time},‘seconds’)
I made a video of th...
@ScottWorld, I tried it out, and it works! Thanks!
@kuovonne Now I need to figure out a way to make it less manual as you mentioned. Currently I have to copy the Actual_Start_Time to each record one by one, otherwise they all get the same timestamp.
...
Thanks @kuovonne and @ScottWorld – those are great solutions. I’ll probably just calculate the elapsed time. So simple!
I just wish the ‘Date’ field recorded seconds – that’s what I was trying to use as my “Actual_Start_Time.”
