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
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
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
In the past year and a half here at Geist Interactive, I’ve been tasked with some development work that involves connecting to various APIs. I’ve written modules for clients that get definitions, other forms, synonyms and antonyms, hypernyms and hyponyms of a term from the client’s internal dictionary and such public dictionaries such as Oxford […]
The post HTTP Request: I don’t know how, but it works appeared first on Geist Interactive.
View the full article
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
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
First off, a bit of housekeeping: we now have bright, shiny Print and PDF buttons at the top right of every article. They work like a charm, and I appreciate the suggestions from several of you that motivated me to install them. Well, we’ve reached part 4 in this series that has been going on [...]
Source
<p><a href="http://www.skeletonkey.com/blog/taming-the-filemaker-beast"><br /><h1>Taming the FileMaker Beast</h1>
<p></p></a><br /><a href="http://www.skeletonkey.com/images/Blog/hulkmoviewide_480_poster.jpg"><img width="275" height="138" src="http://www.skeletonkey.com/images/Blog/hulkmoviewide_480_poster.jpg" /><br /></a></p>
<p>I'm running into this scenario a lot lately. I think it's because FileMak
ST. LOUIS, Missouri -November 30, 2012- Skeleton Key, an accomplished team of technology consultants who solve business problems, is pleased to announce the re-branding of their Information Technology division into sister-company, Brightsource IT.
Founded in 2004 with headquarters in St. Louis, Skeleton Key has maintained two successful divisions: Application Development and Information Technology. The Application Development side of the company builds custom-fit business tools and reportin
Recently we’ve been looking at how well FileMaker scales. Typically we need to consider this when faced with large volumes of data or high loads caused by user demands on the system. One of the recent instances where we’ve have to closely examine performance was with a call centre client. The system has a large...
Source
Welcome to the third installment in this series. We’ve been exploring various issues and behaviors in connection with 2-column value lists (VL’s), and today we’re going to look at, and propose a work around for, an issue with filtered value lists in Find mode. All of today’s demo files feature a basic expense submission system, [...]
Source
Just over a week away and Jason’s getting ready for his session at DevCon Tokyo. Big thanks to Shin at fmgateway for the timely translations and local support!
Source