« Return to Thread: showing only fields with a specific value
Re: showing only fields with a specific value (back channel)
by Sigfrid
::
Rate this Message:
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/
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/
Alla prossima ...
« Return to Thread: showing only fields with a specific value
| Free embeddable forum powered by Nabble | Forum Help |
