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.
For the first time, DB Services has been ranked #3494 on the annual Inc. 5000 list, which ranks the country’s “fastest-growing innovators” based on overall revenue growth over a three-year period. The Inc. 5000 list has brought attention to America’s growing private businesses since 1982.
DB Services now joins the ranks of other Inc. 5000 list alumni such as Facebook, Zappos, Pandora, and others. DB Services is top ranked FileMaker Platinum Business Alliance Partner on the 2019 Inc. 5000 li
The FileMaker Let function is your tool to make a calculation readable, well formatted and easy to debug. Let us discuss how it can be used.
The post Like a Boss: Let us Discuss the FileMaker Let Function appeared first on Geist Interactive.
View the full article
The FileMaker Script Debugger is powerful. Its features are often overlooked. In this post we examine the buttons that control stepping through a script.
The post Like a Boss: Using the Script Debugger to its Full Potential appeared first on Geist Interactive.
View the full article
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
FileMaker Kanban is the latest tool that offers familiar functionality for users and flexibility for the developer. It offers great functionality and organizes your data visually into lanes and cards.
The post FileMaker Kanban: Organize Your Data 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
