I have 2 forms. All one form in the computed field of “Manager” I have the following formula @If(@IsDocBeingSaved; @DbLookup(“”: “No Cache”; “”; “”; “Employee”; User; 2); “”)I am trying to retrieve a value from the second column on the Employee view based on the value in the field “User”. Am I doing something wrong??
Subject: @DbLookup Problem
instead of [(“”: “No Cache”; “”; “”;] you would need [(“”: “No Cache”; “”:“”;]i.e. you need to replace “:” with “;” in your code. Again since “User” field seems to be storing some user’s name, you might want to make sure your key is consistent with value as being used in view column i.e. wheather the format is canonical, abbreviated or common name only, etc… You may use “@UserName” help to deal with it…
Subject: Try: @DbLookup(“”: “No Cache”; “”; “Employee”; User; 2)
or @DbLookup(“”: “No Cache”; “”; “Employee”; @Name([Abbreviated]; User); 2)