I have a view - in this view the first column is UserId (shortnames) Inside each document there is a field call testmgr. I am wanting to use the UserId to get the managers name and place it in the field. I have the code and it works as a action inside the form, but when I try to run it as a agent on all documents in view it fails. Here is my agent
SELECT Form = "User Information";
lookup := @DbLookup("":"NoCache";"Server/Server":"names.nsf"; "($Users)";UserId; "Manager");
I think the problem is the agent is not getting the UserId from the undelying documents?