Computed Fields

HCL Domino Domino Forum
1

I have three fields that have the formulas

@if(EditCompleted = “Yes”; @Name([CN]; @UserName): “”)

@If(Approved = “yes”; @Name([CN]; @UserName); “”)

@If(Completed = “Yes”; @Name([CN]: @UserName); “”)

All three fields are Computed fields

When the Editor goes in and marks the document as Edited then their name appears in the Edit Completed by field, as expected.

When the Approver goes in and marks the document as approved then their name appears in the Approved by field but also in the Edit Completed by field (taking out the original name).

When the person marking the document completed marks the document as completed then all three fields has his name in it.

Can someone tell me what I am doing wrong?

2

Subject: Computed Fields

You haven’t accounted for existing values in your formulae:

@if(EditCompleted = “Yes”; @If(ThisValue = “”;@Name([CN]; @UserName); @ThisValue); “”)

If EditCompleted is “Yes” then the user’s name will be entered – if no value is already there. If there’s already a value, the formula keeps the old value. Your other formulas can be altered the same way.

3

Subject: Computed Fields

An easier way might be to make the fields computed to themselves, and then set the fields in the actions you use for marking the document as edited, approved etc.

Use @SetField

HTH

Mark