Property Calculator - Comments captured through the workflow

Hoping someone can help with a solution to capture comments as the occur through the workflow, date - user - comment

The scenario is we'd like to capture the comments as each user approves their part of the workflow, building out the following autovalue properties for each workflow state will produce the correct result providing the user enters the comment when prompted, as they change the workflow state.

The issue is, If the user adds a comment and saves, this comment is on a previous version, when a user then changes the workflow state there is no need to add further comment, the result means the comment placeholder is now blank. 

Parents Reply Children
  • Thanks Patrick, a very similar scenario.

    By using the condition type 'changed property value' and then adding a secondary condition of comment not being empty, I am able to write all comments into a multi text property without issue.

    I setup a property transition timestamp, and within the workflow used set the property to update the transition time. Then using property calculator I used the convert date function to changed the transition date to text. The reason for this is because if I use the Timestamp property within expression, the format is the wrong region.

    I'm confident I can get a multitext with only the comments and the time they occurred, the missing piece is getting the user name who completed the transition. 

  • Hi,

    Easiest way to pick user information is to do it during the state transition. You can save information from "Last Modified by" property:

    This should let you collect user to user lookup or to text property.

    If you have separate Employee/Person objects in vault, you can pick that object instead by using search.

    Here we pick employee / person, which "m-files user" property is same as last modified by user. I would suggest this option because it gives you more properties and options.

    Similarly, it is possible to read time stamp from "Last Modified" property, if you do not want to store it in separate "Transition timestamp" property.

    Note that I created these configurations to demonstrate options. I haven't tried them out. Please test them carefully if you end up using similar logic.