Form start timestamp

Jim Rood

I've created a web form that will be heavily utilized. Managers are wanting to conduct a transactional analysis to see how long it takes the worker to complete. I'm looking for a way to capture the current time either when the form was accessed or find a shortcut to copy from the operating system and paste into the first visible field in the form. While O365 products have a hot key combination, it appears Windows 10 does not saying it relies on applications to provide that capacity. Any help would be appreciated.

Andrée Starå

Hi @Jim Rood

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jim Rood

Thanks Andrée for your response. In this instance, your solution wouldn't be practical because it would require an equal amount of effort by the end user as using an O365 hot key and pasting the result into the Smartsheet form field but require a significant amount of effort on the backend to reconcile and calculate.

Andrée Starå

@Jim Rood

Happy to help!

If I understand your need, it would only require the time for setting it up, and then it would be automatic.

Why wouldn't it work?