On 18 Oct 2008, at 7:41, sigbackup wrote:
> " in a web-compatible way?"
>
> Unfortunately conditional formatting is not web-compatible.
>
yes, sorry, I fired of my email without taking in your web-compatible
requirement, duh!
You don't say exactly how you want your display to look - do you want
to show the field labels for all fields and just the "a" values, or
just show the labels for the fields with value "a" (with or without
the "a" value), and, if the latter, do you want each field to always
appear in the same place or do you want a compressed list of the "a"
value fields????
for example, if you have Field1 thru Field5 and only the first
third and fifth have value "a", do you want:
1:
Label1 a
Label2
Label3 a
Label4
Label5 a
or 2:
Label1 (a)
Label3 (a)
Label5 (a)
or 3:
Label1 (a)
Label3 (a)
Label5 (a)
For 1 or 2, I'd use the Steve's method - if you want option 2 then
change the text returned to include the label text. However, if you
have a whole bunch of "a/b" fields you might use one repeating calc
field to save table clutter:
Let ( r = Get ( CalculationRepetitionNumber ) ;
Case (
r = 1 ; If ( Extend ( field1 ) = "a" ;
"<text1>" ) ;
r = 2 ; If ( Extend ( field2 ) = "a" ;
"<text2>" ) ;
....
)
)
where <textn> is the label and/or "a".
For 3, you can use a single calc field, cDisplay =
List (
If ( field1 = "a" ; "<text1>" ) ;
If ( field2 = "a" ; "<text2>" ) ;
If ( field3 = "a" ; "<text3>" ) ;
If ( field4 = "a" ; "<text4>" ) ;
If ( field5 = "a" ; "<text5>" )
)
cheers
Tom
--
This list is a free service of LassoSoft:
http://www.LassoSoft.com/Search the list archives:
http://www.ListSearch.com/FileMaker/Browse/Manage your subscription:
http://www.ListSearch.com/FileMaker/
