Need to create and update a single string consisting of many substrings
Carsten Suurland
A small problem...
I need to be able to create a text for a document, that must be composed of
severel other pieces of "defaulttexts" from another database.
My question is this...
After creating the "defaulttexts" in a notes-database, I need to be able to
construct a single string in a field based on one or severel of these texts.
In addition to constructing the text, I want to be able to update this piece
of text, should any of the "substrings" in the other database change.
How is this possible?
Suurland
EdC
Suurland
I have done something like this in a job posting app. Here's a sketch of how it
works:
Create a form for your 'boilerplate' text. You don't need much more than a
short description and long description field and maybe something (author field)
to restrict edit access. Create a view that will show docs with this form only.
In your main form, in edit mode, you can show a checkbox field that gets its
choices from a @DbColumn to the first column of the boilerplate view. Below the
checkbox field, create another field that computes its value something like
this:
x := @DbLookup('':"NoCache"; ""; "boilerplate"; selectedoptions; 2);
@If(@IsError(x); ""; x)
The point is that @DbLookup will return matches from multiple key values. You
can hide the checkbox field in read mode.
Does this help?
--
EdC CLP-R5
e...@coakley.net
Contract Notes & Domino Application Development
http://www.coakley.net/edc/consulting
Check out Notes links at:
http://edcnotes1.coakley.net/web/links.nsf
Gerry King
>I need to be able to create a text for a document, that must be composed of
>severel other pieces of "defaulttexts" from another database.
>
>My question is this...
>After creating the "defaulttexts" in a notes-database, I need to be able to
>construct a single string in a field based on one or severel of these texts.
>In addition to constructing the text, I want to be able to update this piece
>of text, should any of the "substrings" in the other database change.
How do you want to update defalttexts? A computed field using
@dblookup will return the latest values. If the application does not to
update the values immediately a scheduled agent that stuffs the values
into a field.
Have a look at @Implode, @Explode and @Word - you may find them
useful for getting the values you want.
--
Gerry King
<URL:mailto:ger...@autonomie.demon.co.uk>