Hi,

I'm new to this group and I was wondering if there is a way in FM 7 to do this:

See we use FM for our daily schedule of jobs we have to do (prepress department). One of the columns in the schedule is for "Technician". Whenever you click on that field for a given job, a list pops up of initials of all of our technicians. Each set of initials is in black. My question is, is there a way to have a default color assigned to each pair of these initials or are we stuck using the default of black. Thanks in advance!

In the dropdown, they all have to be one color, however, once you choose something, you can make it whatever color you want depending on who they chose from the list.

You say the drop down has to be all black, but is there a way to have a certain selection change from black to it's color once selected without having to change the color each time?

As Zero said, the popup list itself can not change, but once it is selected you can use the option of a calculated value text field (not to be confused with calculation field) to achieve the results.

Make sure that you have "Do not replace exisitng value if any..." unchecked.

Case (  Technician = "Bob"; TextColor ( Technician ; RGB ( 255 ; 0; 0 ) );

             Technician = "John"; TextColor ( Technician ; RGB ( 0 ; 255; 0 ) );

             Technician = "Will"; TextColor ( Technician ; RGB ( 0 ; 0; 255 ) );

             TextColor ( Technician ; RGB ( 0 ; 0; 0 ) )

)

Thanks, but where do I type this code in?

When you are defining your text field, there is an option for calculated value. Once you select on it, you can enter the code.

Hi Vodka,

This is clear to me, but I'm not sure that Rydog knows what you mean.

When you are defining your text field, there is an option for calculated value. Once you select on it, you can enter the code.

Steps are:

Go into Define Fields

Select your field

Click on Options

Select Calculated Value

[color:blue] Enter your Calculation

Select Okay Button

Deselect the "Do not replace existing value (if any)"

Okay Button, Okay Button

HTH

Lee

Edited January 4, 200620 yr by Guest

Thanks for all the help guys!