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
- 6,101 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
- 6,156 views

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

April 17, 2013

SQL and the Found Set, Part 2: RecordID List and Hyperlist

Background: ID Lists I have one thing (at least) to follow up with on my ExecuteSQL using the Found Set post from a little bit back. This was to see if I could get the RecordID parsing optimized (or at least faster) using some of the techniques in Todd’s Hyperlist demo. Although this is not the slow part of the process–feeding the large set of values into the SQL IN clause is the slow part–it still did seem worth pursuing for two reasons: Firs,t to get my head around Hyperlist and the underl

John Sindelar

April 15, 2013

Software Licensing | Conversion | Database Upgrade | Hardware Compatibility

<p><a href="/blog/filemaker-licensing-and-conversion-have-no-fear"><br /><h1>FileMaker Licensing and Conversion: Have No Fear!</h1> <p></p></a></p> <p><a href="http://www.skeletonkey.com/images/Blog/FMConversionimage_open_2x%20copy.jpg" align="right"><img width="300" height="231" src="http://www.skeletonkey.com/images/Blog/FMConversionimage_open_2x%20copy.jpg" /><br /></a></p> <p><i>Does t

Skeleton Key

April 12, 2013

A Wrinkle in Timeliness – Perfecting FileMaker Recursion & Virtualization

A Wrinkle in Timeliness – Perfecting FileMaker Recursion & Virtualization, by Andy Persons of Excelisys A Wrinkle in Timeliness Pt1 of 4 – Perfecting FileMaker Recursion & Virtualization, by Andrew Persons 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

eXcelisys

April 12, 2013

Weave: Calendar overlay by Intuit

Weave is cool little app that begins by reading the event kit data from your iPhone and showing your calendar events in a rough todo list. You can’t do much with these existing events, but you can make new to-do items. And when you go to mark one as “done”, you see the screen at the right. And you can see how Weave can get you to log your time and track your expenses. Pretty cool. Screenshots of weave on the app store show project income and expenses and the tasks completed by others. Now you

John Sindelar

April 9, 2013

Ten Frequently Encountered Practices That Can Compromise Security of FileMaker Pro Files

Ten Frequently Encountered Practices That Can Compromise Security of FileMaker Pro Files April 9th 2013 In our last installment, I noted: “In 2013, I will be focusing on promoting the goal of achieving that understanding [meaning understanding FileMaker Server] along with the parallel and related one of overcoming a similar lack of understanding and awareness about FileMaker security items.” In this post I want to focus on ten frequently encountered practic

Steven H. Blackwell

April 9, 2013

ExecuteSQL using the Found Set?!?…Yes!…well maybe not.

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

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

ESS Connections | Ecosystem | Web Interface | FM Academy

<p><a href="/blog/FM-Academy-Webinar-a-FileMaker-Ecosystem-From-Desk-To-Web-To-Mobile"><br /><h1>FM Academy Webinar - A FileMaker Ecosystem: From Desk to Web to Mobile</h1> <p></p></a></p> <p><a href="http://www.skeletonkey.com/images/Blog/FMAWebAprilImage.jpg" align="right"><img width="200" height="96" src="http://www.skeletonkey.com/images/Blog/FMAWebAprilImage.jpg" /><br /></a></p> <p>Join u

Skeleton Key

April 4, 2013

Professional Development | Stockdale Paradox| Jim Collins | Good to Great

<p><a href="http://www.skeletonkey.com/blog/good-to-great-stockdale-paradox-your-data-all-connected"><br /><h1>Good to Great, Stockdale Paradox, Your Data- They're All Connected</h1> <p></p></a> </p> <p><a href="http://www.skeletonkey.com/images/Blog/Good-to-great.jpg" align="right"><img width="150" height="251" src="http://www.skeletonkey.com/images/Blog/Good-to-great.jpg" /></a></p> <p>As part of ou

Skeleton Key

March 29, 2013

Creating User Specific Reports Using FileMaker Pro Privilege Sets

Creating User Specific Reports Using FileMaker Pro Privilege Sets If you’ve ever wanted to generate specific reports for different groups of users, but are intimidated by FileMaker’s, somewhat complicated security schema, this PDF shows you an alternative methodology that is very simple and easy to implement, using FileMaker Pro privilege sets. Recently a client, a large bail bond company, wanted to be able to add reports easily, that could only be viewed by specific employees, and without h

eXcelisys

March 29, 2013

Fan Mail Friday

Well, that’s what happens when you post things to the wrong blog! =) Internally we try to publish the most effusive comments form the last week’s support cases every Friday–”fan mail friday”–just to let everyone know what their teammates have been up to. We *usually* post this privately: sorry for the interruption. “Happy Friday” everyone. - John <a href="http://seedcodenext.wordpress.com/2013/03/29/fan-mail-friday/">Source</a>

