I have field entitled Service Coordinator which is a a value list.  I
want to assign each person (service coordinator) in that value list a
color so when each value is selected the whole record appears in that
color.  How do you do that?

In article <c4f3d99f.0405102148.397dea96@posting.google.com>,
mark_lees@byu.edu (Mark Lees) wrote:

> I have field entitled Service Coordinator which is a a value list.  I
> want to assign each person (service coordinator) in that value list a
> color so when each value is selected the whole record appears in that
> color.  How do you do that?

You can't change the colour of the fields or text themselves (at least
not without A LOT of extra work).

The easiest way would be to change the background of the field(s) ...
or the entire window if you insist. Personally I'd just change one
field, perhaps their name, otherwise your database ends up looking like
a Christmas tree.

To do this you need to have a set of Global Container fields (or one
repeating Global Container field) into which you paste a small square
of each colour.
eg.        gBlueBackground
           gGreenBackground
           gYellowBackground
         etc.

Then you can use a normal Calculated field with a container result that
works out which colour to use from your Service Coordinator field,
ie.   
          BackgroundColour = 
                  Case(Service Coordinator="A", gBlueBackground,
                       Service Coordinator="B", gGreenbackground,
                       Service Coordinator="C", gYellowbackground,
                    etc.
                      )

You then put this calculated field behind the other field(s) (making
sure they are all transparently filled) or stretched out behind
everything so that it fills the window. Remember to set the field's
graphic format to enlarge so that the small square fills the field.






Helpful Harry                   
Hopefully helping harassed humans happily handle handiwork hardships  ;o)

You can change the color of the text dynamically in FileMaker Pro 7...is
that what you are using, or are you on v6?

CDMK


On 5/11/04 1:38 AM, in article
110520041838046214%helpful_harry@nom.de.plume.com, "Helpful Harry"
<helpful_harry@nom.de.plume.com> wrote:

> In article <c4f3d99f.0405102148.397dea96@posting.google.com>,
> mark_lees@byu.edu (Mark Lees) wrote:
> 
>> I have field entitled Service Coordinator which is a a value list.  I
>> want to assign each person (service coordinator) in that value list a
>> color so when each value is selected the whole record appears in that
>> color.  How do you do that?
> 
> You can't change the colour of the fields or text themselves (at least
> not without A LOT of extra work).
> 
> The easiest way would be to change the background of the field(s) ...
> or the entire window if you insist. Personally I'd just change one
> field, perhaps their name, otherwise your database ends up looking like
> a Christmas tree.
> 
> To do this you need to have a set of Global Container fields (or one
> repeating Global Container field) into which you paste a small square
> of each colour.
> eg.        gBlueBackground
>          gGreenBackground
>          gYellowBackground
>        etc.
> 
> Then you can use a normal Calculated field with a container result that
> works out which colour to use from your Service Coordinator field,
> ie.   
>         BackgroundColour =
>                 Case(Service Coordinator="A", gBlueBackground,
>                      Service Coordinator="B", gGreenbackground,
>                      Service Coordinator="C", gYellowbackground,
>                   etc.
>                     )
> 
> You then put this calculated field behind the other field(s) (making
> sure they are all transparently filled) or stretched out behind
> everything so that it fills the window. Remember to set the field's
> graphic format to enlarge so that the small square fills the field.
> 
> 
> 
> 
> 
> 
> Helpful Harry    
> Hopefully helping harassed humans happily handle handiwork hardships  ;o)

Chris:

I'm using FMP 7 Developer.

When a user selects a certain service coordinator I want all of the
text of the records that are associated with that service coordinator
to be a specific color.

Thanks 


Chris Kubica <info@applicationarch.com> wrote in message news:<BCC5FC7A.7896%info@applicationarch.com>...
> You can change the color of the text dynamically in FileMaker Pro 7...is
> that what you are using, or are you on v6?
> 
> CDMK
> 
>

Chris:

I'm using FMP 7 Developer.

When a user selects a certain service coordinator I want all of the
text of the records that are associated with that service coordinator
to be a specific color.

Thanks 


Chris Kubica <info@applicationarch.com> wrote in message news:<BCC5FC7A.7896%info@applicationarch.com>...
> You can change the color of the text dynamically in FileMaker Pro 7...is
> that what you are using, or are you on v6?
> 
> CDMK
> 
>

You need to add an auto-enter calc to all of those text fields whose 
color you want to change.  Something like:

case(
SrvcCoord = "Joe Smith"; TextColor(ThisField; RGB(255; 0; 0));
ThisField)

In this example, if the service coordinator was Joe Smith, then 
ThisField would display in red.  Be sure to unmark the option to allow 
for replacing of any existing text in the field.

Mark Lees wrote:

> Chris:
> 
> I'm using FMP 7 Developer.
> 
> When a user selects a certain service coordinator I want all of the
> text of the records that are associated with that service coordinator
> to be a specific color.
> 
> Thanks 
> 
> 
> Chris Kubica <info@applicationarch.com> wrote in message news:<BCC5FC7A.7896%info@applicationarch.com>...
> 
>>You can change the color of the text dynamically in FileMaker Pro 7...is
>>that what you are using, or are you on v6?
>>
>>CDMK
>>
>>

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 883-2846
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance