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.
Author’s note: Inevitable comparisons will be drawn between the new While function and the venerable CustomList custom function, which I wrote about at length several years ago. Preliminary testing indicates that CustomList is faster under certain circumstances and While is faster under others. In my opinion, both of them belong in your developer tool kit. […]
View the full article
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
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
GoDraw3 is a FileMaker drawing tool for users. For FileMaker developers, however, it is full of customization. A developer can do with it what she wants.
The post GoDraw3: Hack the Heck Out of It appeared first on Geist Interactive.
View the full article
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>
Working on a GoZync integration with Jason this morning and remembered this troubleshooting trick Todd and I came up with. This lets you quickly find where a given operation happens in GoZync scripts. (Worth a quick watch.)
<a href="http://seedcodenext.wordpress.com/2013/02/01/tip-debugging-using-gozyncs-logs/">Source</a>
We’ve added a new article to the GoZync docs describing how to turn off the automatic deletion of mobile records that no longer match the users’ pull criteria.
For users pulling very large found sets, this can radically speed up pulls down to their mobile device.
The article describes scenarios where this would help, and walks users though the (very simple) mods required. Again, thanks to Todd’s clean code, this can be as simple as changing a single line. (We should make a collection of our fa
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
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
Unskilled and Unaware
Nearly fourteen years ago two Cornell University psychologists authored a definitive study titled Unskilled and Unaware of It. Their core thesis was that persons who were unskilled in any number of domains suffered a dual burden. They reach erroneous conclusions and make incorrect and unfortunate choices on the one hand. And second, their lack of knowledge and competence robs them of the ability to recognize their errors. They are incorrect; yet, they believe that they
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
How I got a list with data from MySQL in less than 1 second with a SQL VIEW - from an awful 20-25 seconds when going through relationships between multiple tables from the MySQL database.
My Filemaker solution is integrated with a MySQL database that has been highly normalized for different reasons.
This means that a simple list with 4 different fields can easily contain info from 4 different tables, where a couple of the relationships might span 3 tables. This made the performance in FM
<p><a href="/blog/lemonade-stand-part-1-forecasting-and-trend-lines"><br /><h1>LEMONADE STAND, PART 1: FORECASTING AND TREND LINES</h1>
<p></p></a></p>
<p>Sometimes as software developers we get caught up in the details of collecting, storing, and displaying data. To our clients, this is rarely the ultimate goal. Our clients want to use data to make better decisions that will increase profits, utilize resources more efficiently, and
<p>In our last few <a href="http://www.gozync.com" target="_blank">GoZync</a> deployments we’ve noticed folks frequently need to pull some related data down to the mobile file, but don’t want (or need) to sync the whole related table. Let’s say you want to get a customer’s credit limit on your iPhone but don’t want to sync the (massive) invoices table that is needed to calculate it. </p>
<p><img class="aligncenter size-full wp-image-876" alt="calc" src="http://
<p><a href="/blog/filemaker-training-wherever-you-are-in-2013"><br /><h1>Skeleton Key - FileMaker Training: Wherever You Are in 2013</h1></a></p>
<p><a href="http://www.skeletonkey.com/images/Blog/virtual-classroom.jpg" align="right"><img width="400" height="320" src="http://www.skeletonkey.com/images/Blog/virtual-classroom.jpg" /><br /></a></p>
<p>Skeleton Key will kick off its 2013 FileMaker online training
<h3>The first of a series of small templates built around GoZync.</h3>
<p><a href="http://www.seedcode.com/timezync" target="_blank">TimeZync</a> has finally shipped.</p>
<p>Most firms have a very hard time capturing billable time and TimeZync can help. It may be the fastest way to log time into a FileMaker solution. And it works offline, so folks can enter time wherever, whenever.</p>
<p>Here is an <a href="http://www.youtube.com/wa
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
<p><a href="/blog/follow-up-filemaker-academy-webinar-filemaker-server-beyond-the-admin-console"><br /><h1>Follow Up to FM Academy Webinar - FileMaker Server - Beyond the Admin Console</h1>
<p></p></a></p>
<p>On November 15th, <a href="http://www.skeletonkey.com/Alan_Kirtlink">Alan Kirtlink</a> at <a href="http://www.skeletonkey.com">Skeleton Key</a>, hosted FM Academy's webinar where he showed participants h
One of the cool things that conditional formatting has allowed us to do ever since its introduction in FileMaker 9 is to build inline field labels that become hidden when the field contains text. With the introduction of field state formatting in FileMaker 12, we can take these inline labels even further and make them even more awesome.
http://www.teamdf.com/weetbicks/even-cooler-inline-labels/200/]click to read the full article…
With the release of FileMaker 12 FileMaker has made FileMaker Go free. The reduction in cost makes Go the best product for rapid application development for iOS devices. While using Go within an all FileMaker network with good wireless is trivial its more difficult to use Go as a front end to a SQL Server...
Source
<p><a href="/blog/filemaker-academy-webinar-building-a-power-business-solution-on-a-budget"><br /><h1>FM Academy Webinar - Kyo Logic: Building a Power Business Solution on a Budget</h1>
<p></p></a></p>
<p><a href="http://www.skeletonkey.com/images/Blog/FMA_BizBudget.jpg" align="right"><img width="130" height="200" src="http://www.skeletonkey.com/images/Blog/FMA_BizBudget.jpg" /><br /></a></p>
<p>
Part II will include a custom function to create your URL, an example of a feeder script to manage the process, and an explanation of why the Guest account is necessary.
In Part I of this series, I explained how to trigger a server-side script using XML. In this part, I’m going to give you a custom function to aid this process and explain why you need to enable the Guest account.
First, the Guest account. To access the XML engine on the FileMaker Server by a browser, a user will always be take
Part II will include a custom function to create your URL, an example of a feeder script to manage the process, and an explanation of why the Guest account is necessary.
In Part I of this series, I explained how to trigger a server-side script using XML. In this part, I’m going to give you a custom function to aid this process and explain why you need to enable the Guest account.
First, the Guest account. To access the XML engine on the FileMaker Server by a browser, a user will always be take
