Author Archive for Chad Sager

Page 2 of 2

Ernest Koe of Proofgroup

I just wanted to thank Ernest Koe @ernestkoe from Proofgroup ( @proofgroup ) for coming out and presenting. Colin will probably have more follow up to come.

I just wanted to let you guys know what Twitter ( wikipedia ) is, if you were wondering what he was asking about at the begining.

 

Tips and Tricks: Arbitrarily Navigating an Array of Fields in FMP 10

To follow up with the presentation from Tuesday night, here is the first of half a dozen or so posts going into more detail on my demo files.

First up, navigating an array of fields in an arbitrary order (as opposed to tab order).

First, a little setup. To make this work you need to give layout object names to all the fields in the array. I just chose array01, array02, etc. so we can do some simple math to find out which object to go to.

Be sure and name and or number all your layout objects.

Be sure and name and or number all your layout objects.

When Filemaker allows us to go to field by name, this solution will be a little more elegant, for now you just need to name the layout objects and your field names can be arbitrary.

More after the jump:

Continue reading ‘Tips and Tricks: Arbitrarily Navigating an Array of Fields in FMP 10′

 

Tips and Tricks: Self Tooltipping Fields in Filemaker 10

(Editor’s Note:  Here’s the first post from Chad.  I’m monkeying with how to display author names in WordPress, but until then, you’ll have to live with a stupid Editor’s Note.)

 

Anyone with the dream of being able to show field comments as the tooltip, there finally is an answer.

In previous versions of Filemaker it was possible to grab the field comments on a layout for a tooltip, but only by hard-coding the name of the field in the tooltip.  This makes managing the tooltip a little cumbersome, you’d have to touch every field and give it an unique tooltip if so inclined.  In that case you might as well manage the text of the tooltip on the layout object. 

You’d need to put:

FieldComment ( Get ( FileName ) ; "Ship_Date" )

A couple of new functions now make this a lot easier, potentially inserting a single tooltip into all fields on all the layouts across your system, and then editing them in a centralized location.  The first is the Self function, introduced in Filemaker 9, and now the GetFieldName () function.

When editing a field definition, you can add comments to the field like so:
Modify Field Comments
 

Then, in layout mode you can select one or more fields and enter this as a tooltip:

 Add Tooltip to Layout

FieldComment ( Get ( FileName ) ; GetFieldName ( Self  ) )

And now when you mouse over the comments appear.

View Tooltip