Dear All,I would like to use as choice of a radio button a field of a profile document that is on another database.
How can I make it?
Thank you for your assistance
Subject: Use LotusScript
Subject: Use LotusScript
A radiobutton allows to “Use Formula for choices”.Any way to use lotuscript there?
In case where do you suggest to use lotuscript? on the form onLoad … PostOpen … queryOpen … ?
Any other suggestion?
How can I assigne the list of possible choices for this field via lotus script?
thank you for your quick reply
Andrea
Subject: RE: Use LotusScript
In cases such as this, I would probably add an agent to run on the server and copy values from one database’s profile document to another database’s profile document, so that the value is available locally. Otherwise, you are creating a dependency – if someone creates a local replica of your application, they might not know they also need a local replica of the other application.
You can use @DbLookup to access data from other databases, as an alternative to @GetDocField.
If you want to load the data “live” when a document is composed, I would use onload event to check if it’s open in edit mode and if so, store the result into a CFD field named Stuff (for instance). Multivalued, formula = Stuff. Do the same thing in Postmodechange. Then the keyword formula could be something like:
@If(@IsDocBeingLoaded; @Unavailable; Stuff)
That would probably work.
Subject: RE: Use LotusScript
Thanks Andre,works now!
Bye
Andrea