Jump to content
  • entries
    134
  • comments
    0
  • views
    52,734

Entries in this blog

 

Fast Grid Displays on a WAN

Last October I began a series on Outer Joins, which explored a number of different techniques to display summarized information in a grid, and at the time I concluded that the “fastest” method was to leverage the FileMaker relational model. And it was plenty fast, locally… and not too bad on a LAN… and technically, [...] <a href="http://www.filemakerhacks.com/?p=7924">Source</a>

Kevin Frank

Kevin Frank

 

Radical Separation, part 3

Disclaimer: This article contains speculative and experimental techniques that are in the proof-of-concept stage. Use at your own risk and test thoroughly. Today we’re going to delve further into the concept of virtual calculations, picking up where we left off last time, and with the assumption that readers are familiar with the material in part 1 [...] <a href="http://www.filemakerhacks.com/?p=7759">Source</a>

Kevin Frank

Kevin Frank

 

Radical Separation, part 2

Disclaimer: This article contains speculative and experimental techniques that are in the proof-of-concept stage. Use at your own risk and test thoroughly. In part 1 of this series, we defined radical separation as a separation model scenario in which the developer no longer has access to a data file once a solution had been deployed. [...] <a href="http://www.filemakerhacks.com/?p=7682">Source</a>

Kevin Frank

Kevin Frank

 

Outer Joins in FileMaker 12, part 3

I’ve said before, and no doubt will say again, that one of my favorite things about this blog is how much I learn from your feedback and the demo files you send me. Recently I received a file from Otmar Kramnis of the Hochschule Luzern demonstrating the fastest SQL-based method I have yet seen to [...] <a href="http://www.filemakerhacks.com/?p=7624">Source</a>

Kevin Frank

Kevin Frank

 

Radical Separation, part 1

Disclaimer: This article contains speculative and experimental techniques that are in the proof-of-concept stage. Use at your own risk and test thoroughly. Earlier this month I had the honor and the privilege to do a presentation on the topic of Radical Separation at the PauseOnError un-conference in Portland, Oregon, which included a demo file resembling this [...] <a href="http://www.filemakerhacks.com/?p=7380">Source</a>

Kevin Frank

Kevin Frank

 

Copying and Pasting Layout Schema

Has this ever happened to you? You have a number of identically named fields in two different tables… …but when you copy one of those fields from a layout based on the first table… … and paste it onto a layout based on the second one… …the result is not what you might have wished [...] <a href="http://www.filemakerhacks.com/?p=7353">Source</a>

Kevin Frank

Kevin Frank

 

Fun with Factorials

A while back my youngest son, who is an avid Go player, asked me, “Is it true there are more possible Go games than there are atoms in the universe?” “Absolutely,” I replied, “Let’s fire up FileMaker Pro and prove it.” (I wasn’t about to let a rare teachable moment slip by.) “If memory serves, [...] <a href="http://www.filemakerhacks.com/?p=3756">Source</a>

Kevin Frank

Kevin Frank

 

Graph Management + Conditional Icons

Recently I received a dual-technique FileMaker 12 demo from Eden Morris. Here’s what he had to say about technique #1: In the Relationships Graph I show the use of colored labels to indicate where record creation, cascade deletes, and sorted relationships. Looking at the graph it easily shows that I can create customers from a [...] Source

Kevin Frank

Kevin Frank

 

Privilege Set Reporting

Editor’s note: Today I’m pleased to present a guest article by Michael Rocharde, author of FileMaker & Me, an interactive multimedia book focusing on FileMaker Interface Design. FileMaker has always been an incredible tool for generating reports and for many years, I used to have a report screen with banks of buttons to generate all [...] Source

Kevin Frank

Kevin Frank

 

My Very Own Twitter Impersonator

