This is Part 2 on Kevin Franks presentation at Pause on Error recently: A recurring theme, as we saw in part 1 and will see again today here in part 2, is that you can store “runtime code” as data. The most extreme example I’ve encountered is a proof of concept created and presented by […]
I ‘m not sure where to start with this new post by Kevin Frank: The overall goal of the presentation was to explore various ways one might move business or presentation logic out of its normal location in the schema layer, and into either a) the data layer, or b) some other, non-standard, schematic realm. […]
AS MOST OF YOU KNOW, FileMaker Pro does a pretty good job making pdf’s, either a single output job from a single layout, or stringing several output jobs together from several layouts and producing a single pdf document at the end. Easy enough. Kevin Frank at FileMakerHacks had a more challenging problem: But what if you have […]
I’LL ADMIT IT: I haven’t done much translating to and from Unicode. Kevin Franks has, and with an assist from Jeremy Bante, put together a FileMaker utility file with all of the conversions. This weekend I threw together a Unicode utility file (unicode-characters.zip). It takes the values 1 through 65535 and converts them into Unicode symbols, […]
LISTS are powerful tools for FileMaker developers. FileMaker 13 has a new Summary List Field that allows for easily pulling list values from found sets. A summary field cannot be used to set up a relationship, but a calculated field referencing the summary field can. Check out how Kevin Frank make use of this ability: Follow […]
KEVIN FRANKS extends his excellent series of posts on virtual lists – this time showing how to displays 3 columns of the same data in browse mode: Recently a question came up on the FMP Experts list re: the possibility of displaying a found set of customers in 3 columns in browse mode in FileMaker […]
Normalizing check box data. Part 2 of Magic Key By Kevin Frank I ended yesterday’s article promising a couple improvements on the techniques showcased therein. To avoid unnecessary repetition I am going to assume you have read it. The first improvement is to eliminate the highlighted steps in the “parse current field” script. Is it really possible […]
A handy way from Kevin Frank to normalize data stored in check box sets. Today we’re going to look at a technique called Magic Key, which allows you to flexibly create and populate related records. I believe that the name originates with European developer Ugo Di Luca, and we’ll get to the details in a moment, […]
Kevin Franks blog is must read, especially if your are using (or trying to use) Execute(SQL)… Outer Joins in FileMaker 12, part 1 Posted on October 2, 2012 by Kevin Frank Print PDF Recently I had an on-screen reporting challenge, and decided to try several different approaches to see which would be fastest. The challenge: Starting with two tables, […]
PDF Catalog with Table of Contents Posted on July 13, 2013 by Kevin Frank Print PDF Recently I was asked by a client whether we could produce a PDF catalog from his company’s database, with products grouped by manufacturer. Me: “Of course, this is FileMaker.” Him: “Can it have a table of contents?” Me: “Yeah, […]
Great blog post – Kevin Frank always amazes… Conditional Subsummary Report in Browse Mode Posted on September 22, 2013 by Kevin Frank Last time we looked at several summary reporting tricks, including a conditional subsummary when an item’s Status is “Scheduled” it will have a value in the Substatus field — otherwise Substatus will be […]
Business Minute 22 - Above and Below the Line Thinking - FileMaker Pro Gurus: [...] Conditional Subsummaries in Browse Mode (FileMaker) [...]
Business Minute 23 - Destroy Your Comfort Zone - FileMaker Pro Gurus: [...] Make a PDF Table of Contents – FileMaker [...]