showing only fields with a specific value
|
View:
New views
13 Messages
—
Rating Filter:
Alert me
|
 |
showing only fields with a specific value
by Sigfrid
::
Rate this Message:
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/ Alla prossima ... |
|
|
Re: showing only fields with a specific value
by Tom Elliott
::
Rate this Message:
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/ |
|
|
Re: showing only fields with a specific value
by Clayton Randall
::
Rate this Message:
Conditional formatting does not work with IWP afaik
On 10/18/08, Tom Elliott <thosliot@...> 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/ > > -- 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/ |
|
|
Re: showing only fields with a specific value
by Sigfrid
::
Rate this Message:
" 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 <thosliot@...>: > 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/ > > -- 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 ... |
|
|
Re: showing only fields with a specific value
by Steve Cassidy
::
Rate this Message:
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/ |
|
|
Re: showing only fields with a specific value (back channel)
by Tom Elliott
::
Rate this Message:
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/ |
|
|
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/ Alla prossima ... |
|
|
Re: showing only fields with a specific value (back channel)
by Sigfrid
::
Rate this Message:
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 <sigbackup@...>: > 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/ > > -- 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 ... |
|
|
Re: showing only fields with a specific value (back channel)
by Jens Selvig
::
Rate this Message:
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 jjsiii@... ...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/ |
|
|
Re: showing only fields with a specific value (back channel)
by Sigfrid
::
Rate this Message:
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 <jjsiii@...>: > 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 > jjsiii@... > > ...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/ Alla prossima ... |
|
|
|
|
|
Re: showing only fields with a specific value (back channel)
by kazar
::
Rate this Message:
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/ |
|
|
Re: showing only fields with a specific value (back channel)
by Sigfrid
::
Rate this Message:
Thanks for the replies
I will follow your hints 2008/10/20 Datatude <techlists@...>: > 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/ > > -- 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 ... |
| Free embeddable forum powered by Nabble | Forum Help |
