WANT TO eDIT ONLY ONE FIELD

HCL Domino Domino Forum
1

Hi,

I want to allow to edit only one field of the document if status of the document is Released. The whole document should not go in the Editable mode, only 1 field should be in Editable mode. How to achieve this?

Thanks in advace.

2

Subject: WANT TO eDIT ONLY ONE FIELD.

You could create 2 subforms (one with all fields editable and 1 with only the 1 field editable) and compute which one to use based on status when the document loads

Note that you can only compute which subform is used as the document opens. The subform cannot change once the document is open

Mike

3

Subject: WANT TO eDIT ONLY ONE FIELD.

Using hide when formulas is one option. So when in edit mode, hide the fields that shouldn’t be edited (have a computed for display field showing instead)

OR

if the users are author in the ACL there is an option on each field to only make it editable by editors or above.

4

Subject: RE: WANT TO eDIT ONLY ONE FIELD.

temp_0:=@Name([CN];@UserName);temp_1:=@Name([CN];PrimarySponsor );

temp_2:=@Name([CN];Requester );

@If ( ( (RCNAppStatus=“Released” ) & ( (temp_0=temp_1) | (temp_0=temp_2) ) );temp_0;“”)

will this code work on access controlled section and only allow editing of that field when status is Released?

Please reply.

5

Subject: RE: WANT TO eDIT ONLY ONE FIELD.

Another approach is to not allow editing on the form itself.

Instead, introduce a custom sub-form that, for example pops up when a user clicks an action button “Modify XXXX”.

All your editing takes place in this subform.

On clicking the “OK” button, the underlying document is modified using back-end calls (i.e. non-ui related).

The front-end document can then be refreshed to show the latest changes.

6

Subject: RE: WANT TO eDIT ONLY ONE FIELD.

“” means that all users will be able to change to section, and if the username is not equal to temp1 or temp2, the section will always be available to “”, hence everybody.

There is no need for checking the username:

temp_1:=@Name([CN];PrimarySponsor );

temp_2:=@Name([CN];Requester );

@If (RCNAppStatus=“Released”;temp_1 : temp_2;“”)

If RCNAppStatus has the value “Released”, the section is editable for the primary sponsor and the requester.

If not, the section is editable for anyone.

7

Subject: WANT TO eDIT ONLY ONE FIELD.

You could also make use of the Input Enabled field event.If the document has been “Released” then the Input Enabled field event of all other fields could evaluate to false.

8

Subject: RE: WANT TO eDIT ONLY ONE FIELD.

To Arshad.

There are around 225 field on the form. So it will take huge time to code the input enabled event of all fields. How to achieve it then?

Anyways…

Thanks for the replies

9

Subject: WANT TO EDIT ONLY ONE FIELD.

To Arshad.

There are around 225 field on the form. So it will take huge time to code the input enabled event of all fields. How to achieve it then?

Anyways…

Thanks for the replies.

10

Subject: RE: WANT TO EDIT ONLY ONE FIELD.

Wow!! Thats a LOT of fields for the poor user to fill in the form!!!

But yes - if there are that many fields then it will be time consuming to enter the code in the Input Enabled event of each field - even though you will just be copy-pasting the same code for all the 225 fields.

What you havent mentioned is whether you are developing this for the web or Notes client - if it is the web then you can easily use the disabled property in JavaScript to disable the fields when the form loads.

11

Subject: RE: WANT TO EDIT ONLY ONE FIELD.

You can put all the field in a controlled-access section (see help for more info).On the formula tab you can define who can edit the fields in the section. (something like @if(status=“Released”;“[no-one]”; “[everyone]”))

12

Subject: RE: WANT TO EDIT ONLY ONE FIELD.

Actually - that does sound very reasonable!