Skip to main content
Nintex Community Menu Bar

Require Comments on Status Change - Nintex Forms

  • October 31, 2019
  • 5 replies
  • 23 views

cjwilson1009
Forum|alt.badge.img+4

I have a Nintex Form that has a 'Status' drop-down field. ANY TIME the status of the form changes, I want the user to be required to enter comments, either new, or additional comments. So, even if the status of the form is 'Closed,' and someone re-opens the form and changes the status to 'Open,' I want comments, and if they go back in and mark it 'Closed' again, I want coments required too. So, regardless of what the status is, anytime it changes, I need comments required. 

 

Is there a way to do this??

 

 

5 replies

Forum|alt.badge.img+12
  • Scholar
  • November 1, 2019

@cjwilson1009 .....Is your comment field connected to a SharePoint column? If so, then just make that comment column a required field.


cjwilson1009
Forum|alt.badge.img+4

@kunalpatel wrote:

@cjwilson1009 .....Is your comment field connected to a SharePoint column? If so, then just make that comment column a required field.


@kunalpatel Yes, it's already connected and is required, the issue I'm trying to solve is to make new comments required each time the status of the form changes. So, it would make it re-required. Make sense?

Forum|alt.badge.img+12
  • Scholar
  • November 1, 2019

@cjwilson1009 .....then try below options:

 

  • Option 1: What about enabling versioning and select append changes for comment column? This will reset the comment field blank and display previous values below and since it's required it will force the users to fill the comment field.
  • Option 2: (This is option 1 only but without enabling versioning)
    • On the form you will need 2 MLT controls and 2 list columns:
      • CommentForm - Where users will write the comments. Connect it to list column. Apply validation rule "isnullorempty()"
      • PreviousComments - Make sure the control mode is set to display and it's connected to list columns.
    • Now when users modify the item, the workflow will run and it will grab the value from CommentForm and will appen to PreviousComments. Build string will have {w/fvariable:CommentForm}{ItemProperty:PreviousComments}

cjwilson1009
Forum|alt.badge.img+4

@kunalpatel 

 

I have the field set to append changes so that each time the form is edited, the comments box is once again free of text. However, I have a new problem. Only members of a certain group are allowed to view this panel, which is working. However, now that I have made the comments required, it's making comments required for everyone, even users not in the Owners group. How can I make it so that comments are required only if you're a member of the owners group? I've attached a new screen shot for reference. Again, the panel is already locked down to the Owners group, but now I need to do the same for the comments box, plus, make it required only for the Owners members... thoughts?

 


Forum|alt.badge.img+12
  • Scholar
  • November 5, 2019

@cjwilson1009 ......You cannot make column required in list settings if it's not required for every contributors. Instead try this:

 

  • Add a calculated control (ctrl_calc_checkuser) and hide it always (use formatting rule to hide using 1<2 condition) and in the function use fn-isMemberOfGroup("SP Group required to add comments")
  • Above function gives boolean value i.e. true or false
  • Put your Comment control in a panel and apply validation rule i.e. ctrl_calc_checkuser != false
  • In the message just say "Please provide comments."