Skip to main content
Nintex Community Menu Bar

Button validation based on SP group and Sp column value

  • November 8, 2019
  • 3 replies
  • 19 views
Forum|alt.badge.img+1

Hi all,

I´m struggling since hours to implement a requirement in a Nintex form:

 

The goal is to show or hide the save button based on a group membership within a multi step  approval workflow. 

E.g:

The "creater" group should see the save button, if they create a request. If they have created the request and saved, the "Approver" group should check the formular, but in this  time the create group should not be able to change the formular and therefor I want to hide the save button.

This is what I have implemented at the save buttons as an expression:

 

fn-IsMemberOfGroup("Creater") && Is New Mode or  fn-IsMemberOfGroup("Approver") && CurrentResponsibleSharePointGroup == Approver

 

It seems, that even the first part does not work and I don´t know why. Any ideas?

 

 

    3 replies

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

    @Palim ....try this logic or(and(c1, c2), and(c1, c2)).

     

    In first "and" condition check if the form is in edit mode and current user is in Creater group.

     

    In second "and" condition check if the form is in new mode and current user is in Approver group.

     

    Use this formula in formatting rule on the submit button and disable the button.

     

    Or else, you can create the custom permission level in SharePoint which will allow only to create new item & view item and grant it to Creater group.

    Forum|alt.badge.img+1
    • Palim
    • Author
    • November 11, 2019

    Hi @kunalpatel, 

     

    thanks for your support.

    If I impelment your logic ("or(and(c1, c2), and(c1, c2))")  it looks like this, but still dosent work:

     

    or not(and(fn-IsMemberOfGroup("Creater"), Is New Mode), and((fn-IsMemberOfGroup("Approver"), CurrentResponsibleSharePointGroup==Approver))

     

    Do you mabybe know why?

     

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

    @Palim .....Copy the below formula in red and put it in calculated control and check the results. I've tested on my end and it's giving me true when the form is in edit mode and it's giving me false when I open the form in new mode or display mode. I'm in the Approver group.

     

    "or(and(fn-IsMemberOfGroup("Approver"), Is Edit Mode), and(fn-IsMemberOfGroup("Creater"), Is New Mode))"

     

    Also, put button in a panel and apply rule on the panel and not on the button.

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement