Skip to main content
Nintex Community Menu Bar

Nintex Workflow Status Column In Document Library?

  • February 15, 2017
  • 8 replies
  • 30 views

Forum|alt.badge.img+5

Hi Everyone

I've created an approval request workflow that works fine.  The workflow adds the default "status" column in the document library that includes "In Progress" and "Completed".  I'd like to add a column that contains the overall approval status of a workflow; either "Approved" or "Rejected".  I can do this manually with a SharePoint column and set the column programmatically from the workflow.  However the user can change this value in the document library.  I would like the column data to come from Nintex so that the user cannot change the value (say for example if the document is rejected and they just Edit Properties and change it to "Approved").

Can I do this?
Andy

8 replies

Forum|alt.badge.img+12
  • Nintex Partner
  • February 15, 2017

SharePoint is not able to have column-level-security which would be great here. Did you try the set workflow status action though? It allows you to set a custom workflow status that can't be manipulated from the user.

198950_pastedImage_1.png

Would that help?

Kind regards,

Enrico


Forum|alt.badge.img+5
  • Author
  • February 15, 2017

Thanks Enrico, I saw that but was unsure what it actually updates.  If you set the workflow status to approved with this Action where does it actually show.  Where does the user see this?


Forum|alt.badge.img+9
  • February 15, 2017

In the workflow status column.  So instead of having it say "Completed", you could add the Set Workflow status as the last action in your workflow, and have it changed to be "Approved". 


Forum|alt.badge.img
  • February 15, 2017

It is possible to use the set workflow status column as Enrico mentioned, but I generally use the column in a list option because after 60 days values stored in the workflow status column get automatically trimmed by SharePoint (so will be an empty column). With version history enabled, you will be able to see if a user edited their own approval column, so the risk is low to leave it in place. If you really need the value to not be editible, you might consider saving the approval in a separate list. Be sure to share the list id of the item that was approved in that secondary list, as this could be used later to produce some semi-automated reporting.


Forum|alt.badge.img+5
  • Author
  • February 15, 2017

Brendan, Enrico

Perfect, thanks!  That is exactly what I was looking for.  I just tested it and it is what I need.  happy.png


Forum|alt.badge.img+12
  • Nintex Partner
  • February 15, 2017

Whatever you write into the action will overwrite the default workflow status column value:

198951_pastedImage_1.png

My 3rd element says "Abgeschlossen" which is default completed status in German. The last one is set by using the action.


Forum|alt.badge.img
  • February 15, 2017

If you use this column to hold data. Keep in mind that the value will disappear after 60 days because of SharePoint workflow retention settings.


Forum|alt.badge.img+5
  • Author
  • February 16, 2017

Interesting Jeremy.  I didn't realize that the column data would be cleared out after 60 days.  Not good.  Thanks for the tip!  I'm thinking now that I need to create a new document library with restricted permissions called Approved Documents or something to that affect.  Once the document is sent for approval and finally approved, I'll have Nintex move the document to the restricted permissions library.