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.
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
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
FileMaker offers many different options for charting, but if you need a chart that is not available in FileMaker, you should consider using Google Charts. Google Charts is a free Javascript framework that can be used in conjunction with web viewers in FileMaker to extend your charting capabilities: https://dbservices.com/articles/google-charts-in-filemaker/
dbservices.com
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
Many companies use both QuickBooks and FileMaker end up having to do double data entry from one system to the next. In this article, we will demonstrate how you can eliminate the hassle of manually copying the information by integrating your FileMaker solution with QuickBooks online. Includes demo and sample file: https://dbservices.com/articles/filemaker-quickbooks-online-integration/
dbservices.com
This is a follow up to last week’s part 6, with three refinements. Demo 1 (Excel Exports, v7a) – fixes a numeric formatting bug Demo 2 (Excel Exports, v7b) – offers a more flexible Excel export “save” dialog Demo 3 (Excel Exports, v7c) – uses ExecuteSQL to reduce the # of TOs on the RG […]
View the full article
In the last few years, I've subscribed to the KISS methodology (Keep It Simple Stupid). Call it wisdom or humility, I'm not sure which. All I know is, after over two decades in the FileMaker market, I've discovered the simplest solution is most often best for my clients. It costs less and performs better, in most cases. I know all the tricks, having practically wrote the book on the subject, but there is a time and a place for complex methods. What I'm here to convince you is, choose complicated
FileMaker® Pro / WebDirect: FileMaker Web Subscription Service Keeps Oil Field and Reservoir Data Flowing to Prospectors 24/7
Just because your business involves fossil fuels, the technology you rely on doesn’t need to be a fossil too. A new FileMaker web solution brings new technology to finding an old resource.
In the United States, the average person consumes about 2.5 gallons of crude oil per day — or 22 barrels per year. Offshore oil production helps meet this need. According to the U
When I first started teaching FileMaker scripting, I went through the entire list of script steps and provided a simple example of each one. By the end of the third day, we had covered every script step but with no depth. More questions remained than were answered. That’s when I decided to focus on the most important steps. Instead of spending valuable time teaching scripts steps most people would never use in real life scenarios, I decided to concentrate on steps that are used over and over and
When I first started teaching FileMaker scripting, I went through the entire list of script steps and provided a simple example of each one. By the end of the third day, we had covered every script step but with no depth. More questions remained than were answered. That’s when I decided to focus on the most important steps. Instead of spending valuable time teaching scripts steps most people would never use in real life scenarios, I decided to concentrate on steps that are used over and over and
Recently I was asked to implement user-friendly Excel exports on a WAN-based solution, utilizing some of the techniques explored earlier in this series (part 1, part 1.1, part 2, part 3, part 4 and part 5 — all from five years ago). There was just one problem: while performance was great locally, and okay on a LAN, it was […]
View the full article
WordPress Theme Considerations
By: Fred Morgan
WordPress originally began life as a blogging engine, but over time has matured into not only a great content management system (CMS), but also a full-fledged application development framework. Consequently, WordPress holds the lion’s share of the CMS market and its widespread use has spurred the development of countless WordPress themes and plugins to extend its feature set. However, not all WordPress themes and plugins are created equal
One of the most enjoyable things about working in FileMaker, or any development environment where looping is supported, is the pure joy of automation.
Even thinking about checking off any more than a few records at a time brings me to a mental state of counting the number of seconds it takes for the single action itself, then multiplying times the number of objects I need to affect.
So the question arrives. “How do I automate this?” or “How do I make this process easier for the user?”. The ans
One of the most enjoyable things about working in FileMaker, or any development environment where looping is supported, is the pure joy of automation.
Even thinking about checking off any more than a few records at a time brings me to a mental state of counting the number of seconds it takes for the single action itself, then multiplying times the number of objects I need to affect.
So the question arrives. “How do I automate this?” or “How do I make this process easier for the user?”. The ans
When you think of Apple you probably aren't thinking about custom software solutions are you? Learn more about FileMaker and how you can create custom application specific to individual business needs! https://dbservices.com/articles/apples-secret-subsidiary/
dbservices.com
Have you ever inherited a system built by someone else, changed a field’s name and everything stopped working? The issue, hardcoded names used in indirection, makes the system fragile. FileMaker provides developers many methods to add flexibility using indirection. However when these instances of indirection are not treated properly they will raise all sorts of problems. In this article we will discuss good practices regarding indirection that will help you build a dynamic and robust FileMaker s
Have you ever inherited a system built by someone else, changed a field’s name and everything stopped working? The issue, hardcoded names used in indirection, makes the system fragile. FileMaker provides developers many methods to add flexibility using indirection. However when these instances of indirection are not treated properly they will raise all sorts of problems. In this article we will discuss good practices regarding indirection that will help you build a dynamic and robust FileMaker s
G'day all! Just posted a new article over at FM Weetbicks, hope you enjoy it. This is a technique that I've used in a few solutions now, mainly for login screens or splash screens where I want to present a pretty backdrop image. The issue is that when the user resizes their screen or rotates their device, the image can often stretch, distort, or end up with gaps of space if it is set to maintain aspect ratio.
This article presents a way around that, hope you enjoy!
https://www.teamdf.
Hierarchical Portal Filtering using FileMaker Pro 15
By Andy Persons
Way back in 1996/97, I developed my original hierarchical portal filtering technique using FileMaker Pro 3. Twenty years later, we decided to take another look and update it for FileMaker Pro 15. Several alternate approaches have been developed in the interim for the hierarchical portal filtering technique (including a “lite” approach by my colleague Doug West). After reviewing them, we believe the original approach s
This is part 2 of the phone filtering solution. If you haven't read then it's a good idea to start there. Even if you are familiar with filtering phone numbers already and just want to read about the recursive version, it's still best to read part 1 to familiarize yourself with the approach. And, you never know, you might find a nugget of truth!
View the full article
This is part 2 of the phone filtering solution. If you haven't read part 1 then it's a good idea to start there. Even if you are familiar with filtering phone numbers already and just want to read about the recursive version, it's still best to read part 1 to familiarize yourself with the approach. And, you never know, you might find a nugget of truth!
View the full article
Planning out your UX (user experience) obviously requires less work on a smaller solution than it does within a larger solution. I guess that goes without saying, but no matter what solution you start working on, it will always seems to grow and expand to add new features and functionality.
While you can’t always plan for what you don’t know is coming down the road, you can certainly work with what you have in front of you. Trying to prototype and account for how your solution will be used is w
Planning out your UX (user experience) obviously requires less work on a smaller solution than it does within a larger solution. I guess that goes without saying, but no matter what solution you start working on, it will always seems to grow and expand to add new features and functionality.
While you can’t always plan for what you don’t know is coming down the road, you can certainly work with what you have in front of you. Trying to prototype and account for how your solution will be used is w
Hierarchical Portal Filtering using FileMaker Pro 15
By Andy Persons
Way back in 1996/97, I developed my original hierarchical portal filtering technique using FileMaker Pro 3. Twenty years later, we decided to take another look and update it for FileMaker Pro 15.
Several alternate approaches have been developed in the interim for the hierarchical portal filtering technique (including a “lite” approach by my colleague Doug West). After reviewing them, we believe the original approach still ha
Custom Mobile App Puts iPads Out to Pasture (Literally)
A farmer loads liquid feed from a distillery in Owensboro, KY, 1938 / Russell Lee, U.S. Farm Security Administration
Cattle farmers have been using liquid feed supplements for more than a century. The practice is not new. What has changed over time, though, is the delivery process and precision with which dealers can custom formulate liquid feeds to meet the specific needs of individual livestock herds.
Decades ago, farmers squ
FileMaker Pro Progress Bars, chapter 5: Gantt-Man
By Andy Persons
In which nothing can Bar our intrepid code from Progressing to Uncharted territory!
We received an interesting variety of responses to our FileMaker Pro Progress Bars demo files. Can you make it show an image for the foreground? How about an animated gif? It’s too blurry; can you sharpen it up? Any chance it can do my taxes?
One of the requests that piqued our interest was the ability to have the foreground color
