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

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

Recommended Posts

Posted

Mike, the only method I've been able to find to deal with formatting things like color is to create an overlay. Hopefully you are using a trigger field to determine the color and you don't have a huge number of diffent color or field involved, if so this should work.

Say you have a Person's name and you want it to be a certain color based on a status field. Let's say Active=Green, Pending=Yellow, and Inactive=Red. Create three calc fields, one for each of the status colors. Calc would be =If(Status = "Active", Name, "") The Name field would be the field the name was originally entered into. Take each of your calc fields and format them to the color you want, and overlay them over each other. Now when you select a status, or change it in a script, the appropriate color name will appear. I know it a little klugey, but, it does work.

HTH

Posted

The general method of changing the color of field or layout backgrounds is to use a calulated container field. Creating a repeating global container field (gContainer). Copy and paste rectangles filled with the appropriate color into gContainer (copy in Layout mode, paste in Browse mode). Create a calculated background field.

Background (calculation, container) =

Case (

Test 1, GetRepetition(gContainer, 1),

Test 2, GetRepetition(gContainer, 2),

Test 3, GetRepetition(gContainer, 3),

GetRepetition(gContainer, 4)

)

In layout mode place the field "Background" and format it to "Reduce or Enlarge" and uncheck "Maintain Original Proportions" box.

-bd

This topic is 8797 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.