R
random
I have a change management form that has close to 30-40 fields in it.
I need to make sure that only specific people in the management team have
"approve" access to the form once it's been submitted.
I'm using a combinatin of "user roles" and "conditional formatting" to
achieve this.
I've basically built a method in the form so that it looks at your Active
Directory login and associates it with a table in the form that contains the
managers that are allowed to approve and make changes to the form.
I then basically set an expression for "conditional formatting" for each
field in the form that says "if user role is not equal to form approver then
read-only"
Problem is: I have to set this expression for each of the fields
individually. that's 30-40 times I have to repeat the same freakin
expression. Im going nuts, and my carpal is not taking well to this apparent
lack of functionality. Not to mention forms im designing that are going to
have more fields than that.
My question is:
1. is there a better way to do this?
2. is there a way to set some global expression that would show up in the of
conditional formatting expressions so that all I have to do is click and
choose, rather than have to create the expression from scratch for each field
individually?
3. is there a way to set this expression globally over the entire form with
only one expression?
please help! it's almost impossible to do this, especially when a change has
to be to add another or different type of expression for the read-only/hidden
flag.
I need to make sure that only specific people in the management team have
"approve" access to the form once it's been submitted.
I'm using a combinatin of "user roles" and "conditional formatting" to
achieve this.
I've basically built a method in the form so that it looks at your Active
Directory login and associates it with a table in the form that contains the
managers that are allowed to approve and make changes to the form.
I then basically set an expression for "conditional formatting" for each
field in the form that says "if user role is not equal to form approver then
read-only"
Problem is: I have to set this expression for each of the fields
individually. that's 30-40 times I have to repeat the same freakin
expression. Im going nuts, and my carpal is not taking well to this apparent
lack of functionality. Not to mention forms im designing that are going to
have more fields than that.
My question is:
1. is there a better way to do this?
2. is there a way to set some global expression that would show up in the of
conditional formatting expressions so that all I have to do is click and
choose, rather than have to create the expression from scratch for each field
individually?
3. is there a way to set this expression globally over the entire form with
only one expression?
please help! it's almost impossible to do this, especially when a change has
to be to add another or different type of expression for the read-only/hidden
flag.