Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6862 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

Is there any way to add multiple colours to a value list. I am trying to create a list shoing project status (Active, Pending, Inactive, Prospect) and would like to have the colours Green, Yellow, Red and Purple respectively.

To date I have overlaid coloured text over the list but depending on the operating system I have seen it shift plus it would be cleaner if I could do it without the overlay.

I appreciate any help you can provide and am very appreciative that a forum like this exists as I've been using FM from back in the Claris days of version 1 and am now migrating (from scratch) to 8 ... ugghhh

Posted

Dante,

If I understand your question correctly, you should be able to conditionally format the text color for your value list.

Select "OPTIONS" when presented the define fields dialog box.

Select "Calculated Value"

Select "Specify"

Enter the following calculation:

Case ( Status = "Active" ;

TextColor ( Status ; RGB ( 51; 102 ; 51) );

Case ( Status = "Pending" ;

TextColor ( Status ; RGB ( 255 ;255 ; 51) );

Case ( Status = "Inactive" ;

TextColor ( Status ; RGB ( 255 ; 0 ; 0) );

Case ( Status = "Prospect" ;

TextColor ( Status ; RGB ( 102 ; 51 ; 255) );

TextColor ( Status ; RGB ( 10 ; 10 ; 10) )

))))

This should get your green, red, yellow, purple text when the respective value is selected from the valuelist.

In the case that none of these options are selected, the text should be black.

I think I got the RGB colors right.

You can easily find and download an RGB color chart to fix it if I got it wrong.

Hope this helps,

Jarvis

  • Newbies
Posted

Hi Jarvis,

Thank you for the reply. You definitely solved part of my problem which is great; but not all of it. (My fault for being vague).

In my case the Value list is presented as a radio button list and so therefore, before you've selected anything, it's sitting there with the radio buttons to the left and the text to the right. I am wondering if you can make the text to the right different colours before a selection is made?

That said, you have solved something else that I was using an old work around to solve and your method is nice and clean!

Cheers

D.

This topic is 6862 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.