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
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
[ Edit: 3/16/2016 - With the help of some other people, we have been able to recover, or recreate some of the original images from original thread. ]
Security is always a big topic when it involves data, or people, or possessions. Recently, over on the FileMaker Community, there was a very beneficial discussion regarding security. Unfortunately, that discussion was the victim of a necessary action...and was deleted. It was deleted, because the discussion was tied to a video that, as was det
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
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
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
