I have a view with several fields on it which are related to an employee document. One of the (editable) fields on the document contains the name of the current approver. In a view field, if the current username is the name in the document’s current approver field then I have a formula in the view column to specificy a “Y” or “N”.
Coulumn Formula:
@If(Status = “Complete”;“C”;@Name([CN];@UserName) = CurApprover; “Y”;“N”)
View Formula:
SELECT form=“Employees” & @Contains(Approvers; @Name([CN];@UserName))};
Problem:
When I open the view, the first doc record I see has my name is in the current Approver field, yet “N” is displayed in the view column. If I open and save the document without making any changes, the view field then changes to a “Y” as it should have shown. I don’t want my users to have to go in and edit/save every document for which they are an approver to make this field work.
What would cause this type of behavior?