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
As a long time developer of FileMaker solutions, I clearly remember the first time I personally attempted to create a calendar solution. It was not as easy as I'd initially thought. There were a TON of "little things" which you find out about down the road.
Don't get me wrong, the learning experience is well worth it and made me a better developer for sure! But, when it comes to building one natively within FileMaker today, it just doesn't make much sense. That is, unless you really only need t
Disclaimer: the techniques shown in this article are provided on an as-is basis. Use with appropriate caution and at your own risk. Introduction This is a quick follow-up to last month’s article on 2-Column Magic Value Lists, and, to avoid repetition, will assume the reader is familiar with that material. A colleague pointed out that… Continue reading 2-Column Magic Value Lists, part 2
View the full article
Disclaimer: the techniques shown in this article are provided on an as-is basis. Use with appropriate caution and at your own risk. Introduction This is a quick follow-up to last month’s article on 2-Column Magic Value Lists, and, to avoid repetition, will assume the reader is familiar with that material. A colleague pointed out that… Continue reading 2-Column Magic Value Lists, part 2
View the full article
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
Your FileMaker database is obviously designed to store data. FileMaker also provides the tools for precisely extracting that data as needed. When and how you extract the data is based on your needs. Sometimes, you need the data for an external system or API. Maybe it's needed for an export or you need the data specifically for a given visualization of that data.
In a recent video, I showed some Sankey Diagrams and how cool they are as visualization tools. One of keys to presenting a great visua
Your FileMaker database is obviously designed to store data. FileMaker also provides the tools for precisely extracting that data as needed. When and how you extract the data is based on your needs. Sometimes, you need the data for an external system or API. Maybe it's needed for an export or you need the data specifically for a given visualization of that data.
In a recent video, I showed some Sankey Diagrams and how cool they are as visualization tools. One of keys to presenting a great visua
Most people don't think about indexing when designing a solution. FileMaker automatically turns on indexing when needed so why should they? Indexing can only be good, right? I mean, it makes finds faster. Well, in most situations, indexing is nothing to worry about. But, under certain circumstances, indexing can have an adverse effect on your FileMaker file. Let's talk about how indexing works, where it is used and how it can slow down your solution when unchecked.
View the full article
Most people don't think about indexing when designing a solution. FileMaker automatically turns on indexing when needed so why should they? Indexing can only be good, right? I mean, it makes finds faster. Well, in most situations, indexing is nothing to worry about. But, under certain circumstances, indexing can have an adverse effect on your FileMaker file. Let's talk about how indexing works, where it is used and how it can slow down your solution when unchecked.
View the full article
We at Geist Interactive have released a new podcast (well new in the last eight weeks): The Context Podcast.
Our podcast is focused on higher-level discussions of the FileMaker platform. We discuss (and embrace) innovation and technology inside and outside of FileMaker. We talk with guests from all around the community about their thoughts on whatever topic is on deck. We also try to ask the guest their thoughts on the context of certain techniques we use in our projects.
So far we've
Get Your Kicks with the NEW eX-BizTracker 6!
CRM, Inventory, Invoicing & More — the eX-BizTracker Tackles Everything for Your Business’ Core
Years ago, we spotted a trend. Businesses really, really wanted custom software at out-of-the-box prices. We understood the dilemma. The available, off-the-shelf business apps fit most businesses’ budgets, but never fit their needs. So they were stuck. To build or to buy? Build it (at a higher price) and get eXactly what they wanted, or buy so
Get Your Kicks with the NEW eX-BizTracker 6!
CRM, Inventory, Invoicing & More — the eX-BizTracker Tackles Everything for Your Business’ Core
Years ago, we spotted a trend. Businesses really, really wanted custom software at out-of-the-box prices. We understood the dilemma. The available, off-the-shelf business management apps fit most businesses’ budgets, but never fit their needs. So they were stuck. To build or to buy? Build it (at a higher price) and get eXactly what they wanted
[FMP Tip-N-Trick] Don’t Get Thrown for a Loop with FileMaker’s New While Function
Check Out This Custom Function for Merging JSON Arrays
By Rob Poelking, eXcelisys FileMaker Developer
FileMaker Inc. (errr, I mean Claris International) introduced a new function with the release of FileMaker 18 that I was both eXcited and intrigued by until I tried to use it the first time: the “While” function.
I’ve written a number of custom functions through the years and lots of loops in scripting to manag
[FMP Tip-N-Trick] Don’t Get Thrown for a Loop with FileMaker’s New While Function
Check Out This Custom Function for Merging JSON Arrays
By Rob Poelking, eXcelisys FileMaker Developer
FileMaker Inc. (errr, I mean Claris International) introduced a new function with the release of FileMaker 18 that I was both eXcited and intrigued by until I tried to use it the first time: the “While” function.
I’ve written a number of custom FileMaker functions through the years and lots of loops in scriptin
Claris has released FileMaker Cloud! Ever since the rebranding from FileMaker to Claris, the company has emphasized a cloud-first approach, and this new product is an important step toward that end.
We're excited about FileMaker Cloud because it allows innovators and business owners to focus on what they are passionate about instead of maintaining server hardware, managing software updates, and constantly worrying if their backups are running properly.
Let's take a look at the benefits
There are so many times I hear lamentations from stalwart "FileMaker only" developers who declare that you should do everything within FileMaker and FileMaker alone. This is just crazy. It's like saying you should build an entire house with only a hammer and nails. How could you ever do that efficiently? What about the plumbing? The electrical? Well, you can't. You always have to increase what you know and become familiar with other tools and newer technologies.
In this video, I showcase a very
There are so many times I hear lamentations from stalwart "FileMaker only" developers who declare that you should do everything within FileMaker and FileMaker alone. This is just crazy. It's like saying you should build an entire house with only a hammer and nails. How could you ever do that efficiently? What about the plumbing? The electrical? Well, you can't. You always have to increase what you know and become familiar with other tools and newer technologies.
In this video, I showcase a very
Dogged by a Slow FileMaker Database?
Cache in on this Quick Tip to Improve Layout Load Times & Report Generation
By Joe Cellino, FileMaker Developer
Have you ever wondered, “What is taking this report so long to generate?” or “Why does this layout take so long to load?” It may be that your FileMaker fields are set up inefficiently. If you have unstored calculation or summary fields on your layout, this will most certainly be the issue. Just as the names indicate, “unstored” calculation fi
Dogged by a Slow FileMaker Database?
Cache in on this Quick Tip to Improve Layout Load Times & Report Generation
By Joe Cellino, FileMaker Developer
Have you ever wondered, “What is taking this report so long to generate?” or “Why does this layout take so long to load?” It may be that your FileMaker fields are set up inefficiently. If you have unstored calculation or summary fields on your layout, this will most certainly be the issue. Just as the names indicate, “unstored” calculation fi
Disclaimer: the techniques shown in this article are provided on an as-is basis. Use with appropriate caution and at your own risk. Acknowledgements: today’s article would not have been written without the inspiration provided by Bruce Robertson, John Ahn (FM 12 ExecuteSQL Unconference Session), Andries Heylen (Magic Value Lists), Marcelo Piñeyro (How to Extend FileMaker… Continue reading 2-Column Magic Value Lists
View the full article
Disclaimer: the techniques shown in this article are provided on an as-is basis. Use with appropriate caution and at your own risk. Acknowledgements: today’s article would not have been written without the inspiration provided by Bruce Robertson, John Ahn (FM 12 ExecuteSQL Unconference Session), Andries Heylen (Magic Value Lists), Marcel Pinyero (How to Extend FileMaker… Continue reading 2-Column Magic Value Lists
View the full article
With the official release of the FileMaker Cloud Admin API, you can now monitor and manage multiple servers from one interface, including the ability to set up server-side schedules, pull a list of logged-in users, send messages to connected users, and much more. And to make interacting with Admin API even easier, we created the FileMaker Cloud Schedule Manager, your one-stop shop to manage server-side schedules on Cloud. The Manager has been updated to work with the Admin API official release a
Yes, while it's unfortunate FileMaker Go doesn't run on Android devices, we can still take advantage of what's offered on the iOS side of things. This comes in the form of Apple Maps using MapKit JS.
True, Google Maps does seem to have the slight edge when it comes to feature set, but if you need full control over an integrated mapping experience, then Apple's MapKit JS may just be the perfect solution for you.
MapKit JS, currently in beta since WWDC 2018, only seems to work on the Mac version
Yes, while it's unfortunate FileMaker Go doesn't run on Android devices, we can still take advantage of what's offered on the iOS side of things. This comes in the form of Apple Maps using MapKit JS.
True, Google Maps does seem to have the slight edge when it comes to feature set, but if you need full control over an integrated mapping experience, then Apple's MapKit JS may just be the perfect solution for you.
MapKit JS, currently in beta since WWDC 2018, only seems to work on the Mac version