Creating a script to change the font color of an entire row when a field has a certain value

[Educational]

Hello all,

 

I am new at this.  

 

I am creating a database for a photographer and I am attempting to get a font color change across an entire row when a condition is set.

 

Basically, the photographer creates 45 prints of one image.  This is called an edition.  I create a record for each print.  So, 45 records.  I have a status drop down field, where I can set that status to "Unprinted" as well as other things.

 

I want the status to trigger a script? where the font changes across the entire row of the record into a faded grey if set to Unprinted.

 

This way if prints 1-5 are printed they will appear in black.

 

6-45 will appeared faded and will not take attention, since they do not exist yet.

 

Is this possible?

[LaRetta]

Attach conditional formatting to each field in the record.  It would be:

 

Formula is:  Status = "Unprinted"

 

... then below, select your font colour of lighter grey.  There is no need of script at all.

 

Oh!! And welcome to FMForums!!!  :-)

 

BTW, since every field on the layout will want the exact same conditional format, select all your fields and specify the format just a single time.

Edited July 25, 2013 by LaRetta

[Educational]

You. Rock. Thank you!