Help with a complicated hidewhen formula usinng many userroles
Posted on 2003-03-27
I need help with a complicated hidewhen
In a database there is an approval section in a table.. Within the section there are up to ten
different approvers and ten rows in the table.
Each of the rows has an Accept or Deny button. The hidewhen on the buttons is based on the name in a
StatusRev != "Complete" | StatusD != "Drafting Complete" | (@IsNotMember(@Name([CN]; @UserName);
Approver)) | AppStat = "Approval Completed"
approver, approver_1 etc....
Three of the approver fields approver_4, approver_5 and approver_6 contain group names.
Each group has a userrole created for it. I only want to show the button to individuals from that
group. I know that it will be available to all members of the group, however with the security on the
form only one person will be able to edit the document and push the button which when pushed will
examples of the groups and roles
This is the current hidewhen. The userrole MQ has been assigned to all groups, problem is they can
see buttons they are not supposed to, I only want the right role seeing the right button. If the
person from a group with AE1 enters the document they will only see the button for Assembly-Engine.
@TextToNumber(MaximumApprovers) < 5 | StatusRev != "Complete" | StatusD != "Drafting Complete"
|(@IsNotMember(@Name([CN]; @UserRoles); "[MQ]" )) | AppStat_4 = "Approval Completed"
Any help is appreciated