We all know FileMaker is a great platform to store, organize, and find data, be it grandma’s recipes or the inventory of a multinational corporation. Most avid FileMaker users can figure out how to enter, delete, search, and even create lists of stuff with little to no help. The one thing that we often struggle […]
Since very early in its life, FileMaker (perhaps even before it was FileMaker Pro) could store binary data (zeros and ones). We have all kept things like pictures, movies, and eventually portable document formats (PDFs), Word documents, and even object linking and embedding (OLE) files on Windows. If you can store it in a file, […]
One of the main reasons we use FileMaker is because it saves us time and makes entering data accurately and consistently a breeze. The key to making FileMaker our data entry go-to tool of choice is mastery of the Auto-Enter tab in the Options for Field dialog box. When we create a new field or […]
Previously, we’ve talked about how to integrate FileMaker and QuickBooks Online by first creating an access token and then a refresh token to maintain a secure connection between the applications. These are necessary steps to prepare for the integration, but now we’ll turn our attention to moving data between the FileMaker-based solution and QuickBooks Online. But, of course, […]
In the previous post, we set up our QuickBooks Online API account and used the provided bits of information (Client ID and Client Secret) to start the process to create a token. We will use this token going forward to authenticate with the API and push and pull our data. After inputting our QuickBooks Online credentials […]
We all know our FileMaker solutions don’t operate in a vacuum. They need to talk to all sorts of other programs and services to be as productive as possible. For example, one of the most ubiquitous applications in the small and mid-sized business world is QuickBooks. Almost every business needs a bookkeeping/accounting application to ensure […]
FileMaker is a powerful platform for creating apps to solve our business challenges. It can single-handedly tackle virtually any workflow we throw at it. Still, there are instances when we might need to integrate our apps with another software tool to extend their functionality and/or accessibility. For example, we can manage integrations with third-party tools like Zapier […]
We compared and contrasted the use of variables between JavaScript and FileMaker. Now, we want to talk about functions and how to use JavaScript in FileMaker. Claris’s FileMaker platform and most spreadsheets have these useful features called functions. These functions do simple calculation jobs for us. For example, the Trim() function removes white space from the […]
JavaScript is our web browser’s scripting language, and any object that uses the operating system’s web browser engine inherits its capabilities, including FileMaker’s web viewer. We can use JavaScript just like we use a FileMaker script. JavaScript can execute various functions such as: Run workflows Distribute invoices to select customers Save data to a database […]
A couple of weeks ago, Claris released a new version of their FileMaker platform, FileMaker 19.3. Claris has been working hard over the last year, since the release of FileMaker 19, to modernize and simplify the FileMaker user experience. The Quick Start experience is a big step toward easing users into the FileMaker platform. In addition, the features […]
With all the recent ransomware events in the news, it’s clear that we need to protect our servers and apps from eyes and ears that aren’t our own. To that end, let’s review some of the ways bad actors find ways to access our FileMaker data. We’ll also highlight the FileMaker cyber security features that […]
Sometimes the most challenging part of any task is getting started. Claris recognizes this, and as a result, offers FileMaker users and citizen developers the ability to build custom apps in an agile manner. They released the FileMaker Quick Start Experience in preview mode several months ago. The tool is intended to be intuitive, but it’s also […]
The future of low-code development is coming clearly into view, and it’s going to be browser-based. Most of today’s best examples of productivity-enhancing platforms don’t require installing desktop programs or uploading apps to local servers but instead just opening a browser window and pointing to an address. Building, testing, and deploying applications all happen in […]
There are a variety of web services out there to help teams do their work efficiently and effectively. FileMaker and Airtable are just a few go-to solutions for business folks struggling with organizing their time, projects, and people. Airtable is generally perceived as easy to use. It’s an excellent tool to turn to when you’re […]