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.
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
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
For the first time, DB Services has been ranked #3494 on the annual Inc. 5000 list, which ranks the country’s “fastest-growing innovators” based on overall revenue growth over a three-year period. The Inc. 5000 list has brought attention to America’s growing private businesses since 1982.
DB Services now joins the ranks of other Inc. 5000 list alumni such as Facebook, Zappos, Pandora, and others. DB Services is top ranked FileMaker Platinum Business Alliance Partner on the 2019 Inc. 5000 li
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
During our recent discussion of SortValues and UniqueValues, I made passing reference to an article I wrote a few years ago on the topic of “pseudo indexing“, i.e., displaying a list of unique values for a specific field for a found set, rather than for all records. Well today we’re going to dust the pseudo […]
View the full article
Today we’re going to look at two functions introduced in FileMaker 16: SortValues and UniqueValues, and you may want to download and follow along in this demo file: FM 16 – SortValues & UniqueValues (5 Mb, requires FM 16 or later) Each of these functions operates on a return-delimited list of values, and the names […]
View the full article
There’s a simple way to avoid collisions when using UUIDs as primary keys: Use UUIDs as primary keys.
No, that’s not a typo. The idea that Get ( UUID ) will create a duplicate ID in a single table, in a single file, or even all tables in all FileMaker files you ever create is, simply, false.
I can hear someone out there (likely here) saying: “Whaaat? Just because it’s very unlikely, doesn’t mean it can’t happen”.
And my answer is: “Actually, it does mean that. That’s exactly what it means.” H
Moving forward with the Custom Function database project, we now have the opportunity to copy and paste our groups of custom functions. The trick to accomplishing this requires a modification to the singular copy/paste being used for a single custom function.
The database now needs to provide a list of functions, in the xml snippet format, to be copied to the clipboard. This is easily accomplished through the relationships and by modifying the original script.
If you’ve never had the problem w
Moving forward with the Custom Function database project, we now have the opportunity to copy and paste our groups of custom functions. The trick to accomplishing this requires a modification to the singular copy/paste being used for a single custom function.
The database now needs to provide a list of functions, in the xml snippet format, to be copied to the clipboard. This is easily accomplished through the relationships and by modifying the original script.
If you’ve never had the problem w
Over the years, FileMaker has added, enhanced and modified various areas of the development platform. One of the areas which has seen a big transition is the way favorites are managed. If you're a long-time developer of FileMaker solutions, then one of the more recent changes in FileMaker 16 may be a bit disconcerting.
The change was to how favorites are managed. In fact, they simply took out the menu option and sorta left you hanging. The "Manage favorites..." menu is no longer present within
Over the years, FileMaker has added, enhanced and modified various areas of the development platform. One of the areas which has seen a big transition is the way favorites are managed. If you're a long-time developer of FileMaker solutions, then one of the more recent changes in FileMaker 16 may be a bit disconcerting.
The change was to how favorites are managed. In fact, they simply took out the menu option and sorta left you hanging. The "Manage favorites..." menu is no longer present within
Most everyone likes to know what's going on when something is happening. Being kept in the dark is something which causes possible anxiety and certainly a fair amount of impatience. So, it's always nice to provider your user with a little bit of status when there's some type of progress happening.
Fortunately, this is a very easy thing to solve when a lot of the work is already done for you. All you need to do is wire things up within a FileMaker web viewer.
Using the information within this v
Most everyone likes to know what's going on when something is happening. Being kept in the dark is something which causes possible anxiety and certainly a fair amount of impatience. So, it's always nice to provider your user with a little bit of status when there's some type of progress happening.
Fortunately, this is a very easy thing to solve when a lot of the work is already done for you. All you need to do is wire things up within a FileMaker web viewer.
Using the information within this v
Hierarchical Portal Filtering Incorporating Drag-n-Drop Technique
By Andy Persons
This is part three of a three-part series on hierarchical portals in FileMaker Pro. You can find part one here and part two here. Demonstrating how to provide drag-and-drop rearranging and arbitrary sorting of hierarchical items.
Standard Interface
A common request when implementing hierarchical portal filtering is the ability to drag an item exactly where you want it to go. If you want it insid
Close scripts generally aren’t very important in a FileMaker solution, especially a multi-user solution, but Open scripts should be employed on just about every solution created. Open scripts setup up your solution for the user, making it easier to use. In the following paragraphs, there are many examples of common Open script snippets you can include in your own solutions but Open scripts are as varied as there are developers and the solutions they create. The ideas in this chapter are just a s
Close scripts generally aren’t very important in a FileMaker solution, especially a multi-user solution, but Open scripts should be employed on just about every solution created. Open scripts setup up your solution for the user, making it easier to use. In the following paragraphs, there are many examples of common Open script snippets you can include in your own solutions but Open scripts are as varied as there are developers and the solutions they create. The ideas in this chapter are just a s
Tableau est un puissant outil d’analyse des données et depuis peu, il est devenu possible d’y connecter nos bases de données FileMaker à l’aide d’un connecteur dédié livré avec la version 16 de FileMaker Server. Alors que nous testions ses possibilités dans le but d’en faire profiter nos clients, nous avons eu une mauvaise surprise : […]
Cet article QuickFix : Tableau et les séparateurs de décimales est apparu en premier sur 1-more-thing.
View the full article
FileMaker Pro, beyond your normal join table, offers a unique method of storing collections, or groups, of items. You can do this with what is called a multi-key field. This isn’t to be confused with a compound-key, which is a primary key composed of multiple different values.
Using a multi-key field we can store a collection of custom functions within our Custom Function database. This makes it possible to start the process of collecting groups of functions together and then adding a feature s
FileMaker Pro, beyond your normal join table, offers a unique method of storing collections, or groups, of items. You can do this with what is called a multi-key field. This isn’t to be confused with a compound-key, which is a primary key composed of multiple different values.
Using a multi-key field we can store a collection of custom functions within our Custom Function database. This makes it possible to start the process of collecting groups of functions together and then adding a feature s
