2 Replies Latest reply on Oct 19, 2013 12:34 PM by RobRhodes

Make all empty fields a certain color

RobRhodes Oct 19, 2013 12:00 PM

Title

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

1. Re: Make all empty fields a certain color

Jade Oct 19, 2013 12:23 PM (in response to RobRhodes)

     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.
Like Show 0 Likes(0)

Actions
2. Re: Make all empty fields a certain color

RobRhodes Oct 19, 2013 12:34 PM (in response to RobRhodes)

Thank you so much, Jade!

This was so much easier than what I was trying to do! You seriously just saved hours of my life!
Like Show 0 Likes(0)

Actions

Go to original post