This feature can be added to any Flex List, including Custom lists.
Once setup this feature automatic logs the value (including the date of the change) to another column when the field value is changed. An example would be when an item is changed from “Active” to “Inactive” or an Account Manager changes and you want to keep track of the history of Account Managers for each Account.
Configuring
This is a simple 3 step setup as described below.
- Add a “Multiple lines of text” column for the field that will contain the previous value (in this example we are using Previous Status).
- Add the new column to the Display web part which should contain the previous value (in this example we are using “Previous Status”. (Refer to the “Form Editing” section for instructions.)
- Add the Advanced Flex Setting as follows (or if present add only the Value using the syntax as shown in the example below):
Setting Name: SavePreviousValues
Setting Value: [listname]|[Column Field to check]|[Column Field to save previous value to]|[True/False to retain history]
The structure for the Setting value first reads the List Name and then the field that contains the values which, when changed, will copy to the second field as “List Name | Original Column | New Column | Track all Previous Values or Only Most Recent (True/False)”.
The True/False value is applied to manage whether all previous items are stored. For example, if you only wish to keep the last value then apply the “False” statement but if you would like to keep track of all previous values use the “True” statement. See screen shots below:
When set to False you will see only the previous value:
When set to True you will see all previous values: