I have a form that has changed a field value along the way through the process. Of course, the party who it appears changed it denies doing it. Is there a way to track changes to fields other the form submitted at each step?
I have a form that has changed a field value along the way through the process. Of course, the party who it appears changed it denies doing it. Is there a way to track changes to fields other the form submitted at each step?
Not out-of-the-box. You can use the info on this post to check the last person who modified the values: https://answers.laserfiche.com/questions/116789/Last-Person-to-Edit-Forms
You can also take that one step further and add triggers based on those database updates if you want to keep a running audit log. However, this won't help for something that happened in the past.
The best way to check for your case would be to go into the action history and open up each form submission to see what each variable was set to when the form was submitted. That will show who submitted the form and what the values were set to. You can use the previous submission to have a good guess at what the variable was before that user's task, and then use that submission to see what it was after their submission.
As a follow-up that won't help the current situation, you might consider making fields read-only in the future. Like, they need to be filled in on the initial form, but at later steps in the process make them read only. This can be done on individual fields, which is a pain if there are a lot of them, or by putting in Section separators since you can make a whole section read-only. Note that even if you don't have any sections in place currently, you can add one in and check the box to hide the section label, so it's there but not visible on the form people see. Just remember to add another section at the end of where things should be read-only.