Dear Reader, There’s an old saying that imitation is the sincerest form of flattery, but having experienced it first hand, I’m not feeling even remotely flattered. Pissed off? Yes. Violated? Yes. But not flattered, and not amused. Here’s the short version: Me: The Impostor: Here’s a longer version (and I hope you’ll read to the [...] Source

Kevin Frank

Kevin Frank

 

ExecuteSQL: Using IN with Faux Dynamic Variables

Editor’s note: Today we have a guest article written by John Weinshel, whose knowledge of SQL in general, and FileMaker+SQL in particular, runs deep. John’s contributions in various online forums are always worth reading, and it’s a privilege to present his thoughts on this topic here. The new ExecuteSQL() function in Filemaker 12 does not [...] Source

Kevin Frank

Kevin Frank

 

Thinking About Value Lists, part 4

First off, a bit of housekeeping: we now have bright, shiny Print and PDF buttons at the top right of every article. They work like a charm, and I appreciate the suggestions from several of you that motivated me to install them. Well, we’ve reached part 4 in this series that has been going on [...] Source

Kevin Frank

Kevin Frank

 

Thinking About Value Lists, part 3

Welcome to the third installment in this series. We’ve been exploring various issues and behaviors in connection with 2-column value lists (VL’s), and today we’re going to look at, and propose a work around for, an issue with filtered value lists in Find mode. All of today’s demo files feature a basic expense submission system, [...] Source

Kevin Frank

Kevin Frank

 

Thinking About Value Lists, part 2

In part 1 we explored a particular type of value list: the field-based two-column variety, based on all values, and set to show values from the second column only… …and today’s article assumes familiarity with that material. This time around we’re going to look at some challenges and issues that can arise when using filtered [...] Source

Kevin Frank

Kevin Frank

 

PDF version of FM 12 ExecuteSQL Reference

Beverly Voth has produced a PDF version of The Missing FM 12 ExecuteSQL Reference with some additional material not available in her original posting from October 19th. And the SQL4_fmdev2.fmp12 demo file has been updated with new queries. Thank you Beverly for this major contribution to the FileMaker community. Source

Kevin Frank

Kevin Frank

 

The Missing FM 12 ExecuteSQL Reference

There seem to be many questions about the usage of SQL (Structured Query Language) with the ExecuteSQL function in FileMaker 12. This tutorial attempts to explain some of the SQL terms, if you are new to writing SQL statements. Since there are already many examples of how to write the ExecuteSQL queries, links to these [...] Source

Kevin Frank

Kevin Frank

 

Outer Joins in FileMaker 12, part 2

Last week in part 1 we looked at four “outer join” reporting approaches. Two of them involved ExecuteSQL, and I ended that section with the plea: Of course it’s possible that you, dear reader, know some FileMaker SQL voodoo to speed things up, and would be willing to share? Well Dr. Osamu Noda of Japan [...] Source

Kevin Frank

Kevin Frank

 

Outer Joins in FileMaker 12

Recently I had an on-screen reporting challenge, and decided to try several different approaches to see which would be fastest. Starting with two tables: one containing 20 Employees, and the other containing 2,000 Sales Data records for the current year… …display daily sales totals per employee in a seven-day grid, like so: Of course, as [...] Source

Kevin Frank

Kevin Frank

 

An In-Depth Look at “Export Field Contents”

Have you ever wanted to export a single field and maintain all the characters in that field? This article explores the possibility with XML Export and the use of a simple XSLT. But first we’ll explain the good, the bad and the ugly of some different standard ways to export TEXT out of FileMaker. Using [...] Source

Kevin Frank

Kevin Frank

 

Aggregates in Filtered Portals

The question on one or more of the FileMaker forums was asked and answered. Q: How do you get the Count() of the related records in a filtered portal? A: (paraphrased) duplicate the filtered portal and make it one row in height. Place the related summary field, “Count of…”, in the single row filtered portal. [...] Source

Kevin Frank

Kevin Frank

 

Thinking About Value Lists, part 1

In July and August we explored several esoteric value list techniques. This time around, and over the next few postings, we’re going to step back from the cutting edge, identify some common value list challenges, and propose some solutions to those challenges. A few thoughts before we begin: Some of the material in this series [...] Source

Kevin Frank

Kevin Frank

 

FileMaker Blogs

Recently a question came up on one of the lists asking about intermediate-to-advanced FileMaker Blogs. Here are some I’m aware of, and I’m sure I’ve missed some good ones, so I apologize in advance for any inadvertent omissions. Cimbura – http://cimbura.com/tech/blog DB Services – http://www.dbservices.com/articles FileMaker ’n’ the Web: Lessons Learned – http://blog.jsfmp.com FileMaker Weetbicks [...] Source

Kevin Frank

Kevin Frank

 

Fixed Width for EDI and Other Reporting

Editor’s note: Today it’s my pleasure to present a guest article written by Beverly Voth. Like many other developers, I have enjoyed and benefitted from her ongoing contributions to the FileMaker community. I do a lot of text manipulation for EDI (Electronic data interchange – http://en.wikipedia.org/wiki/Electronic_data_interchange) and plain text exports with fixed-width field data. Some [...] Source

Kevin Frank

Kevin Frank

 

More Fun with Value Lists, part 2

As promised last time, today we’re going to look at a technique from Dr. Osamu Noda, which uses FM 12′s ExecuteSQL to create what appears to be a value list when in fact there are no value lists defined at all. This technique, like some of the others we’ve seen recently, is decidedly esoteric, but [...] Source

Kevin Frank

Kevin Frank

 

More Fun with Value Lists, part 1

One of the things I love about FileMaker is how many different ways there are to skin the proverbial cat. Following our recent look at “Magic Value Lists“, I received thought-provoking FileMaker 12 demos from John Ahn and Dr. Osamu Noda.  I’m going to save Dr. Noda’s files for next time, but today we have [...] Source

Kevin Frank

Kevin Frank

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.