Jump to content
  • entries
    491
  • comments
    6
  • views
    31,702

Entries in this blog

Automating Data Capture of PDF & Images

It's always interesting to measure the metrics of how long something takes. Adding automation to a process not only saves time, but makes it less mentally taxing. This increases the sense of accomplishment and can make the process itself more gratifying. I remember being at an amusement park and showing my kids how to measure the amount of time they might be in line by counting the amount of time it took between each time a roller coaster pulled in and how many people it accommodated. By then c

FileMaker Magazine

FileMaker Magazine

Global Utility Fields

Global fields in FileMaker Pro are a staple of how you define what your user interface can do. Without global fields, your ability to present variable scenarios of data is almost impossible - or - at least, unrealistic. You would be limited to using calculated fields and/or extra data fields, and this can make things really slow, REALLY quick. Global fields are the linchpin to makings things work well, as desired and efficiently within your FileMaker UI. Without knowing how to take advantage of

MBS JavaScript Power

Living the 100% FileMaker native life is certainly possible, but can be seriously limiting when it comes to all the things possible with various other technologies. JavaScript, as one of the predominant languages used across the Internet and beyond, is quickly becoming a must-know for every serious FileMaker developer. In this video I showcase using the MBS plug-in in order to take advantage of the VERY WIDE world of JavaScript libraries and doing it without the Web Viewer. FileMaker's Web View

JSON Parameter Passing

Thank goodness JSON was implemented within FileMaker. Without it, we would still be using a variety of other methods for handling multiple parameters within a FileMaker script. Using JSON, we now get the double-sided benefit of 1) having an efficient serialization of key/value pairs as inbound parameters and 2) it just happens to be the standard which most of the rest of world is using for a large chunk of how things interoperate. In this video, and the technique file, I'll showcase a few examp

10 Killer Utility Scripts

Once you've repeated the same thing within FileMaker more than a dozen times, you often realize you should really be using a Utility script. A utility script is something which allows you to focus more on the unique solution and less on the routine things you end up doing over and over again. In this video we take a look at 10 killer utility scripts. These vary from a simple copy field routine to a very useful related record creation routine. Do you find yourself often needing to toggle values

Easy Mapping Using MapKit

When it comes to using mapping technologies within FileMaker, you've most likely heard about using Google Maps API within a web viewer. Maybe you even know about Bing Maps, Mapbox or even the popular OpenStreetMap.org. The biggest issue with all of these mapping APIs is you'll have to first understand the API in order to achieve your desired result, and then you'll have to jump through the hurdles of authentication as well. It's not as easy as a simple plug-n-play solution. While authentication

JSON Manipulation using JSONata

Having created recent videos about accessing APIs via REST, and extracting the free JSON data as well, it would be a glaring omission if I didn't address our need to manipulate the JSON FileMaker provides us with. Yes, the work to put your FileMaker data into structured JSON has already been done. But, the JSON you need for your designated API is always going to be different than that. Fortunately, we have access to the amazingly powerful and fast JavaScript engine built into each and every Web

Server Side Scripts: Get & Restore Context

Traditionally, performance in computing has revolved around the optimization of bits and bytes — how many can be saved and how efficiently a task can be accomplished. This principle dates back to the era of computers with only a handful of kilobytes of memory, where maximizing efficiency was critical. Fast forward to today, and the same principle holds true. Despite various ways of achieving the same outcome, the ultimate question end-users continue to ask is: 'Can you make it go faster?' Enter

FileMaker Magazine

FileMaker Magazine

The "One" REST Script

When it comes to programming, there's always more to learn and share. If you've worked with REST APIs in the past, then you may have already devised your perfect system. If not, then this video will showcase a freely available script which you might want to consider first before trying to solve the problem yourself. In our ever expanding world of coding to standards and systems, many of which have existed for decades, it's always prudent to see if you can beg, borrow and... Ok, don't steal... c

FileMaker Magazine

FileMaker Magazine

Data Separation - How-To

FileMaker solutions don't really care where your data comes from. They've long had the ability to reach out into ODBC & SQL sources of data. So long as the connection is fast and stable, users really don't know, or care, where the data is hosted. With the addition of Claris Studio, data can even be hosted within a NoSQL database such as MongoDB - although we can't, as of yet, structure any of the data other than through the Claris Studio interface. This also means you can use the same Exte

FileMaker Magazine

FileMaker Magazine

Layout Design Optimization

When it comes to designing a FileMaker layout, there are always subtle tips and tricks that might not be immediately apparent. Whether it's leveraging a graphic to replace multiple layout objects or finding innovative ways to present information in a navigational portal, the possibilities are quite wide. Regardless of the current state of your layouts, this video unveils various tricks that can further optimize them. Whether your aim is to create layouts with lower maintenance and maximum effic

FileMaker Magazine

FileMaker Magazine

Easy JSON Record Data

Coding software solutions offers the fascinating realization that there are always multiple pathways to achieve the same goal. Sometimes the methods we're familiar with may not be the most optimal, prompting us to expand our knowledge to explore alternative approaches. This video explores precisely that theme - the comparison between older and newer methods of accomplishing the same task. The advantage lies in the fact that newer methods often come with additional features or benefits. This is

FileMaker Magazine

FileMaker Magazine

Smart Solution Architecture - Part 2

In Part 2 of our exploration of Smart Solution Architecture, we delve into the fascinating aspects of structuring your FileMaker solution. While the 'common' method of structuring a FileMaker solution might be the simplest, it doesn't necessarily guarantee optimal performance. As the development of your solution evolves, increased complexity naturally accumulates a few 'cobwebs' and you may encounter potential slowdowns. In order to avoid or diminish this, you'll want to be aware of all the pos

