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.
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
Forums are a great way to get technical advice for FileMaker but for some reason, many people don't think they have to be nice in the electronic world. I was raised to say "please" and "thank you" and that has translated over to the internet for me. But, other folks think the anonymity of cyberspace is an excuse to be a jerk. Some posters are outright offensive and others will just leave snide responses like, "that wasn't much help". News flash! People on the internet are real and you should be
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
Part 2: What Should You Consider When Selecting a Development Partner? What Questions Might You Ask a Potential Developer?
Figuring out how to choose a great developer can be bewildering without some insight about what to look for. In this segment of our seven-part series on choosing and working with a custom app developer, we will eXplore some tips on how to vet developer candidates.
Hiring a developer is about creating a working relationship. You want someone who gets your business
GoDraw3 is a FileMaker drawing tool for users. For FileMaker developers, however, it is full of customization. A developer can do with it what she wants.
The post GoDraw3: Hack the Heck Out of It appeared first on Geist Interactive.
View the full article
Hi all!
In this article we showcase a range of Logo and Profile picture retrieval APIs and how they can be integrated into your FileMaker solutions to automatically download images for your contacts.
We also show how background content can be removed from these images, again through using background removal APIs.
Finally, we talk a bit about why using these could benefit your solution and when all else fails what other options are available for adding some visual presentation for
In FileMaker, some features seem like they should be an easy solve. Yet, the dynamic nature of creating something in FileMaker means its development simply can't account for all the possible things a developer might want to do.
When it comes to showing the actual count of records being shown within a filtered portal one might think the solution would already be there. However, it's not.
You have to apply some creating thinking along with a bit of inside know-how in order to correctly show the
Over the years, clients have asked me for a variety of reporting features that aren't easily created with standard subsummary and summary tools. A lot of them, including this technique, use the GetSummary function. I remember having such a hard time wrapping my head around the GetSummary logic when I was working in technical support. Once, I got over the hump, GetSummary became one of my best friends, helping me overcome all kinds of FileMaker battles. In this article, I'll demonstrate how to pr
In the world of software development, there are few tools you simply can't live without. A debugger is the first which comes to mind; because no one gets their code exactly perfect the first time. Plus, it's always a matter of figuring things out until they work as expected or desired.
There are also those "other" tools which you can't really live without. ESPECIALLY, if you're working with a solution file which was created by someone other than yourself! When you need to discover what the heck
Demo files: set-var-by-name-v4 and set-var-by-name-md5 Background This is a quick follow up to last December’s Set Variable By Name Revisited, and to avoid repetition will assume the reader is familiar with the material that was presented in that article. But to briefly recap: 1. FileMaker does not provide an obvious way to programatically name a… Continue reading Set Variable By Name Re-RevisitedView the full article
In this article we show you how to use the contents of a FileMaker container field to produce beautiful gradients and solid background fills based on the container images most prominent colors.
We also show how to render solid fills without the use of a web viewer (for portal display) and how to determine optimal color for text placed on top of your background fills.
As always, an example file has been lovingly crafted to help you explore these techniques
You can read the article
Oh the pain of a slow rendering layout! The other day I came across a painfully slow layout which was literally CRAWLING. It reminded me of one of my own situations where I needed to create a solution for some type of creative data input. This, of course, was based on FileMaker's input limitations between two types of fields.
The choice of using a Drop-down list over a Pop-up menu field style was based on the type of input being managed. I didn't want the forced interaction of having to click,
FileMaker on Linux / Docker – Presentation at Kentuckiana Developers Group
A few weeks ago, Jonathan Fletcher was kind enough to invite Romain Dunand (@airmoi) and I (@FabriceN) to do a presentation at his Kentuckiana Developers Group.
Discover all the possible ways of hosting FileMaker databases
The topic was a comparison of all possible ways to host a FileMaker database, from local server to Virtual Private Server, to, of course, our fmcloud.fm Linux/Docker solution.
If you want to unders
Every once in a while you need to store something with an extra bit of security. Maybe it's a password or some super secret text with a winning stock market strategy. Whatever it is, you don't just want to rely on the authentication, privilege set and possible EAR (encryption at rest) on the file.
You want to store the data itself with even that much more security. By encrypting it with CryptEncryptBase64() of course! The trick is this. How do you capture that data, before it's written to the d
This is Part 2 of a series about using the DataTables JavaScript library in order to simply pull data you wish to display and doing so within a Web Viewer.
While standard FileMaker Portals present one of the easiest methods for showing related data, it's now a viable option to simply use a Web Viewer to present data to the user. With the bi-directional support of JavaScript within FileMaker 19 and higher we can take advantage of what JavaScript does best - being fast!
In this video we focus sp
Portals and list views represent one of the biggest reasons for using a database for managing data. You can view the data in a myriad of ways and FileMaker provides the tools to modify the views quite easily.
FileMaker's list view happens to be the most powerful when compared to portals. We don't really have the same feature set presented within a portal. Using a portal it's an all or nothing approach to sorting by default and you can't really search the portal contents. You can certainly hack
INTRODUCTION Today I want to take a look at a certain Perform Script On Server (PSOS) behavior, and for those who find this behavior to be inconvenient, propose a work around. Here’s the behavior, or misconception, actually: a server side script initiated via PSOS (apparently) cannot access files on the server unless the user already… Continue reading PSOS – Run Script in File not open LocallyView the full article
Scripting a change log table has been around since script triggers were introduced in FileMaker 10. But, do you know the right way to script a field modification log? I've been programming them for years and have gone through every version of them and have settled on what I'm going to cover today. We'll start off with the wrong way to script an event log so you can get some perspective but will end up with a dynamic solution that can be copied and pasted from FileMaker file to FileMaker file.Vie
What's the easiest way to format a FileMaker date, time or timestamp value? Using a custom function? Maybe...
In this video, I'll show you a unique trick for getting a formatted date, time or timestamp value without using a Custom Function or any of FileMaker's Date or Time functions. Of course, I'll also provide you with one of the better custom functions for formatting date/time/timestamp values.
The custom function in this technique file handles pretty much all possible variations of date/t
Anyone can just throw everything they need within a portal. Adding a new field? Just throw it in the portal. But WAIT! The question is "Should you?". The fine art of determining what should end up in your portal is based on how the data and/or actions are being referenced/used.
Is the frequency for editing the data high or low? If it's low, then maybe the user doesn't need field access. What is the frequency of record deletion? Low? Then, do you really need that obvious red trash can icon on ev
Writing JavaScript in FileMaker is hard. Sure, the path is easy to see and clear to follow, but the actual writing of the code is hard. I have tried to find a way to write JS code that makes it fairly easy. And by “easy,” I mean “make it so that FileMaker developers don’t have […]
The post Towards A Better JavaScript Development Environment appeared first on Geist Interactive.
View the full article
Introduction Recently I had the pleasure of speaking with Jeremy Brown on The Context Podcast about an open-source project called JSONata that enables you to query and transform JSON. The JSONata site is packed with useful information, including this short video… …as well as… Extensive documentation A link to the Stack Overflow forum, where you… Continue reading FileMaker 19 + JSONataView the full article
Claris l’avait annoncé : finies les traditionnelles grandes sorties du mois de mai. Le cycle « Agile » consiste en des mises à jour plus fréquentes, avec une répartition des nouveautés tout au long de l’année. Cette semaine, c’est la version 19.3 qui a été annoncée, et c’est une version importante même si surtout « technique ». Petit résumé […]
Cet article Sortie de FileMaker 19.3 est apparu en premier sur 1-more-thing.
View the full article
Claris l’avait annoncé : finies les traditionnelles grandes sorties du moi de mai. Le cycle « Agile » consiste en des mises à jour plus fréquentes, avec une répartition des nouveautés tout au long de l’année. Cette semaine, c’est la version 19.3 qui a été annoncée, et c’est une version importante même si surtout « technique ». Petit résumé […]
Cet article Sortie de FileMaker 19.3 est apparu en premier sur 1-more-thing.
View the full article
Claris' 19.3 release of the FileMaker platform is out! In this article, we will discuss our favorite new features including native support for Apple Silicone, leveraging Microsoft Edge, and FileMaker Cloud-native script schedules! Read the full article here.
Value lists are one of the fundamental building blocks of any good UI built on top of a database system. Providing users with a preselected list of options to choose from helps the data entry process go faster and - is - just easier.
When using value lists, there are times when you need to limit the number of selections of any given value to being used just once. You may also need to enforce that one of each of all possible values is used.
In this video, we tackle both situations by enforcing
fmcloud.fm, the only FileMaker hosting service running on Linux/Docker, is now available in Switzerland too, as well as USA, Canada, UK, France, Germany, Singapore and Australia.
The post fmcloud.fm available in Switzerland appeared first on fmcloud.fm.
View the full article
