Lotus Notes - How to restrict a Person Manager from editing a field
I have a customer using a custom 'PO Database'. It has been in use for a number of years, and the person that wrote it is long gone. They have come to me with a particular need.
I can usually figure this stuff out, but I'm so far off on this one, I need a finger to point me in the right direction.
Most everyone is setup as an author or editor, and there are some roles defined. (I don't really know what those roles do yet)
Their problem is that certain fields remain editable even after a PO has been approved. Now, apparently that is how it was setup, so no big mystery there. The question is though, how do you change a persons access to a particular field on a form, when they start off having access? It looks like a form just shows up in different views as it reaches certain stages of approval, so can I lock certain fields to read only when a document is marked completed?
Here is the view selection for 'Completed' which I think just indicates that it isn't one of the mentioned status' ...not sure if this helps.
SELECT Form = "Document" & Status !="Draft" & Status !="Submitted" & Status != "Paid"
I know this is just a sliver of what you would need to fix this, so again, I'm just looking to be pointed in the right direction.
I can usually figure this stuff out, but I'm so far off on this one, I need a finger to point me in the right direction.
Most everyone is setup as an author or editor, and there are some roles defined. (I don't really know what those roles do yet)
Their problem is that certain fields remain editable even after a PO has been approved. Now, apparently that is how it was setup, so no big mystery there. The question is though, how do you change a persons access to a particular field on a form, when they start off having access? It looks like a form just shows up in different views as it reaches certain stages of approval, so can I lock certain fields to read only when a document is marked completed?
Here is the view selection for 'Completed' which I think just indicates that it isn't one of the mentioned status' ...not sure if this helps.
SELECT Form = "Document" & Status !="Draft" & Status !="Submitted" & Status != "Paid"
I know this is just a sliver of what you would need to fix this, so again, I'm just looking to be pointed in the right direction.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent information, thank you!
ASKER
Hey, follow up question. Right now there is a table, with one field in each cell. I add a new field (computed for display) to the same cell, however, when I use the 'Hide paragraph if formula is true' it applies that to both fields in that cell. Can I disable that?
Make sure both fields are in separate paragraphs. A carriage return (Enter) between the two will do.
ASKER