Get(UUIDNumber) is here – how does it compare to Get(UUID)?

With the long list of new features being released in FileMaker Pro 17, one item that piqued the interest of my inner geek was this new function:  Get( UUIDNumber ). This new function is useful because now you can store your UUIDs in a Number data-typed field instead of having to use a Text data-typed field.  My hypothesis is that storing Numbers in the database will take up less space in the file. (I’m not sure where I got that notion, but it’s stuck with me for a while now…perhaps it was the Tech specs from an older version, where it described the minimum size needed to store numbers vs. text.)

Read More


June 6th Portland FileMaker Meetup

It was good to see folks again this month, for another meeting at AppWorks command HQ.  (I missed last month’s meeting, unfortunately. I was looking forward to hearing the stories from Pause on Error.)  Here are some of the highlights.

There are big changes in the licensing of FM 17.  AppWorks’ own Shawn Prado has a thorough article covering that topic.  When you purchase a 5-user license you get 3 copies of Server now.  That raised an interesting question: Does this mean you can put one of those on FileMaker Cloud with the BYOL option, instead of buying one through the FM Cloud interface?  It used to be that when you used the BYOL option your server license would get converted to FMCloud and NOT be returnable to standalone server installations at a later date if you moved off the cloud.  This then led to some discussion on hosting and server environments.

Read More


FileMaker 17 New Features From Around The Blogosphere

There’s a lot of buzz about the release of FileMaker 17 out and about, with lots of smart people providing their two cents as to what’s interesting and useful, and describing how to use these new features.  I compiled a list of some insightful articles that I have come across, that I think you will find helpful as a starting point for exploring these new features yourself.

Read More


FileMaker 17: Edit Grouped Objects

How many times have I been annoyed and delayed by having to ungroup something just to make a simple edit? Too many to count.

I often group many things together to aid in layout setup and positioning. Say you have a set of fields and objects that together make up a ‘widget’ or function (e.g. a custom calendar picker, or custom labeling for a radio button set, a set of fields for an address, etc), and you want to keep them all together in a particular arrangement. But then you might have to make a change to a font, or a hide condition, or a small tweak to the position of one item within the group. Now you can do all those adjustments without having to break the group and then re-group the objects when you are done!

Read More