Access formula

HCL Domino Domino Forum
1

I have this access formula on a controlled section. I’m trying to show the user’s name instead of the field name.

Can anyone tell me how to do that? Thanks!

@If(Approval = “Yes” | Approval = “No”; @Name([Canonicalize];“Mgr”): @Name([Canonicalize];“MgrBackup”); Author)

2

Subject: access formula

Too many quotation marks. Instead of this, for example:

@Name([Canonicalize];“Mgr”)

…do this:

@Name([Canonicalize]; Mgr)

At the moment, your formula is working on the strings “Mgr” and “MgrBackup”, not the contents of those fields.

3

Subject: access formula

Take the quotes off of the field names in the @Name() statements.