AnsweredAssumed Answered

Make all empty fields a certain color

Question asked by RobRhodes on Oct 19, 2013
Latest reply on Oct 19, 2013 by RobRhodes
  • Comment • 2

Title

Make all empty fields a certain color

Post

     Hi,

     I have a database where I would like to make all my fields yellow when they are empty, and when I enter a value, I'd like the field to go back to white. Specifically, this is on one layout of the database. I'm currently trying to build a mobile version of my database that I use on an iPod Touch.

     Is there a way to do this for every field in my database?

     The idea is to be able to easily spot an empty field by having it be a bright color, and when it is filled in, it would go back to having a white background.

      

     FileMaker Pro  Advanced 12

Jade
Jade Oct 19, 2013 12:23 PM
Correct Answer

     Hi Rob,

      

     In layout mode, select the fields and choose Conditional… from the Format menu.

     Add the formula:  IsEmpty(self)

     Set the fill colour to yellow.

See the reply in context
No one else had this question

Outcomes

    Visibility: Discussions41 Views
    Last modified on Oct 19, 2013 12:00 PM