Conditional Value lists may be the most asked about piece of functionality on the FileMaker Cafe. To try and provide a thorough and easy to follow explanation of what they are and how they work, I decided to write an article on the subject and build a small example file to help illustrate the technique…

You may have noticed a lack of article postings over the last couple of months, and fewer articles overall this year. Please don't panic for it has not been through laziness or lack of content. Instead, I have been somewhat pre-occupied with other things that I would like to share with you now?

One of the cool things that conditional formatting has allowed us to do ever since its introduction in FileMaker 9 is to build inline field labels that become hidden when the field contains text. With the introduction of field state formatting in FileMaker 12, we can take these inline labels even further and make them even more awesome?

A grey fill on the active portal row. For years it has been something that simply 'was'. Well no longer. In FileMaker 13 we can finally easily eliminate this rather annoying design feature, and take back full control of portal fill colours.

We've just built our first solution for the iPad, a "Farm Diary" which allows a farmer to work from a map of the farm...

Continuing the onward and upward march was the recent release of FileMaker 11, featuring some very nice charting capabilities, and a raft of developer and user improvements.