Timestamp that updates only when a certain field is changed.

michael-hagen

Hello,

We are making a configuration that will timestamp when a certain field is changed (this will help with some of our processes and create a queue of work items in the order of oldest to most recent). So far, we have it where it will update when the targeted field is update (ReviewField). But, it will blank itself out if any other field is updated. How can we prevent it from updating if it is not changed? The current derived field configuration is below.

Item is a BusinessClass

    owned by ic

    Derived Fields

        ReviewTimestamp is a DerivedField

            type is TimeStamp

            if (ReviewField changed)

                ReviewTimestamp = update stamp.timestamp

michael-hagen

This has been solved by creating a stored field that is hidden from the forms and lists called "ReviewStored". Then we created a user action called "ReviewChange". Once those two configurations were made, we created a derived field called "ReviewTimestamp" that invokes the ReviewChange action when the targeted field has a change (ReviewField). In the action, we put constraints so that you can't enter any other date other than current date. In the derived field, we make the parameter in the action equal to the current date. The action will send to the ReviewStored field and then the derived field will return what is in the ReviewStored field. If the ReviewField is not changed, then it will simply return what is in the ReviewStored field. If the last piece isn't added, it will blank the timestamp field everytime. The LPL configurations are below.

ReviewStored

Item is a BusinessClass

    owned by ic

    Persistent Fields

        ReviewStored is Date

ReviewChange

ReviewChange is an Instance Action

    Parameters

        ChangeValue             is Date

    Parameter Rules

        ChangeValue

            constraint (ChangeValue = current date)

                "MustBeToday"

            required

    Action Rules

        ReviewStored = ChangeValue

ReviewTimestamp

Item is a BusinessClass

    owned by ic

    Derived Fields

        ReviewTimestamp is a DerivedField

            type is Date

            if (ReviewField changed)

                invoke ReviewChange

                    invoked.ChangeValue = current date

                return ReviewStored

            else

                return ReviewStored