Field refreshing the username value

HCL Domino Domino Forum
1

Hi All,

I have three fields on a form

Application Status (Dialog List, Editable)

Application Approver (Text, Computed)

Document Status (Dialog List, Editable)

The Document is Approved by the Approver by selecting the values Approved or Not Approved.

Once the Application Status field has Approved or Not Approved value then

I want to get the Approvers name in the Application Approver field for which i use the below formula.

@If(AppStatus=“Approved” | AppStatus=“Not Approved” ;@Name([CN];@UserName);“”)

When the Approver completes his approval process then the Admin needs to close the document by selecting the Closed value in the Document Status field.

My problem starts from now:

When the Admin Selects the “Closed” option from the Document Status field the value in the Application Approver field changes to the name of the Admin (Who will be a diffrent preson from the Approver) and the Approver name is wiped off from the Application Approver field adding the Admins name in it.

Need your help

Regards,

Atul A.

2

Subject: Field refreshing the username value

Try Computed When Composed instead of Computed field for

Application Approver (Text, Computed When Composed)

hope this work… if not then there may b a problem with your Condition

3

Subject: RE: Field refreshing the username value

No, you will not get desired results even if you change the field to Computed when composed.Infact in that case the approver value will not set at all since record would have saved once earlier.

The problem is with your condition,

It checks if status is “Approved/Not approved”,then capture the name of current user.

When admin is saving record ,he meets the condition in formula so previous value is overwritten by new value.

Instead you can check if the value of the field is “”,then proceed ahead

@If(ApproverName!=“”;@return(ApproverName);“”)

@If(Status=“Approved”|Status=“Not Approved”;@userName;“”)

Please check the correct name of fields in above formula:-)

4

Subject: RE: Field refreshing the username value

Thanks! Shishir

I got there using the OnChange event of the field Approval Status.

Thanks! again.