Hey guys, I have a control Approver type Person or group (this have a validation rule "if is empty" then fill the approver) and also I have one Yes/No control... So what I want to do is create a rule like (if Yes/no control is checked then clear the value in the Approver control and also destroy de rule) Please let me know your feedbacks. Thank you.
I assume with 'destroy rule' you mean: if Yes/no control is checked then clear the value in the Approver control and do not 'apply' the rule - ie. pass validation through.
reg. validation itself, it's just matter of validation formula. so in your case it should look like
not(CheckBox) && isNullOrEmpty(Approver)
if you search through the forum, you will definitely find some useful examples.
reg. clearing Approver, this is not possible with rules, you will have to write piece of javascript code that will do that.
awesome, that is what I needed, it is working. Thank you so much
awesome that it is awesome
do not forget to close the question by marking it answered.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.