I have InfoPath form which has fields:
Quiz completed: check box
I want to add timestamp workflow to see how long did it take for one to finish the quiz. How do i create one?
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
Follow below steps as a solution for your requirements:
Add one more date & time field in your sharepoint list
Quiz completion Date.
Add one calculated field to calculate the time taken to complete the quiz. Use formula something like this(you can check other formatting to show the time difference in 1st link given in sources below):
=IF(ISBLANK([Quiz completion Date])," ",TEXT([Quiz completion Date]-[Start Date],"d"))
Add workflow on your list with triggering condition as
on item changed(considering quiz completion date will be entered by editing list item).
In workflow at the starting check if the Quiz completion Date is empty or not.
If it is empty then complete the workflow. If it is not empty then add send an email action.