Older Entries »
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 …

September 7th, 2009

It is time for a fresh, new look. At first I liked the Carrington Blog theme I used before. But after a couple of months I had more and more problems with it. For example, the comment column becomes very crowded.

I was always looking for a WordPress theme with a liquid design. Columns should adjust with the window size. I found some themes on the Internet, but was not too happy with the overall look. That is why I started to create my own theme. Not knowing to much about the internal structure of WordPress, I started reading and learning the documentation.

Read more …

Older Entries »