Jump to content

Change Field Color based on Value list Text (example) RH -Green Field


Judy Brown
 Share

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

Recommended Posts

  • Newbies

I work for a Performing & Visual Arts School for the Disabled.

Some cannot read so we use color dots & initials (RH,ST)instead of numbers on a name tag to indicate which classroom they are to go to (10 classes per week.

How can I: 1)Change the color of a field by using a Value List.

2)Make the field look like a colored dot.

Can you help? Thanks

Link to comment
Share on other sites

There are a few ways to do this. Basically, you create your colored dots or any other graphic that you want, and paste them into container fields. If you have ten different colored dots, you can paste them into 10 different global fields, and then use a calculated field (with a container result) using a case function to pick the right one like this:

case(

MyData = 0,gBlack,

MyData = 1,gBrown,

MyData = 2,gRed,

MyData = 3,gOrange,

MyData = 4,gYellow,

MyData = 5,gGreen,

MyData = 6,gBlue,

MyData = 7,gViolet,

MyData = 8,gGrey,

gWhite)

where gBlack, gBrown, etc. are the global conainer fields where you pasted the dots.

Link to comment
Share on other sites

  • Newbies

Hi Bob, Will I need to make 10 calculated fields to display all the color dots for each student? I am really green and still so much to learn. The dots on the name tags Mon AM & PM, Tues AM & PM, Wed AM & PM, etc for each student will correspond with the location of the classes the student takes.

Link to comment
Share on other sites

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