Jump to content
Sign in to follow this  
Salesman0Gil

Something Filemaker Can't do

Recommended Posts

I think I finally found something Filemaker can not do..

There are two fields Truck Run and truck Stop

I want to make labels, or make a list layout that will print, that:

1) has each Truck run (there are 8) a different color

2) Within each Truck Run, each Truck Stop a different color (there are 10)

Any ideas?

Share this post


Link to post
Share on other sites

Calculating text color is easier in FM7, but you can do it with FM5. You have to make a calc for each possible color with definable criteria:

TS_ColorBlue = if(Truck Stop = 1,"Truck Stop 1","")

TS_ColorRed = if(Truck Stop = 2,"Truck Stop 2","")

...

Set the color of each field separately, and layer them on top of each other in the layout.

Share this post


Link to post
Share on other sites

Where is the TS_ColorBlue?:

I tried typing it in and got Filemaker can not find the field TS_Color

Share this post


Link to post
Share on other sites

TS_ColorBlue is an example name of one of the new calc fields you will have to create to get this to work. The if() statement is what you would put in that calc.

Share this post


Link to post
Share on other sites

All right I going to be a newbie here.....

if(Truck Stop = 1,"Truck Stop 1","")

Says if the field Truck Stop = 1 then "Truck Stop 1", how does that change the text color???

Share this post


Link to post
Share on other sites

Since you did't post your actual field names or types, I made up Truck Stop. The field color itself doesn't actually change. The overlapping calcs create the illusion of a changing field color.

Share this post


Link to post
Share on other sites

It's cleaner to use Case if you have no alternate result.

Case(Truck Stop = X, "Truck Stop X")

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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