Re: showing only fields with a specific value (back channel)

> Hi Tom and thanks for your reply.
> I'm sorry if I haven't specified exactly my needs.
>
> What I want it is showing a custom text (for instance "chemical lab"
> for "distribution_LC")  (or if it is simpler I can just update the
> fields name) for each field that has "a" as a value.
> The fields that I need to check out start with the same prefix
>
> "distribution_LC", "distribution_LM", "distribution_PR" .....
>
>
> Moreover, I guess to trigger the script once the layout is loaded I
> need a plugin (like doscript). Am I right? Is it web-compatible?
>
> THANK YOU SO MUCH FOR YOUR HELP, I APPRECIATE IT
>
> Have a nice day.
>
>
> Sig
>
>
>
>
> 2008/10/19 Tom Elliott <thosliot@...>:
>>
>> 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/
>>
>>
>
> --
> 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/
>
>