showing only fields with a specific value

13 messages

showing only fields with a specific value

Reply Threaded

Hello folks, it is still me

I have a set of fields that can have as a value "a" or "b" and I need
to create a layout where I show only (for a single record) the fields
that have "a" as a value.

Any idea about how I can achieve that in a web-compatible way?

MANY THANKS and HAVE A NICE DAY!

Sig

--
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/

Tom Elliott

Re: showing only fields with a specific value

Reply Threaded

Conditional formatting?

cheers

Tom

On 18 Oct 2008, at 8:16, sigbackup wrote:

> Hello folks, it is still me
>
> I have a set of fields that can have as a value "a" or "b" and I need
> to create a layout where I show only (for a single record) the fields
> that have "a" as a value.
>
> Any idea about how I can achieve that in a web-compatible way?
>
>
>
>
> MANY THANKS and HAVE A NICE DAY!
>
>
>
> Sig
>
> --
> 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/

Clayton Randall

Re: showing only fields with a specific value

Reply Threaded

Conditional formatting does not work with IWP afaik

On 10/18/08, Tom Elliott <[hidden email]> wrote:

> Conditional formatting?
>
> cheers
>
> Tom
>
> On 18 Oct 2008, at 8:16, sigbackup wrote:
>
>> Hello folks, it is still me
>>
>> I have a set of fields that can have as a value "a" or "b" and I need
>> to create a layout where I show only (for a single record) the fields
>> that have "a" as a value.
>>
>> Any idea about how I can achieve that in a web-compatible way?
>>
>>
>>
>>
>> MANY THANKS and HAVE A NICE DAY!
>>
>>
>>
>> Sig
>>
>> --
>> 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/
>
>

sigbackup

Re: showing only fields with a specific value

Reply Threaded

In reply to this post by Tom Elliott

" in a web-compatible way?"

Unfortunately conditional formatting is not web-compatible.

By the way thanks. I keep looking for some ideas.

2008/10/18 Tom Elliott <[hidden email]>:

Steve Cassidy

Re: showing only fields with a specific value

Reply Threaded

Well the obvious, simple solution is calculated fields:

Case (FieldX = "a", "a", "")

Repeated for each one of your fields and then displayed on your web
layout. Not pretty, but it will work.

Steve

On 18 Oct 2008, at 19:41, sigbackup wrote:

> " in a web-compatible way?"
>
> Unfortunately conditional formatting is not web-compatible.
>
>
> By the way thanks. I keep looking for some ideas.

--
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/

Tom Elliott

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

Reply Threaded

In reply to this post by sigbackup

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/

sigbackup

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

Reply Threaded

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 <[hidden email]>:

>
> 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/
>
>

sigbackup

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

Reply Threaded

Hi, it is still me.

Using calculated fields creates data redundancy. Is there a way to
deal with my issue using the fields I already have?

THANKS

2008/10/19 sigbackup <[hidden email]>:

> 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 <[hidden email]>:
>>
>> 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/
>
>

Jens Selvig

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

Reply Threaded

Hmmm, maybe I am all wet but I don't think calculated field create
data redundancy. Copying data into seperate tables creates redundancy,
No?

Jens

On Oct 19, 2008, at 6:52 PM, sigbackup wrote:

> Using calculated fields creates data redundancy. Is there a way to
> deal with my issue using the fields I already have?

Jens Selvig
[hidden email]

...lost in Montana...

--
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/

sigbackup

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

Reply Threaded

Thanks Jens,
using calculated fields I have to create an other table that contains
basically the same values I already have in the "parent" table. Isn't
it? Maybe I'm wrong since I'm a FM newbie.

2008/10/19 Jens Selvig <[hidden email]>:

> Hmmm, maybe I am all wet but I don't think calculated field create data
> redundancy. Copying data into seperate tables creates redundancy, No?
>
> Jens
>
>
> On Oct 19, 2008, at 6:52 PM, sigbackup wrote:
>
>> Using calculated fields creates data redundancy. Is there a way to
>> deal with my issue using the fields I already have?
>
> Jens Selvig
> [hidden email]
>
> ...lost in Montana...
>
>
>
>
>
> --
> 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/
>
>

Serge Schongut

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

Reply Threaded

In reply to this post by Tom Elliott

Hi,
You should create the calc fields in the same table as the input fields.
The calc fields will only create redundancy if they are stored.
I have the impression, though by the info transmitted that this calculated
display solution could be bypassed.
Serge Schongut
Elico Belgium

--- Original Message -----
From: "sigbackup" <[hidden email]>
To: "FileMaker Talk" <[hidden email]>
Sent: Monday, October 20, 2008 3:43 AM
Subject: Re: showing only fields with a specific value (back channel)

> Thanks Jens,
> using calculated fields I have to create an other table that contains
> basically the same values I already have in the "parent" table. Isn't
> it? Maybe I'm wrong since I'm a FM newbie.
>
>
>
> 2008/10/19 Jens Selvig <[hidden email]>:
>> Hmmm, maybe I am all wet but I don't think calculated field create data
>> redundancy. Copying data into seperate tables creates redundancy, No?
>>
>> Jens
>>
>>
>> On Oct 19, 2008, at 6:52 PM, sigbackup wrote:
>>
>>> Using calculated fields creates data redundancy. Is there a way to
>>> deal with my issue using the fields I already have?
>>
>> Jens Selvig
>> [hidden email]
>>
>> ...lost in Montana...
>>
>>
>>
>>
>>
>> --
>> 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/
>
>

kazar

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

Reply Threaded

In reply to this post by sigbackup

On 10-19-2008 9:43 PM, sigbackup wrote:
> Thanks Jens,
> using calculated fields I have to create an other table that contains
> basically the same values I already have in the "parent" table. Isn't
> it? Maybe I'm wrong since I'm a FM newbie.
>
No, they can be in the same table. You might want to make them unstored
so that the "redundant" data is not stored in the database at all and
instead is crunched at runtime, when needed.

kazar

--
Datatude, Ltd. -- http://www.datatude.net/
strategies & solutions
"Tools of Choice" forums at http://network.datatude.net/

--
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/

sigbackup

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

Reply Threaded

Thanks for the replies

I will follow your hints

2008/10/20 Datatude <[hidden email]>:

> On 10-19-2008 9:43 PM, sigbackup wrote:
>>
>> Thanks Jens,
>> using calculated fields I have to create an other table that contains
>> basically the same values I already have in the "parent" table. Isn't
>> it? Maybe I'm wrong since I'm a FM newbie.
>>
>
> No, they can be in the same table. You might want to make them unstored so
> that the "redundant" data is not stored in the database at all and instead
> is crunched at runtime, when needed.
>
> kazar
>
>
> --
> Datatude, Ltd. -- http://www.datatude.net/
> strategies & solutions
> "Tools of Choice" forums at http://network.datatude.net/
>
> --
> 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/
>
>