Hi,I have a Dialog type field called NamesList with the following formula:
@DbColumn(“”:“NoCache”;“”:“Names.NSF”; “People”; 1)
When testing the form on the web the drop-down list is empty. I’ve tried this in a Notes client version and it gives out the formula in the dialog box. However when using a Names type field it works fine in the Notes client but not on the web.
Can someone help me? Anxiously seeking an answer to this.
Thanks,
Dan
Subject: names list field not working on web
I think you need to add the Replica ID of the database from which this @DBLookup originates to the ACL of the names.nsf. Reader access should be sufficient. You can easily grab the replicate ID string from the database synopsis, the “:” mark inside the replicate ID string is needed also.
Subject: RE: names list field not working on web
Hi Mika,thanks for your response. Here is the updated formula(by the way it is a @DBColumn formula …does that make a difference?) and the same thing happens in the dialog box (instead of a list of employee names I see the formula displayed.
@DbColumn(“”:“NoCache”;“”:“85256E20:007CBF86”; “Contacts”; 1)
Thanks,
Dan
Subject: RE: names list field not working on web
You need to add the replica ID to the ACL of the names.nsf (the replica ID of your database), and not to the @dblookup.
Subject: RE: names list field not working on web
never done that before. So what your are saying is that I should put the Replica ID of the DB in which my formula exists (empdir.nsf) in the ACL of my names.nsf ? What access level should I give this entry and what user type should be selected for the same entry?
Dan
Subject: RE: names list field not working on web
Yeah, I know it’s wierd, but I had to do it too some times. I can’t remember the rule when it’s needed, but when it’s needed you can specify it as Reader access, Unspecified type.
I found this in the Help:
Note! Agents running on R5 or earlier servers can only access target databases stored on the same server as the source database. In addition, the agent signer must have at least Reader access to the target database. The use of a replica id in the acl is still supported in Release 6. If the agent signer is not available in the acl of a pre-Release 6 database and the replica id is, the replica id is used instead. (You grant access to the source database by adding the replica id of the source database, for example 85255CEB:0032AC04, to the ACL of the target database and assigning it Reader access or higher.)
Subject: RE: names list field not working on web
OK this is still not working …I mean the field type anyway. It was displaying a dropdown list field on the web but when I changed the field type to a Names type the same thing happened except that this time the field is only being displayed as a edti type field on the web (still no content).
What am I doing wrong? The Names type field works fine in the Notes version, but not for the web. Something is strange here.
Can SOMEONE help me ???
Confused,
Dan
Subject: Take out a “”: @DbColumn(“”:“NoCache”; “85256E20:007CBF86”; “Contacts”; 1)