Variable Document Security Customization

HCL Domino Domino Forum
1

My company is has a database that is used to track engineering change requests (ECR) for our products. If something needs to be fixed on a product, an ECR is submitted. The database is junk and they want to update how it works.

If an ECR is submitted, they would like the security of the new ECR to change, depending on if it has been accepted, is in progress, is rejected, or is completed.

Is there a way (with ACLs, Roles, etc.) to set it up so that based on the progress of the ECR, an individual can or cannot edit certain fields? For example, if an ECR is pending, User #1 can edit it, but once it has been accepted and is in progress, he can no longer touch it.

I should add that I’m new at database design, so I’m still learning.

2

Subject: use different forms, subforms or hide-when formulas

sorry, but this is basic development knowledge:

use different forms, subforms or hide-when formulas on fields in combination with authors and readers fields (if docs should be hidden completely)

3

Subject: sections

You could also use access-controlled sections and specify the access formulas to use the status as a determining factor.

You’d probably want to combine that with a group, specified names from a profile field, or roles.