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?
Hiring a developer is about creating a working relationship. You want someone who gets your business and gets you. Having a good working relationship often determines the success or failure of a development project. Hire someone you are comfortable with who also has the skills necessary to make your project successful. Beyond the quality of the working relationsh
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
Today we’re going to take a quick look at a potential “gotcha” that can crop up when doing numeric comparisons. Jason DeLooze and I discussed the general behavior back in 2011 (Space Is The Place), but this time around I want to focus on one particular set of circumstances where the problem can arise. At… Continue reading When 2 is greater than 10 View the full article
How easy is it for you to design the user interface of your FileMaker database? Are there any tips you have which makes the process easier? If so, then I would love to hear them!
In this video, I'm providing you with the best information I have about a successful UI design process. It's the opening video to a deep dive about how themes actually work within FileMaker. I start with a blank layout and go over the major areas of what I consider when starting the design of a new database or a re-ski
Gospel-Inspired Web Community Sees Light of Day
eXcelisys Sets Up Video-Sharing Platform for Christian Musicians
Imagine a cozy, happy space on the internet dedicated to positivity, to encouraging people to be the best versions of themselves. Imagine a platform devoted entirely to providing Christian musicians and writers with a place to share their work. Imagine “Massive Miracle” – a new Gospel-inspired web community launched by brothers Bedcy and Rops Previl.
Born in Haiti, Bedcy came
Claris FileMaker delivers developers the ability to publish and share data in so many ways, partially with the recent inclusion of the Data View the full article
Demo file: sql-join-fun-etc.zip requires FM 18 or later. Recently I was asked to create a mini-report combining data from a pair of related tables via ExecuteSQL. This provided an opportunity to think about SQL joins, and also to come up with a way to apply currency formatting to dollar amounts in the SQL query result,… Continue reading Fun with SQL Joins and Currency Formatting View the full article
One of the best feelings for any database developer is knowing that duplicate data simply can't sneak into your solution. You've got clean data such that when you search for a specific email address you know there's only one and it belongs to the right entity.
In the associated video and sample file you'll get all the details for how you can use FileMaker's Unique value validation option. You'll see how you can prevent FileMaker from showing it's annoying dialog box which uses the name of the f
With a simple and robust API, Slack is quickly integrated into custom apps of all types, and FileMaker is no exception! Our guide will show you how to send messages to your Slack workspace from FileMaker workflows. Includes a video and a sample file. Read the full article here.
I once asked someone on the forums why they wanted a particular solution. I did this because they were asking for a technique that seemed like a lot of unnecessary work. I was attempting to provide a better answer that met their true needs within the abilities of FileMaker. In other words, why give a man a fish when he really wants a fishing pole. The response I received was, "Why is not relevant to how." Wow! This guy couldn't be any more wrong. Such a shortsighted approach to programming is no
Pretty much all over the world you'll find technology which can scan barcodes. Smartphones with cameras just waiting to scan either their very first, or even their 1000th barcode scan. With just over a decade since the first iPhone came out, it's pretty hard to not find a use case where a barcode can help you retire some antiquated manual process. Barcodes can be used almost anywhere to make faster and/or easier solutions.
Given that FileMaker Go supports all major barcode types, you simply nee
Out of the box, FileMaker is a really easy solution for inputing data and simply finding the results you want when searching that data.
There are, however, times when you need to break away from FileMaker's "solve all" solution of case insensitive searching. Times where you simply want to present some data within your user interface - without setting up extra relationships or fields. Or, those times when you simply need to search based on the case sensitivity of the data within a field.
In ord
By now you’ve all heard the earth-shaking news: the merger between the Proof Group and Geist Interactive. The new company, Proof+Geist (the ‘+’ is silent, by the way), brings together the best of The Proof Group and Geist Interactive. All that you know about those separate entities are now as one. Now led by Ernest […]
The post A Bit More about Proof+Geist appeared first on Geist Interactive.
View the full article
Hello there 🙂 We have some exciting news to share with you. Geist Interactive has merged with the Proof Group to form Proof+Geist (the + is silent). This is an acceleration of our decades-long mission of empowering people to do great things, a mission we have always shared with the people at the Proof Group. […]
The post Something is Happening here at Geist Interactive appeared first on Geist Interactive.
View the full article
On January 19, 2021 we met online for the second time to discuss my FileMaker performance lab testing results. For the case you either missed the meeting, or attended and want to recall some details, a recording of the meeting is now available...
In the meeting I talked about the impact of record size on performance being often higher than impact of any other factor.
As a surprise I also showed my first results of testing actual simultaneous clients connecting to FileMaker Server
Have you ever dreamed of being able to generate high quality scalable barcodes in FileMaker solely using calculations, with no plug-ins, fast enough, in a way compatible with server-side scripts, FileMaker Go and FileMaker WebDirect, and completely free of charge? Your dream has just come true...
There are various solutions for barcodes already available, from special barcode fonts, through Brian Dunning’s custom functions using rotated underscore as a symbol primitive, various web se
Some of my most favorite moments, when working with technology, are when you see the result of a few lines of code do what used to take hours and hours of work. Seeing the fruits of knowledge labor which replaces a lot of manual labor. It's glorious!
The example I'm mentally referencing is any time you need to extract some content from a web page and it's literally SITTING RIGHT THERE in front of your face and you end up using your precious time doing the good old copy and paste.
Every day the
Demo file: file ids, table ids and field-level schema.zip (requires FM 18 or later) INTRODUCTION Recently I was asked to help document a FileMaker solution by creating and populating a “schema” table as per the above screen shot. One of the requirements was to programmatically determine internal ID numbers for the file and for the… Continue reading File IDs, Table IDs and Field-Level Schema View the full article
Who doesn't want to know how long something takes? It's not like we, as the busy bees we are, have all the time in the world - right? Well, how about some convenient progress information.
One of the most common procedures within all of computing is to cycle or iterate over a set of something. In FileMaker, this comes in the form of records. A record loop is one of the most common things you'll ever do within FileMaker.
Setting a field value to something else across a range of records? You'll l
Double data entry is often the enemy of companies that use both FileMaker and Sage Intacct. In this article, we will demonstrate how you can eliminate the hassle of manually copying the information by integrating your FileMaker solution with Sage Intacct. Includes video and sample file. Read the full article here.
FileMaker Pro provides a variety of methods for extracting your data from its database. From memory, we have standard relationships and calculated concatenations, the Copy All Records script step, scripted data loops and using the ExecuteSQL function. In FileMaker 19, we're provided with yet one more method for pulling data out of the system. The Execute FileMaker Data API script step allows us to use what was formerly available only from outside of FileMaker Pro via a url.
Now, within our scri
The Claris FileMaker Add-ons, released just a few updates ago, are one of the components that make up the Open Platform release. They’re useful in solving problems for FileMaker developers. Calendars and Kanban boards are popping up all over the community. They’re not without their issues, however, but most of what’s there we can control. […]
The post FileMaker add-on Found Set: Changing the Limit and Offset appeared first on Geist Interactive.
View the full article
A lot has happened in 2020 but I'm not hear to preach about the pandemic, the presidential race or George Floyd. A ton has transpired in the FileMaker market too! Probably the biggest news is JavaScript and FileMaker living in perfect harmony. But, I'll also pontificate about quarterly releases, Claris Engage, public speaking and even publishing in the FileMaker market. All of these subjects have come to exist or have changed drastically in the 2020 FileMaker market. So... sit back and enjoy th
There's a great feeling about writing functional code when it's something you can rely on. You know it's just going to work. Which, for some import routines, doesn't always feel this way. Sometimes the import may fail or you can't figure out how to make it work.
Columns may get renamed, they may be shifted around and vary or you may be importing from multiple different providers. If you're consolidating data from multiple sources or you have a situation where you need to manipulate the data bef
