Dragging objects on a layout

Here’s a quick one, y’all.

When you’re moving layout objects around, how often do you want them to stay on the exact same horizontal line, or the exact same vertical line? For me, that’s almost all the time. (more…)

Things the Format Painter doesn’t “paint”

I’m just going through a database I created a couple years ago. The client wanted me to integrate a new “look and feel” into the database.

They’re a graphic design firm, and their production manager mocked up a few screens for me to follow. It looks amazing!

Anyhow, as a result, I’m making changes to a few things, and loving the format painter. (more…)

Create your own status area

Remember back in the days before FileMaker Pro 10? It wasn’t so long ago. We had a status area at the left side of the window, and lo, it was good.

… but it had some wasted space. (more…)

Default fonts and styles in Layout Mode

Has this happened to you? You need a new field on your layout. You use the Field Tool from the Status Toolbar to drag a new field to the right spot. When you drop the field where you want it, it is in some bizarre font, with weird styles.

Happens all the time in these parts, stranger … and there are three things you can do about it:

(more…)

Hidden portal trick: conditional field

Hey y’all. As I mentioned in my July 18 post about conditional checkmarks, there are multiple ways of having things appear on the layout conditionally. We’ll look at one that is commonly referred to as the “hidden portal trick”. (more…)

Screenshots from FileMaker Go

There has been a lot of talk on the various FileMaker forums about how we can do demos on our laptops and projectors for FileMaker Go, without having to make people huddle around our iPhones/iPads. (more…)

FileMaker Go is here!

All right, so it’s been almost a week, and I still haven’t posted about FileMaker’s new product. I’ve been busy, okay?

Busy figuring out how to use the coolest product ever!

FileMaker Go is a new iPhone, iPod Touch, iPad app that you can use to either run standalone FileMaker databases, or access databases being hosted by FileMaker Server. (more…)

User-specific colour

I was showing a prospective client some samples of my work a couple days ago. She liked what she was seeing except for one thing. “Can you get rid of all that white background; I can’t see a thing!”

First of all, I gave an inner wince, because I like my white backgrounds (assuming I have put a small bit of colour elsewhere). I’ve found that once clients ask for things like this, the database is well on the way to looking like Clown Puke, as described in my post on May 26, 2010.

… and that’s a slippery slope, friend.

However, I just had new business cards printed that list my title as “FileMaker Database Superhero” (seriously!), so I don’t like to leave a citizen in distress. (more…)

Text-based conditional checkmark

On a layout, a client wanted a checkmark to indicate when a required field is filled in. Trying to come up with the leanest solution possible, I knew I had the following options:

  1. Have a calculation field that fills in a FileMaker checkbox when the condition is true.
  2. Have a calculation field that grabs an icon from a one-record table (or global field) when the condition is true.
  3. The invisible portal trick.
  4. An invisible tab that holds the check mark graphic, and script triggers that make sure the tab is only visible when it is supposed to be.

(more…)

Taming a wild layout — A summary of what was done

All right, then. The wild layout has been house-broken. This is just a quick post to show the various iterations of the layout, from its wild infancy, to its charming and debonair adulthood.

(more…)