![]() ![]() But if they were to click in the field, those conditional formatting rules apply. This means that during normal browsing the user will see the formats that are specified in our conditional formatting rule. The reason why this highlighting trick works is that the Conditional Formatting does *not* apply to the active field. Your final conditional formatting dialog should look exactly like this: Now we just need to pick what we want to conditional formatting to do, so let’s keep it simple and change the Fill Color to white. This condition tells FileMaker that *when* Conditional Formatting rules apply *always* apply this formatting (Note the when this is the essence of the technique). Now click on the Pop-Up under conditional and select `Formula is` and then type true in the calculation box like so: Once you see the above window, click the add button to add a condition. Select the object and either right click and go to `Conditional Formatting` or go to the Menu `Format > Conditional`. ![]() Next thing we’re going to do is to set the conditional formatting on the object. Apparently it was Chad Novotny who actually came up with this one. He of course is a genius but couldn’t take credit for this one. > Credit where credits due: I first saw this technique at DevCon 2007 demoed by Andy LeCates. Well, just bear with me and I will explain latter. I know, I know, this really doesn’t make much sense because you only want the field to appear yellow when it’s *active*. ![]() The first thing you do is select the field and set the Fill Color to yellow. Let’s say you have a field on your layout that you want to turn yellow whenever it’s active (ie, you click in it, tab to it or have some script that selects it, etc.). I’m going to explain how to do it and then explain why it works. ![]() With the addition of conditional formatting, not only can you highlight the active field but you can make it bold, a different color or perhaps even enlarge the font. Before FileMaker 9, there was no way to fix this for them. One of the common complaints our customers have is that they can’t tell which field they are in when using FileMaker. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |