Welcome To FMForums

Welcome to our community, full of great ideas on developing your FileMaker solutions effectively,
for peer-to-peer support of the FileMaker Platform and related products and services.

Register and join the conversation!

Sign In

or

Sign Up

Blogs

Featured Entries

Hacking Your Own FileMaker Platform Solutions

By Steven H. Blackwell April 7, 2016

Hacking Your Own FileMaker Platform Solutions Should FileMaker Platform developers mount hacking attacks on their own solutions? At first glance, this may seem an odd question. But I believe that the answer is “Yes, we should.” Consider this. As developers we see our solutions from a totally different perspective than Threat Agents see them. Without practicing our own hacking skills, we can become blind to the vulnerabilities a Threat Agent can exploit to compromise the Confidentiality
- 1 comment
- 4,978 views
A Conversation About '2 Factor Authentication'

By Josh Ormond February 8, 2016

[ Edit: 3/16/2016 - With the help of some other people, we have been able to recover, or recreate some of the original images from original thread. ] Security is always a big topic when it involves data, or people, or possessions. Recently, over on the FileMaker Community, there was a very beneficial discussion regarding security. Unfortunately, that discussion was the victim of a necessary action...and was deleted. It was deleted, because the discussion was tied to a video that, as was det
- 1 comment
- 5,123 views

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

May 28, 2013

Skeleton Key's Blog

FMRPC | FileMaker Remote Procedure Call | FM Academy

<p><a href="/blog/FM-Academy-Webinar-FMRPC-Let-the-Server-Do-the-Work"><br /><h1>FM Academy Webinar - FMRPC: Let the Server Do the Work</h1> <p></p></a></p> <p><a href="http://www.skeletonkey.com/images/FMRPC.png" align="right"><img width="150" height="42" src="http://www.skeletonkey.com/images/FMRPC.png" /><br /></a></p> <p>Join us Thursday, June 6th for a free one-hour webinar at 3pm (EST) / 2

Skeleton Key

May 23, 2013

SeedCode

ProMaps: Google Maps for FileMaker Pro

We’ve simplified GoMaps to work on desktop versions of FileMaker Pro solutions and named it ProMaps. The relationship graph got dead simple so you can paste the map right on to your existing layouts. (And the map is scriptable, so once you click on a pin, you can run your own scripts from the property detail within the map.) ProMaps is completely unlocked for you to modify and extend. And if you need both GoMaps and ProMaps, you can save $100 with our Maps Bundle. Download the demo and chec

John Sindelar

May 21, 2013

Surya Kanta Mekap's Blog

Payment Processing on IPad

One of our client wanted us to build a solution for them to process credit cards from a FileMaker application with authorize.net and merchant account gateway. All we wanted to do is to capture the Credit Card data and send it to the iPad filemaker app and then send it to the web-service of the payment gateway. Filemaker API and Payment Gateway: Initially we made the integration using a hosted Filemaker file and PHP server; the processing worked well. Below are steps explaining the

Surya Kanta Mekap

May 16, 2013

FileMaker Hacks

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

May 14, 2013

Skeleton Key's Blog

Reusable Scripts | Toolbox | Sharing Code | Modular FileMaker

<p><a href="/blog/developers-where-do-you-keep-your-tools"><br /><h1>Developers: Where Do You Keep Your Tools?</h1> <p></p></a></p> <p><a href="http://www.skeletonkey.com/images/Blog/ToolBox3.jpg" align="right"><img width="345" height="300" src="http://www.skeletonkey.com/images/Blog/ToolBox3.jpg" /></a></p> <p>I think every developer should create their own toolbox of code snippets to reuse as needed

Skeleton Key

May 8, 2013

eXcelisys' Blog

Perfecting FileMaker Pro Recursion & Virtualization Part 2

A Wrinkle in Timeliness Pt 2 – Perfecting FileMaker Pro Recursion & Virtualization, by Andy Persons of Excelisys Perfecting FileMaker Pro Recursion & Virtualization Part 2 explores the use of recursion and virtualization (through global variables) in solving complex data interconnectivity challenges using FileMaker Pro 12 in a multi-user client-server environment. Using a specific case study of an Excelisys project/client in the medical manufacturing industry, Andy discusses and demons

eXcelisys

May 7, 2013

SeedCode

Modding Live Files with GoZync

Once you distribute offline files to your users, how do you keep making changes, fix bugs, and re-distribute the files without breaking things or ending up with duplicate files on someone’s iPad? GoZync makes this easy, and this short video shows how. It also demonstrates that GoZync can let you recover from schema errors you might introduce when you’re defining fields. You’ll see how we capture errors (like “the field we’re trying to sync is no longer there”) and let you re-play a sync after y

John Sindelar

May 7, 2013

FileMaker Security Blog

The Beginning Of Wisdom

“What's in a name? that which we call a rose,  By any other name would smell as sweet.” —Juliet (Romeo and Juliet, Act II, Scene 2, William Shakespeare)— “The beginning of wisdom is to call things by their proper name.” —Confucius— An entire series of recent studies[1] published by well-known and well renown international security analysis and information industry firms have all made, in slightly varying language, the following key points: Da

Steven H. Blackwell

May 6, 2013

FileMaker Hacks

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

May 3, 2013

Wing Forward Solutions

Interesting quirk for unrelated field reference in field definition

One apparent limitation of using ExSQL() in the separation model is that you can’t use unrelated tables in a field definition. So you’d need to related all your tables to one another. I just discovered that you can bypass that limitation simply by wrapping your statement in a Let() and declaring a variable that includes wrapping a field in the GetFieldName() function. So the expression: Let( field = unrelated::table ; field ) returns an error. However, Let( gfn = GetFieldName ( unrelated::tab

David Jondreau

May 1, 2013

Wing Forward Solutions

I spent some time this weekend doing some old fashioned FileMaker hacking that I’ve always enjoyed (viva La WorkAround Pro). Definitely inspired by Todd Geist’s very cool hyper-list stuff, but he had also reminded me of the problem of ExecuteSQL on the found set, and I’ve heard this as a common feature request. My big take away from Todd’s comments was that the found set is a uniquely powerful thing, so if it could somehow be incorporated into FMSQL, then that would certainly be a potentially

John Sindelar

April 8, 2013

SeedCode

Trailing Carriage Return Removal Method #3,412

So, is this crazy or cool? Let ( [ uid = Get ( UUID ) ] ; Substitute ( $sc_List & uid ; [ ¶ & uid ; "" ] ; [ uid ; "" ] ) ) If UUID is good enough for your primary key, is it good enough for this? <a href="http://seedcodenext.wordpress.com/2013/04/04/trailing-carriage-return-removal-method-3412/">Source</a>

John Sindelar

April 4, 2013