Jump to content

Colour changing


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

Recommended Posts

Then you need a new calculation field for every color and for every colorchanging field. Make them transparent, format the text with the colour you need and place it above the original field. The calculation would be something like, for example for the red one: Case( field=Red; field;""). The fields will only show, if there's text in it, will say if the equation turns true.

Link to comment
Share on other sites

Hi Simon,

If I understand you correctly, here are some example files of what you are wanting to do. Three of which are available here in the Forum.

"Colored Fields" By John Mark Osborne Available At

http://www.databasepros.com

"Color Calc" By Don Wieland Available At

http://www.dwdataconcepts.com

"Color Menus" By Aschol Available At

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=47663

"background Color" By CobaltSky aka Ray J. Cologon Available At

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=48837

"Field Background Color Change" By Chopper aka Robert T. Schaub Available At

http://www.fmforums.com/threads/showflat.php?Cat=&Board=files&Number=85619

HTH

Lee

smile.gif

Link to comment
Share on other sites

  • 4 weeks later...
  • Newbies

Hi

I am an unexperienced user of FileMaker Pro 6

Using Case I want to show the words for 'Distinction','Merit','Pass','Fail' in different colours.

Fail - Red

Pass - Green

Merit - Blue

Distinction - Orange

Pryesh

smile.gif

Link to comment
Share on other sites

Hi Pryesh,

If I'm understanding you correctly, you want your calulation field, to be populated based on the data in another field.

To start with, make sure your first field is text. For the purpose my explaination, I'll call it FieldA, and I would attach a value list to it with your action words of:

Fail

Pass

Merit

Distinction

Create your calculation field, I'll call it Field B here

FieldB, a Calculation, with a Text Result =

Case(FieldA="Fail", "Red",

FieldA = "Pass", "Green",

FieldA = "Merit", "Blue",

FieldA = "Distinction", "Orange")

If this isn't what you had in mind, come back and let me know.

HTH

Lee

cool.gif

Link to comment
Share on other sites

This topic is 6417 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
 Share

×
×
  • Create New...

Important Information

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