John Sindelar

March 29, 2013

Benefits of ExecuteSQL

Previously in this blog I have discussed the new ExecuteSQL functionality in FileMaker12 and how useful I find this. I would like to share with you one example of how I have used this. I have a client who has a sales system which has a report that shows the position of Accounts for all... <a href="http://feedproxy.google.com/~r/LinearChat/~3/cl7M4wpq9e0/">Source</a>

Paul de Halle

March 27, 2013

FileMaker Sync Case Study: IT Solutions

The developers at IT Solutions just completed a great FileMaker Go project for the Center for Disabilities Studies at the University of Delaware. The solution facilitates in-person evaluations of 100 public schools across the state and replaces a paper system that delayed feedback and analysis of this important information. I can’t express how much FileMaker Go and the app developed by IT Solutions has positively impacted our project. We’re now able to complete evaluations in less time, an

John Sindelar

March 26, 2013

GoZync Customer Solution: RigMan

Beautiful screen shot sent to us by Don Blaylock of Noble Casings… …Don says: I appreciate all your help. The syncing is working awesome! GoZync was central to the success of this and future products!!! Glad to hear it Don; and thanks for the sexy screen shot: love the dimmed “1″ and “2″. <a href="http://seedcodenext.wordpress.com/2013/03/25/gozync-customer-solution-rigman/">Source</a>

John Sindelar

March 25, 2013

Unit Testing for FileMaker

Cool and provocative video by Todd Geist showing how he incorporates unit testing into a new project: Unit Testing in FileMaker. Nice stuff. <a href="http://seedcodenext.wordpress.com/2013/03/23/unit-testing-for-filemaker/">Source</a>

John Sindelar

March 23, 2013

HierarchyLite – FileMaker Pro 12 Tips and Tricks Demo!

HierarchyLite - FileMaker Pro® 12 Tips and Tricks Demo of a Simplified Approach to Hierarchal Portals! Another FREE FileMaker Pro 12 Tips and Tricks Demo file showing an even more simplified approach to hierarchal portals by Doug West, Product/Project manager of Excelisys. Doug has now made this advanced technique, originally developed by our own Andy Persons, even easier! “HierarchyLite” is an EXcellent FREE FileMaker Pro 12 Tips and Tricks demo file which outlines how to create those cool h

eXcelisys

March 22, 2013

Jason Erickson joins Linear Blue

Linear Blue are proud to announce the merger of the SyncDeK & fmDataGuard product suite to our expanding product range. As of April 1, Linear Blue welcomes the WorldSync product suite and its former CEO to join our excellent development team. As one of the foremost Platinum members of the FileMaker Business Alliance, we are... Source

Paul de Halle

March 22, 2013

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

March 22, 2013

FileMaker Sync: what we’ve learned making mobile apps

Overview. We’ve been syncing FileMaker Go solutions since June of 2011 and it now seems like a good time to reflect on what we’ve learned helping folks make mobile apps as well getting the apps they already have debugged, sped up, and syncing. This article will talk about some of the things we think are most important–and maybe counter intuitive–when planning a distributed app. Because that’s the big shift for most of us: we’ve been making networked apps, and now that we’re mobile we’re makin

John Sindelar

March 16, 2013

FileMaker Pro 12 Tips and Tricks, Using ZipTastic Web Service to retrieve City, State, Country.

From Excelisys by Doug West, Product/Project Manager, a Free FileMaker Pro 12 Tip and Trick demo to retrieve City, State, Country with just a Zip code using a web service called Ziptastic. Basic demonstration of accessing a web service called “Ziptastic” from within FileMaker Pro 12 to retrieve City, State, Country with a Zip using the insert from URL script step introduced in FileMaker Pro 12 (no plug-ins!). The web service provides the corresponding city, state, and country for a given ZIP C

eXcelisys

March 15, 2013

Calendar Skin Job

Just got this wild screen shot from Guglielmo Imbimbo. Definitely went to town on the calendar layout: well done! <a href="http://seedcodenext.wordpress.com/2013/03/14/calendar-skin-job/">Source</a>

John Sindelar

March 14, 2013

SQL Subqueries in FileMaker

I’ve had some small pre-FileMaker experience with SQL and had it in my head that subqueries work in the FROM clause. They do in MySQL etc, so I was frustrated when I couldn’t get that to work in FileMaker’s SQL as it’s really needed in some cases. In a current project we have a case where there is a relationship from Contacts to Loans and we wanted to see the Total Loan Amount from the Contact Context. However, they can be associated with that Loan as multiple roles, so we only want to have

John Sindelar

March 13, 2013