How can a get a Profile doc from ANOTHER database using formulas? The reason I have to use a formula is because I need it in a computed field of a web form. Any help will be appreciated.
Thanks
Subject: Is there a formula version of GetProfileDocument?
@GetProfileField works on the web, but I don’t think it works across databases.
This might help you somehow - not sure how, as I don’t know your situation.
In R6 @SetProfileField and @GetProfileField now take [NoPersist] as an argument instead of a profile form name, e.g.,
@SetProfileField([NoPersist];“MyVariable”;@username)
The specified variable (field) exists only for the life of the session. As with any “profile” information, though, the value can be read by an other @command/formula. So it can be used to pass information from one window to another (or frame to frame, …) It’s equally handy when you need somewhere to stash some temporary information in a read-only document.
The feature was not signed off as verified as working until very late in the Notes 6 development cycle and so didn’t make it into the documentation. It is used in the shipping 6.0 mail template (e.g., look at how some of the “buttons” work in the Calendar Notice form).
Stephen Lister
Subject: Is there a formula version of GetProfileDocument?
Hector,
@formulas will not be able to access profile documents from another database. I know that in R5 there was an enhancement request for R.something to have profile documents included in views and to make it possible to access profile docs from other databases, but as far as I know this hasn’t been implemented in R6.
A workaround would be the pre-profile document technique: in your “other” database, create a “configuration” document which you can display in a view.
You then can use @DbLookup to access this config document and its values.
Perhaps this helps a bit,
Stephan
Subject: thanks