Trick

A Quick and Dirty FileMaker SQL Query Screen

A Quick and Dirty FileMaker SQL Query Screen

ALWAYS BE ON THE LOOKOUT for simple, effective tricks.  Larry Keyes describes one such trick for building a quick and dirty FileMaker SQL Query Screen. Note that this isn’t a full-blown SQL implementation, it will only respond to SELECT statements. (You can’t INSERT or DELETE, for example.   Also, if there any problems with your(…)

Added Security – Auto Close a FileMaker Pro Database

Added Security – Auto Close a FileMaker Pro Database

WORRIED ABOUT SENSITIVE DATA?  Leaving your database open leaves your data exposed.  Doug Alder has a simple to implement work-around:  Use a FileMaker script step to close the database after a specified time period.  Details and examples at the link. Auto Close a FileMaker Pro Database After a Set Interval Using an OnTimer Script Step(…)

Quickly Open Networked Files in FileMaker Pro

Quickly Open Networked Files in FileMaker Pro

I have use the shortcut/alias method without problems for years.  If FileMaker is not recommending it, it likely means some change in the protocol that will break the shortcut/alias method is in the offing.  I wonder when? Guests should open hosted databases by choosing Open Remote from the File menu and then selecting the file from(…)

Auto-highlight a new portal row using conditional formatting and an onTimer script | The Philadelphia FileMaker User Group

Auto-highlight a new portal row using conditional formatting and an onTimer script | The Philadelphia FileMaker User Group

Auto-highlight a new portal row using conditional formatting and an onTimer script Published on November 13, 2013. 0 Comments When you’re building a robust FileMaker solution, you might find yourself in a situation where you want to control additions to a portal row via a scripted process rather than by using the “Allow creation of records in this(…)

Respect the Inspector – The Philadelphia FileMaker User Group

Respect the Inspector – The Philadelphia FileMaker User Group

Respect the Inspector – What to try if a Pop-Up Menu appears blank Published on November 13, 2013. 0 Comments Recently I was tasked with converting an existing FileMaker 11 solution to FileMaker 12.  As is often the case, the conversion was quick and painless and the solution just plain worked as expected in FileMaker 12.  However, I(…)