cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Workflow Hero

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

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.

0 Kudos
Reply
4 Replies
Workflow Hero

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

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

fn-IsCurrentUser(Submitter)
Accept as Solution Reply
Workflow Hero

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

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.

0 Kudos
Accept as Solution Reply
Workflow Hero

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

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-o... 

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.

0 Kudos
Accept as Solution Reply
Workflow Hero

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

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?

0 Kudos
Accept as Solution Reply