Jump to content

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

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?

Link to post
Share on other sites
  • Replies 7
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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.

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.

Link to post
Share on other sites

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

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.


×
×
  • Create New...

Important Information

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