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.
Part 2: What Should You Consider When Selecting a Development Partner? What Questions Might You Ask a Potential Developer?
Hiring a developer is about creating a working relationship. You want someone who gets your business and gets you. Having a good working relationship often determines the success or failure of a development project. Hire someone you are comfortable with who also has the skills necessary to make your project successful. Beyond the quality of the working relationsh
WidgetStudio makes it easy to use, design and share powerful interface widgets, like calendars, gauges, charts, and timers. Pick from the constantly growing set of included widgets or build your own. Freely share them with your customers or friends.
The post Announcing WidgetStudio – FileMaker WebViewer Widgets appeared first on Geist Interactive.
View the full article
[ 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
Hierarchical JSON Viewer / Editor
By Andy Persons & Doug West
One of the standout new features of FileMaker Pro 16 is native support for the JSON data-interchange format. In addition to providing easy integration with a host of online services, it also provides developers with the tools to create robust hierarchical structures for use entirely within FileMaker. This hierarchical JSON viewer / editor file provides some tools for visualizing, manipulating, and leveraging JSON text.
Features
Michael Layne from Gearbox Solutions presents on FileMaker’s new JSON functions. He does a deep dive into FileMaker’s new JSON functions and demos several examples of how they are using JSON for passing parameters, populating form data, validation and rollback, managing session info such as value lists as global. Michael also demos REST client and REST server with new data API.
The post FileMaker JSON, REST, and the Data API appeared first on Blue Feather - FileMaker Developer, Android, We
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>
<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
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
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
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>
<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
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
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
“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
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>
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
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::
Jason’s swapping out the results portal in our free SQL Explorer with a webviewer so he can take advantage of column resizing and other UI goodies you just don’t see in FileMaker. The second part of the video shows how he lets users easily swap out the styles used in the “portal” as their layouts change.
HTML5 in FileMaker apps. Yummy.
<a href="http://seedcodenext.wordpress.com/2013/05/01/webvier-portals-preview-of-sql-explorer-next/">Source</a>
Todd and I have been working on some changes to GoZync, and the latest build offers a substantially faster sync down from hosted files.
In one test, pulling 5,000 new contacts went from 12:52 to 2:00 minutes flat. (Times will be longer on mobile and over shaky connections.) This is a big improvement.
Add this to Your Deployment
Needless to say, we recommend this for all users: only 4 scripts were changed so updating existing deployments is easy, though you will need to distribute new copies o
Heard very good things about this program for onboarding new developers. New cohort starting in June: http://thorsenconsulting.com/filemaker-virtual-training-program-jump-start-your-career-as-a-developer/
FileMaker’s answer to: https://www.codefellows.org/#bootcamps
Molly: Thorsen Consulting
<a href="http://seedcodenext.wordpress.com/2013/04/25/filemaker-training/">Source</a>
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>
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
<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
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
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
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
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
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>
