Skip to main content

Hola guys happy.png 

 

Bitmoji Image

 

.

Author Palesa Sikwane
Long Description

This is a little workaround that can assist you providing a user friendly way of keeping track of an items version history while keeping your Workflow History list data to a minimum on your site.

Dependencies

SharePoint ®️ On Premise or SharePoint ®️ Online

Versioning Enabled on the List/Document Library

Compatibility

Nintex Workflow ®️ Office 365 ®️

Nintex Forms ®️ for Office 365 ®️

Nintex Workflow ®️ On Premise

Nintex Forms ®️ On Premise

Platform

SharePoint®️ On Premise (2010, 2013 or 2016)

Office 365 ®️

Useful Reads

You can read my previous posts to get more information about my Timesheet scenario:

 

 


9991cb4e-1363-4d24-8af8-b9301a2a9b00-594a5a7e-4cfe-4126-9806-288b095bce10-v1.png?transparent=1&palette=1

 

Video

Check out the video below(Enjoy silly.png):

 

 

Summary/Requirement Overview

Ever wondered how you can present a forms version history in a user friendly format without having to rely on the Nintex Workflow®️ History List?

 

The Nintex Workflow®️ History List is great, and it automatically logs workflow instance data and allows you to choose which information to log, however seen that its a list it is subject to some of the following SharePoint®️ List Limitations:

 

 

Just to clarify by "version history" I am referring to things such as:

 

  • The task approval outcomes as well as comments
  • Changes to the item, e.g. Status/value changes etc
  • Anything that you would like to track in your process as per your governance compliance requirementshappy.png 

 

This technique also demonstrates how you can use some of the OOTB (Out of the box) SharePoint ®️ features together with Nintex Workflow ®️ and Nintex Forms ®️ to create a friendly end user experience, whilst working around about some of the known limitations and thresholds within SharePoint®️ that our "hidden" Nintex ®️ Workflow History List inherits as it is a list after all.

 

However, please note that this workaround should be used with some of the best practices hightlighted by Aaron Labiosa‌ in his defensive design series; particularly around Defensive Workflow Design Part 1 - Workflow History Lists

  The Solution

The proposed solution will consist of the following technologies:

  • SharePoint ®️ (on premise or Online)
  • Nintex Workflow ®️
  • Nintex Forms ®️

The solution allows you to present workflow history information on an item in a friendly format, and there are a couple of advantages to this:

 

  • Reducing the number of items in your Nintex Workflow ®️ history list as you can now purge your workflow history list  data will now be stored in a Multiple lines of text column on your list. This means you can purge your workflow history list on a regular basis and make it easier to maintain.
  • Allowing users to now view workflow history on any item in an easy to understand format or perhaps meet some auditing requirements in your organisation.
  • Having an combination of a Users Full Name & Date Time incorporated with each comment.
  • Avoid complex workarounds to achieve this but rather use a combination of OOTB SharePoint ®️ features and Nintex ®️.
  • This technique works with Nintex ®️  LazyApproval

  Configuration

 

The following steps need to be configured to get this working:

 

 

# Title/Description Screenshot(s) Resources

1.

On your desired site go to Site Settings ->  Site Columns -> Create

 

Create a Multiple lines of Text site column called "WorkflowHistory".  The column would have to have the following configuration enabled:

 

  • Enhanced rich text (Rich text with pictures, tables, and hyperlinks) set to Yes
  • Append Changes to Existing Text set to Yes
    • Click OK, then edit the column again and rename it to "Workflow History" (this is standard SharePoint Best Practice on column naming which makes it easier to reference columns programmatically - should the need arise)

Note:

Reason why I created this as a site column is because it can be reused by multiple lists and libraries within and a site and its subsites.

 

Secondly doing this allows me to centralize the configuration of my column in one place, which makes it easier for me to update the settings for this column - should the need arise.

221893_pastedImage_4.png

 

221897_pastedImage_5.png

 

221898_pastedImage_12.png

Avoiding SharePoint Internal Name Pain

 

SharePoint Column Names: Internal name mappings for non alphabet.

2.

Enable versioning on your desired list by going to List Settings -> Versioning settings->Create a version each time you edit an item in this list set to Yes

221899_pastedImage_2.png Plan document versioning, content approval, and check-out controls in SharePointServer
3. Add this column to your existing  Content Type or List N/A

Create a column in a SharePoint list or library

 

Add columns to a content type

4.

Open your Nintex Forms®️ Designer and add your column to your form.

 

Note:

In my case I added my column to my form and set up a tab to provide a friendly experience

221900_pastedImage_1.png

 

221901_pastedImage_2.png

Create Tab like functionality on your Nintex Forms by Vadim Tabakman
5.

Update your desired workflow to update the column with the information you need to log.

 

In my case I use the Update Item action to push updates to my Timesheet, and the beauty of this is the previous changes are retained as I take advantage of the "Append Changes to Existing Text" SharePoint feature. And because this is already not a limited action workflow and it has already been built using best practices,  I really don't have to worry too much about having a few additional steps to help me build a workflow history tracking into my item grin.png - the value add of this in my opinion is justified.

221902_pastedImage_241.png

 

221903_pastedImage_242.png

 

221904_pastedImage_243.png

N/A

 

 

 

And thats it!!!

 

I hope this helps someone out there grin.png 

 

Feel free to add comments and ask any questions if you have any!!

 

Salang hantle!

Bitmoji Image

Hey guys for office 365, this would work slightly differently can be done using a component workflow i've done a blog post here: https://community.nintex.com/t5/Community-Blogs/Using-a-Component-workflow-to-track-the-history-of-an-item/ba-p/88782 as well as provided the workflow for download.

 

Cheers!


Hey Palesa,



 



Thank you for taking the time to make this post! This is excellent and helped me to learn a number of new tricks but I was curious about one thing. In your video, you click the hyperlink to "View Entries..." and you are able to switch the panel with the workflow history on it without actually editing the properties of the item. When I click it, the button is greyed out and I am unable to select my workflow history tab. Am I missing a setting that would allow this? Thank you so much!



 



Carl


I figured it out. You need to switch the control mode for the buttons from "Auto" to "Edit" and that way you are always able to click them.


I have another question...how is that you were able to get every new addition to the workflow history log to start on it's own line? Mine comes out looking like the below. 



 





 


Hi Pilesa,



I need this function to append changes to a column in a library. Sharepoint doesn't provide the "Append changes to text"- function in a library - only in lists. Do you have an idea to append a text (with time stamp) to a column in a libray? Thank you very much in advance...


Reply