Skip to main content
Nintex Community Menu Bar

Forms: how do i conditionally disable 'add row' in repeating section

  • November 21, 2016
  • 5 replies
  • 147 views
Forum|alt.badge.img+3

My custom SP2013 list has a people/group column Submitter. In the list form, I have a repeating section control. In the repeating section Control Settings, I am trying to configure an Expression in the Prevent add/delete in new/edit mode field that disables the add row link when the current user is NOT the Submitter.


I've tried:

  • fn-IsCurrentUser(Current User,Submitter)
  • fn-Not(fn-IsCurrentUser(Current User,Submitter))
  • fn-If(fn-IsCurrentUser(Current User,Submitter),"Yes","No")
  • fn-If(fn-IsCurrentUser(Current User,Submitter),1,0)


but none of these work. You help is greatly appreciated.

    5 replies

    Forum|alt.badge.img+14
    • emha
    • Scholar
    • November 21, 2016

    fn-IsCurrentUser takes just one input parameter, so I would say it should be like

    fn-IsCurrentUser(Submitter)‍
    Forum|alt.badge.img+3
    • contenu
    • Author
    • November 21, 2016

    Hi Marian, thanks for your quick response. Silly of me to use the wrong format for the fn_IsCurrentUser function. However, even after correcting the syntax it did not work. I'm beginning to wonder if what I want is even possible. Looking at the Help for the Prevent add/delete in new/edit mode , it says "Hides the add/delete links in new and edit mode. Select Yes to remove the ability to add or delete a new row to the repeating section in new and edit mode. **Expressions may be used to allow a row to be added or deleted only in new mode, and not edit mode, or vice versa**". That kind of suggests we can only use the IsNewMode / IsDisplayMode / IsEditMode functions in this particular expression. And even those I can't get to work... Any further insights you might have are appreciated, I'm well and truly stuck on this one.

    Forum|alt.badge.img+14
    • emha
    • Scholar
    • November 21, 2016

    no, this is not a problem.

    the problem is what I've described here https://community.nintex.com/message/49860-re-lookup-current-user-in-a-multi-value-field-in-a-list-on-a-nintex-form?comm… 

    that is, nintex at different places works with different user identifiers and so makes it hard (or almost impossible) to determine/make compare on users.

    note in addition, that in NEW mode your Submitter list field will always be empty (even if you populate to some value into form's control).

    so you only need to handle EDIT mode

    I affraid, to achieve what you ask for you will need to use javascript code.

    Forum|alt.badge.img+11
    • bimi82
    • February 18, 2019

    Hi

     

    Does this only work for Members ?
    I was trying to disable the Add New Row when Status=="Approved" but is not working.


    Any other ideas?

    Also, the Members Group is it refering to the group having access to submit a request?

    Forum|alt.badge.img+6
    • hema2930
    • September 4, 2019
    Hi,
    Did you get any fix to this?
    Regards,
    Hema
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement