I have a Notes database which does not allow anonymous web access, but I would like to show the results of an @dbcolumn formula from that database, displaying it in a second Notes database Page which does allow anonymous access.
At present the user is forced to log in even though the database allows anonymous users because the source database is protected. I’m sure there must be an easy way to achieve this, any help would be appreciated.
Subject: Export Notes Data Between Notes Databases
Can you use the PublicAccess option to give anonymous users access to just the view and documents that are needed?
If not you could replace the page with a form or agent and then use LotusScript on the server to do the lookup.
Subject: RE: Export Notes Data Between Notes Databases
Niel, I cannot give access to documents to anonymous users they contain sensitive customer data. My aim is to extract statistics from the view, e.g. highest number in a column, average of a column, number of elements in the view etc.
I guess I need to explore the LotusScript option on the server. Not my area of expertise I am afraid. But many thanks for your help.