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.
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
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
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
I think this quote finally gets at what bugs me about so many FileMaker feature requests–the long lists of things that would somehow make one’s life as a developer easier:
Programmers are obsessed with ease rather than simplicity (thank you Rich Hickey for making this point); or, what t
he experience of programming is
instead of what
the resulting program is like
. This leads to useless conversations about semicolons and whether we need a preprocessor that eliminates curly braces. We sti
Follow-up to the recent 'FileMaker Training Series: FileMaker Server' Web Seminar
On Tuesday, October 16th, 2012 I delivered two web seminars for FileMaker Inc. to complete their three-part series on the FileMaker Training Series for FileMaker 12.
This post is my follow-up to that event, and includes links to resources I mentioned during that event, as well as a few relevant Questions & Answers I fielded via email afterwards.
If YOU have any questions that did not get answere
FM Academy Webinar - IT Solutions: Working With and Extending FileMaker 12 Starter Solutions
Join Us Thursday, October 25th for a free one-hour webinar at 2pm (EST) / 1pm (CST) / 11am (PST). The topic is, working with and extending the FileMaker 12 starter solutions, hosted by Jerry Salem at IT Solutions. Register here.
FileMaker 12 includes a whole new set of starter solutions built from the ground up for the new version of the product. They are beautifully styled using the new th
There seem to be many questions about the usage of SQL (Structured Query Language) with the ExecuteSQL function in FileMaker 12. This tutorial attempts to explain some of the SQL terms, if you are new to writing SQL statements. Since there are already many examples of how to write the ExecuteSQL queries, links to these [...]
Source
FileMaker does most of its processing client side. That means when a client wants to do a find, or show the result of a calculation, the data necessary to do the action is transferred from the server to the client and the client calculates the result. This is handy because you don’t need super powerful [...]
Source
FileMaker does most of its processing client side. That means when a client wants to do a find, or show the result of a calculation, the data necessary to do the action is transferred from the server to the client and the client calculates the result. This is handy because you don’t need super powerful servers and the amount of load put on the server itself is reduced. But there’s a tradeoff, in some circumstances, it can also be extraordinarily painful. If a lot of data needs to be moved, the t
FileMaker does most of its processing client side. That means when a client wants to do a find, or show the result of a calculation, the data necessary to do the action is transferred from the server to the client and the client calculates the result. This is handy because you don’t need super powerful servers and the amount of load put on the server itself is reduced. But there’s a tradeoff, in some circumstances, it can also be extraordinarily painful. If a lot of data needs to be moved, the t
Last week in part 1 we looked at four “outer join” reporting approaches. Two of them involved ExecuteSQL, and I ended that section with the plea: Of course it’s possible that you, dear reader, know some FileMaker SQL voodoo to speed things up, and would be willing to share? Well Dr. Osamu Noda of Japan [...]
Source
Join Mark Richman For This FileMaker Web Event
FileMaker Training Series: FileMaker Server
On Tuesday, October 16th, FileMaker invites you to “FileMaker Server,” the last session in a three part webinar series based on the new FileMaker Training Series for FileMaker 12. The webinar is from 8am - 9am (PST) / 10am - 11am (CST) / 11am - 12pm (EST).
read more
Source
Some common themes are emerging from a number of GoZync deployments we’ve completed recently, and one of them is that folks need their sync to be modular. Even in one-task applications there isn’t just one kind of record being synced, or one sync environment. Here is what we’re seeing recently…
• Not all data has the same timeliness. In our construction inspection app inspectors need to get the textual data from the inspection back to the office immediately (so builders’ checks can be cut) but
Like a crazy hoarder I mistake the root cause of my growing mountain of incomplete work. The hoarder thinks he has a storage problem when he really has a ‘throwing things away problem’. I say I am ‘time poor’ as if the problem is that poor me is given only 24 hours in a day. It’s more accurate to say… what exactly?
…from here.
Source
Eliminate Double Data Entry
There are two things you can do in business to improve profits: increase top line revenue and cut costs.
Opportunities to increase top line revenue can be elusive, and often depend on forces outside your control. Preventing your staff from entering data two, three or even four times – on the other hand – is a prime opportunity to cut costs.
read more
Source
Recently I had an on-screen reporting challenge, and decided to try several different approaches to see which would be fastest. Starting with two tables: one containing 20 Employees, and the other containing 2,000 Sales Data records for the current year… …display daily sales totals per employee in a seven-day grid, like so: Of course, as [...]
Source
Doug Alder of HomeBase Software out of Vancouver, BC posted an excellent explanation of locking down an iOS device to use an FM Go database in “Kiosk” mode, using the Accessibility options. While you’re there, check out his FileMaker Timeline (which isn’t working in Chrome for me, but in Firefox it looks great).
Source
Doug Alder of HomeBase Software out of Vancouver, BC posted an excellent explanation of locking down an iOS device to use an FM Go database in “Kiosk” mode, using the Accessibility options. While you’re there, check out his FileMaker Timeline (which isn’t working in Chrome for me, but in Firefox it looks great).
<a href="http://wingforward.net/running-an-ipad-database-as-a-kiosk" rel='nofollow external'>Source</a>
Doug Alder of HomeBase Software out of Vancouver, BC posted an excellent explanation of locking down an iOS device to use an FM Go database in “Kiosk” mode, using the Accessibility options. While you’re there, check out his FileMaker Timeline (which isn’t working in Chrome for me, but in Firefox it looks great).
View the full article
Doug Alder of HomeBase Software out of Vancouver, BC posted an excellent explanation of locking down an iOS device to use an FM Go database in “Kiosk” mode, using the Accessibility options. While you’re there, check out his FileMaker Timeline (which isn’t working in Chrome for me, but in Firefox it looks great).
View the full article
Filemaker 12 has now been out for a few months and we have had a chance to use all the new features in anger. But which is the stand out improvement to FileMaker The new themes allow you to create a reasonable looking system very quickly and then at the touch of a menu item...
Source
New! FileMaker iOS Technology Usage Guide
With our broad experience creating advanced database solutions, we agree that the FileMaker Platform provides application developers an unprecedented opportunity for rapidly creating mobile apps that integrate seamlessly with iOS technology components to provide the best iOS experience possible.
Mark's most recent collaboration with FileMaker, the How To Guide – Best practices for using iOS Technology in custom app development with FileMaker Pro
Have you ever wanted to export a single field and maintain all the characters in that field? This article explores the possibility with XML Export and the use of a simple XSLT. But first we’ll explain the good, the bad and the ugly of some different standard ways to export TEXT out of FileMaker. Using [...]
Source
The question on one or more of the FileMaker forums was asked and answered. Q: How do you get the Count() of the related records in a filtered portal? A: (paraphrased) duplicate the filtered portal and make it one row in height. Place the related summary field, “Count of…”, in the single row filtered portal. [...]
Source
FileMaker Server 12 BackUps Frequently Asked Questions
FileMaker® Server 12 has a number of new features for creating backups of databases it hosts.
As evidenced by questions raised at the 2012 DevCon and as evidenced by a number of items posted on various FileMaker lists, there is a good deal of confusion still about how the new backup system works.
Wim Decorte and I have authored a short set of Frequently Asked Questions along with their answers about this topic. You can downloa
