nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Form Started Timestamp

virgh

Hi Smartsheet,

One of our project managers is using a Smartsheet Form for an exam. We want to record the time the student opens the form so we can tell how many minutes they have spent to answer the exam. We want that time to be recorded on the row in the sheet. Thanks!

Sign in to vote!

Find more posts tagged with

Idea Submitted

#form #timestamp

Comments

Andrée Starå

https://community.smartsheet.com/discussion/141340/form-started-timestamp

Hi,

I hope you're well and safe!

Do you have access to Dynamic View? You could have the first step being that they "Start" the process.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

virgh

Hi Andree,

The students are just opening the Form on their computer, we did not give each student a dynamic view of their own.

We would prefer a computer timestamp that would be too difficult to fake, it's a certification exam and we are trying our best to prevent any chance of user error.

In the Dynamic View would they just be recording the time they started the exam, or am I misunderstanding your advice?

Thanks! 😊

Andrée Starå

https://community.smartsheet.com/discussion/comment/490901#Comment_490901

Happy to help!

You would "Probably" only need one Dynamic View, and the first step to get access to the form would be to check a box or similar, save, and that would register the time and then show the form to the student.

Make sense?

Would that work/help?

✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

virgh

Thanks, that is an interesting idea. I will share that with my PM and see if that will work.

Andrée Starå

https://community.smartsheet.com/discussion/comment/490904#Comment_490904

Excellent!

You're more than welcome!

✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

Quick Links

Trending ideas

Notifications for Pivot Errors
Smartsheet does not currently send automated error notifications to Pivot workflow owners when workflows fail, unlike the notification behavior for DataTables, Data Shuttle, and Meshes. Also, when column mappings break on a mesh, the mesh will continue to run with an error. We should expect the same functionality from a…
File Attachments part of Smartsheet Forms Notification Email
The Smartsheet Forms currently do not include the attachments in the notification emails as soon as the form has been submitted. Therefore, the Approver and the End Receiver are not able to see the attachments instantly and will have to go to the link to access the table and download from there. We use the Smartsheet Forms…
Cancel Update Request Without Deleting It
I'm proposing an added feature to CANCEL an update request without necessarily deleting it, this way we can maintain the history of requests even when they aren't acted upon by the recipient. Sometimes users elect to update rows in grid view rather than from their emails/notifications, or they'll respond to the 20th update…