Archive | June, 2012

A Simple Backup Script, revisited

Posted on June 25, 2012 by

In October 2011 I posted a simple backup script that has made my development life easier, but of course that version was for .fp7 files only (the release of FM 12 being six months in the future), and when I began converting files to FileMaker 12, I realized that the backup script was not intelligently rolling with the changes. So recently I modified the script to accommodate both .fp7 and .fmp12 files, and also to be more flexible with regards to separators within the backup file name, e.g.,

Rather than repeatedly referring the reader back to the earlier article, I have “deprecated” the prior one and reproduced it here with appropriate changes, and have also updated the demo file (see below). Continue Reading →

Dwindling Value Lists, part 2

Posted on June 10, 2012 by

One thing I love about this blog is how much I learn from your comments. Having said at the end of part 1 that I couldn’t think of any serious use for a DVL on a check box set, Michael Rocharde kindly provided this example file (Conditionals), which I am sharing with his permission.

This is one of many example files and techniques available in his new interactive e-book, FileMaker and Me, available for iPad via the iTunes store.

Dwindling Value Lists, part 1

Posted on June 10, 2012 by

A few months ago I mentioned “dwindling value lists” in passing, and said I would do a proper article on them at some point in the future. Well, then FM 12 was released and I went on an ExecuteSQL binge, so I’m just now getting around to honoring my promise.

Dwindling Value Lists (DVLs) are value lists that shrink up, by removing individual list items as they are selected. They can come in very handy when you need to schedule resources and want to prevent double booking. This example comes from one of today’s demo files, Dwindling Value Lists, and shows how a DVL might be used to schedule employees for a work shift.

Essentially, a DVL is a filtered value list that updates in real time (or something very close to real time), and this is done by building a multiline key of selected values, and then filtering the VL to only show remaining eligible values. Continue Reading →