« Newer Entries   •   Older Entries »
April 1st, 2010

My blog celebrates its 1st birthday. One year ago I started with a long post, supposedly leaking early information about FileMaker Pro 10. At that time, the newest version FileMaker Pro 10 was out three months. A couple visitors read my post, got confused, got exited, and finally got it when they read the last line of the post that everything was just an April Fools’ joke.

But was it just a joke? I though about it more as a wish list or an suggestion for new features in FileMaker. Did it helped? At least some visitors had their fun reading the post. And I know, it got the attention at FileMaker Inc. It is up to you to decide, if any of my suggestions were picked up by FileMaker and used as inspiration for the new program. FileMaker Pro 11 is finally there. It offers many new features, many of them have not been on my published wish list (I never wrote about charts).

But some new things were not so far from my suggestions. The new Inspector for example was mentioned in my post – not under the name Inspector of course, but I extended the old Info box to offer the developer better access to change object attributes. And I said something about merge fields and the problem with the long names and therefore over-sized merge objects. FileMaker allows now to use Merge Variables, and these can be as short as a simple “$i”. So, am I responsible for these new features in FileMaker Pro 11? I do not think so. I rather like to think, that some people at FileMaker and I are thinking in the same direction.
Read more …

March 11th, 2010

Okay, everybody looks at the new FileMaker Pro 11 and sees the new features: charts, portal filter, quick find, inspector, snapshot links, cf import, …

But you actual have to work with the new version to discover hidden gems.

I am not talking about unexpected features – these you would find in the FileMaker Help section “New features in FileMaker Pro 11″. I rather talk about these little changes, that get rid of annoying things. Or little things that could make your life easier.

Previous versions had flaws and annoyances, requiring you to create workarounds or avoid certain situations at all – again and again. Finally we got used to it and would not talk about it anymore. “Do not think about it and it might vanish!”

But now I work with FileMaker Pro 11 and I find little gems:
Read more …

Today, 9th March 2010, FileMaker Inc. announced the new FileMaker version 11. There are many new features in Filemaker 11. I like to tell you about some of these features. Enjoy!

FileMaker Charts

The database becomes more colorful! FileMaker Inc. licensed ChartDirector from Advanced Software Engineering and included it into its database. It is now easy to create bar charts (vertical and horizontal), line, area, and pie charts from your data. You can choose between 2D and 3D presentation, solid or shaded colors.

FM11 Chart BarFM11 Chart HorizBarFM11 Chart Line
FM11 Chart Bar2FM11 Chart AreaFM11 Chart Pie
Read more …

November 25th, 2009

Currently I work a lot with the script triggers in FileMaker 10. They are a great tool to create a user-friendly interface. But working so intensively with triggers also reveals some missing features. For example, a script trigger is active all the time. As soon as a trigger event is assigned to a script, it will always fire, whenever the event occurs. But this effect is not always welcome. The script command New Window opens a new window with the current layout. If it has any layout triggers assigned, it will fire and process the related scripts.

Before FileMaker 10, when we were using plug-ins like zippScript, we had the chance to disable the triggers. Something similar I like to see in a future FileMaker version: a way to deactivate triggers. And chip in an effective trigger management:

  • Controlled trigger deactivation (hard- and soft-coded)
  • Trigger logs with information about the trigger event
  • Additional trigger information, e. g. a list of all defined triggers for the current layout (perhaps in the Layout Setup window)
  • Enhanced Script Debugger with more control regarding trigger events, e. g. a ‘Pause on trigger event’ option

Read more …

September 28th, 2009

The basis of each computer operation is binary logic. Zeros and ones are transformed with simple operations into zeros and ones again. FileMaker is hiding its binary roots very successfully. Only now and then the user can catch a glimpse of it. Some custom functions use binary elements, e. g. Get( ActiveModifierKeys ). And of course you can build logical expressions for If and Case functions, using and/or/not operators, but every value is used as a single logical value. Every number different from 0 is taken as the logical value 1 (True). There is no difference between 1 and 999, for FileMaker both values are a logical 1.

Bitwise operation

I need bitwise opertion for my projects. You might run into the same situation, perhaps managing a collection of flags. Each bit represents a flag. To set flags or ready the status of one or more flags requires binary calculations. In that case you have to take whatever FileMaker has to offer and build the missing parts yourself.

I wrote some custom functions to provide basic logical operations: bit.not, bit.and, bit.or, and bit.xor. Two more functions complete the package; bit.isSet for bit testing and bit.bitset to display decimal numbers in their binary representation.
Read more …

« Newer Entries   •   Older Entries »