I have a rule where users cannot select the current month, only previous months.
Is there a rule where I can have a single user "John" to be able to override those rules to submit a form in the current month?
Thanks in advance.
Is there a way to have a single user override all rules on a form?
+2
+12@SpenSouv .....add John into a SharePoint group. Apply a formatting rule on that current month control:
!fn-IsMemberOfGroup('John'sSPGroup') then disable the current month control.
+2Hey Kunal,
What if its a rule on a calculated field? Is it possible to place a rule on a rule?
Currently on the calc field:
choiceServiceMonth >= 1*formatDate(Current Date, "MM")
I tried to place the rule you provided into the calculated field under the Current date rule, but did not work.
!fn-IsMemberOfGroup(GroupName)
What am I doing wrong?
Thanks for your help!
What if its a rule on a calculated field? Is it possible to place a rule on a rule?
Currently on the calc field:
choiceServiceMonth >= 1*formatDate(Current Date, "MM")
I tried to place the rule you provided into the calculated field under the Current date rule, but did not work.
!fn-IsMemberOfGroup(GroupName)
What am I doing wrong?
Thanks for your help!
+12@SpenSouv ......you can apply multiple rules on a control. But could you please let me know what you're trying to achieve in below mentioned rule? and why to multiply anything with "1"?
+2Forgive me as I'm still new to this.
Its a rule I copied from another post that helped to create a rule where if the calculated month = to current month or later, then the rule will validate an error.
Im not sure what the multiplication of 1 is for to be honest.
Its a rule I copied from another post that helped to create a rule where if the calculated month = to current month or later, then the rule will validate an error.
Im not sure what the multiplication of 1 is for to be honest.
+12@SpenSouv ....you need to create 2 different rules:
- Formatting Rule: Use my formula and add the SharePoint group name in which you've added John. Make sure you select Disable
- Validation Rule: Use your rule and remove "1*" and make sure from the dropdown you select validation and type the message you want to display
You can apply multiple rules on a single control
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.