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