Use of List Superobject
David Thompson
dthmpsn1 at illinois.edu
Fri Jul 18 07:01:33 PDT 2008
>I am having trouble figuring out how to
>conxtruct a formula which is directly enterable
>into the "List Items (Formula)" box of a
>Scrolling List Superobject.
>
>I want simply to list the contents of two fields
>from all selected records. I don't see how to do
>this without a procedure which builds an array
>or some such thing.
>
>Am I missing an important concept?
Your previous question mentioned that you were
using Panorama 5.5, so you can use the
arrayselectedbuild( custom function.
arrayselectedbuild(cr(),"",{Field1+" "+Field2})
cr() is a custom function that returns a carriage
return. It's a little more email friendly than
using the ¶ paragraph symbol. Notice the {}
braces around the formula parameter. They, or
some other quoting characters are a requirement
of the arraybuild(, arrayselectedbuild,
arrayfilter(, characterfilter(, and chunkfilter(
custom functions.
Another method, that also works with Panorama V,
is to set the list superobject to scan the
database, and use info("Visible") in your formula
to limit the list to just the visible records.
?(info("Visible"), Field1+" "+Field2,"")
Dave
More information about the Qna
mailing list