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.
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
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
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
FileMaker offers many different options for charting, but if you need a chart that is not available in FileMaker, you should consider using Google Charts. Google Charts is a free Javascript framework that can be used in conjunction with web viewers in FileMaker to extend your charting capabilities: https://dbservices.com/articles/google-charts-in-filemaker/
dbservices.com
Hi all,
Today I'm happy to announce the release of Elemental for FileMaker. This is a free fully unlocked solution containing some cool user interface and design stuff that I hope you find useful and can incorporate into your own solutions.
You can grab a copy now at https://www.elemental-fm.com
In Elementals first version you'll find the following:
Avatars
Over 20 API integrations with avatar generators. These are uniquely generated based on a name y
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