FileMaker Magazine

FileMaker Magazine

Smart Solution Architecture - Part 1

FileMaker development is an exhilarating journey which empowers you with the ability to have complete control over the data you want to manage and manipulate. Yet, at times, it can be a test of patience as you strive to achieve the desired results - especially as you're learning. The good news is that, in the vast majority of cases, what you aim to accomplish is not only feasible but likely easier (and faster) to accomplish than in many other development environments. Although I may be a bit bi

FileMaker Magazine

FileMaker Magazine

Sending HTML Emails

While younger generations of Internet users are increasingly adopting communication tools like Discord, it's challenging to envision a future devoid of at least one distinctive means of communication - email. Could a world without email imply that government agencies, utility providers, and other entities transmit messages based on your DNA sequence, linked to your registered devices? The possibilities are intriguing. But for the present moment, email remains a crucial part of our digital lands

FileMaker Magazine

FileMaker Magazine

Ultimate SQL Mastery

When embarking on your journey with FileMaker, you encounter the wonderfully visual tool known as the Relationship Graph, which grants you the ability to visually comprehend the intricate interconnections within a complex solution. In fact, the relationships used to link table occurrences in FileMaker are fundamentally akin to those in SQL. FileMaker essentially offers a visual representation of what would otherwise be a textual definition of a SQL statement. The key distinction lies in the fac

FileMaker Magazine

FileMaker Magazine

Best Uses for Table View

One of the primary reasons developers cherish FileMaker is the freedom it offers to unleash their creativity within Form and List views. You have the power to craft virtually any type of software you can envision. However, when it comes to Table View, it might seem like you're merely replicating what most end users overuse - spreadsheets. Table View was likely introduced to ease the transition for spreadsheet users into the world of databases. Nevertheless, a well-structured data model renders a

FileMaker Magazine

FileMaker Magazine

Creating Universal Pickers

In the world of FileMaker solutions, it's almost inevitable that a solution will experience significant growth during the initial stages, followed by a transition to the everyday pace of normal use. When developing those initial features, one of your key objectives should be to emphasize reuse and repurposing. As is often the case, the less you have to manage, the easier it becomes to maintain and update your solution. There's less to re-learn, and your scripts, layouts, calculations, and other

FileMaker Magazine

FileMaker Magazine

Object Card Windows

Despite the FileMaker platform being several decades old, the original design of Layout mode and the ability for developers to harness existing tools to either mimic operating systems like iOS or craft entirely unique user interfaces remain monumental advantages for those who opt for this platform. One of the most significant additions to the Claris/FileMaker platform was the introduction of Card Windows. I remember creating some of the initial videos showcasing this feature; the capacity to ex

FileMaker Magazine

FileMaker Magazine

Useful Default Fields

Even when discussing seemingly mundane topics like Default Fields, there are always valuable insights to uncover. This video offers an exploration of the default fields I consistently incorporate into every table I create. While you might be familiar with or have utilized some of these fields, there could still be a surprise or two in store. For those who are relatively new to Claris/FileMaker development, this video holds significance. Learning about core techniques for data loading and effort

FileMaker Magazine

FileMaker Magazine

Killer ValuesWalk Custom Function

Discovering ways to make software faster and more efficient brings a great amount of joy to developers. The reason behind this is simple: with enough experience, you come to realize that straightforward and simple code is much easier to maintain than complex and hard-to-maintain code. Self-contained code with fewer dependencies is both easier to understand and refactor. In this video, I share one of my all-time favorite functions in Claris/FileMaker development, the Custom Function named Custom

FileMaker Magazine

FileMaker Magazine

Optimized Container Use

If you don't pay close attention to the fields you add to your record load in Claris/FileMaker, you might end up facing a transfer penalty, especially when dealing with container data. In many cases, your end users may not require the data from heavy multi-megabyte container fields. Nevertheless, every time the record data is loaded, that large container data gets included as part of the transfer. Unlike SQL or a document database, where you can request only the necessary data, FileMaker provid

FileMaker Magazine

FileMaker Magazine

Confirmation Prompting

One of the major challenges that any solution or developer encounters is effectively managing the growth of their solution. As the solution expands, the issue of "dilapidated code" arises. This refers to code that either gets replaced or continues to be used without being updated to leverage the latest enhancements in FileMaker. Consequently, a significant portion of the code may become obsolete over time. One of the most effective solutions to tackle this problem is the use of utility scripts

FileMaker Magazine

FileMaker Magazine

Running FileMaker Server in Docker Desktop

Being able to develop and test your solutions within a FileMaker Server environment is the ideal scenario. You can test Perform Script On Server, external binaries, and plug-ins that perform a variety of tasks. Essentially, you can perform all the necessary tasks in a real solution. When you develop your FileMaker solution locally with a single copy of Claris/FileMaker Pro, you not only face limitations in what you can test but also risk the possibility of a crash. While running FileMaker Serve

FileMaker Magazine

FileMaker Magazine

Adding Back Buttons

One of the most valuable features you can incorporate into your Claris/FileMaker solution is a back button. This feature is deeply ingrained in every individual who has ever used a web browser. It represents the common scenario where your mind recalls the previous location and seeks to return to it. However, the challenge lies in the complexity of your solution's navigation system. Without careful attention to simplifying navigation, there can be an overwhelming number of options that most peopl

FileMaker Magazine

FileMaker Magazine

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.