Restricting editing of a field for editors

HCL Domino Domino Forum
1

I have a database form in which users have editor access. However, I would like to restrict changes from being made to a particular date field after the document has been saved. The purpose is to prevent users from changing the date field which is being used to calculate how long an item has been outstanding. If pressed for an item, they might decide to go back into the record and simply change the date so that it’s not outstanding. Any ideas on the best solution for this considering they all need editor access? My first thought is to use a hide/when formula that reads !@IsNewDoc but I do want them to SEE the field just not be able to edit the contents.

Thanks in advance

2

Subject: Restricting editing of a field for editors

So, use the hide formula you had in mind and then have another item (either a computed for display field or a computed text area) that is shown when the document is not new.

3

Subject: RE: Restricting editing of a field for editors

Not even an Editor can edit a Computed field. Set the field to compute on save if the document is a new document, using the @now and precede the formula to see if the Field already has a date, if it does have a date return the date otherwise compute the date.EXAMPLE

asume the field is StartDate,

@If (StartDate != “” ; @Return(StartDate) ; (@IsNewDoc & @IsDocBeingSaved) ; @Now ; “”)

4

Subject: Restricting editing of a field for editors

Do the user’s need to change the date at all? Why not just use a computed field with @Today.

Or a hide when like you mention and use a computed for display field to display it to the user.

5

Subject: RE: Restricting editing of a field for editors

Thanks for the response. Yes, the dates being entered are various dates from the past. Your idea of using @Today as a computed field would work perfectly otherwise.