Jump to content
  • entries
    69
  • comment
    1
  • views
    2044

Entries in this blog

Create a powerful layout design in FileMaker

Typically, portals in FileMaker are used for showing related data. However, a portal based on the same table as its layout would simply display the current found set. If you made the portal large enough, the layout would appear as a list view- which wouldn’t be very helpful. So, in this blog, we will make the portal smaller and create a powerful layout design, the Master Detail portal. If data requires or if users request […] The post Create a powerful layout design in FileMaker first appeared

MainSpring

MainSpring

Reviewing the GetLayoutObjectAttribute function in FileMaker

This versatile function offers quite a bit of value to any developer’s toolkit. It gives us the ability to interrogate the state of different layout objects (also called introspection) which allows us to make our calculations and scripts smarter. Today we’re going to just focus on a one of the options, the attributeName parameter to take a look at some interesting behavior that could be leveraged as another tool in our developer toolbelt.  Parameters objectName – in order to use this

MainSpring

MainSpring

Caching data to improve layout performance in FileMaker

During agile development in FileMaker, sometimes you may notice an unwanted performance difference after adding a new feature, or display a new field to a layout. In this blog, I’d like to address what I have found to be the most likely culprits of the slow and unwanted Find or Sort dialogs on FileMaker layouts: summary fields and “unstored calculations”.   Inside the storage options of the calculation field definition is where developers decide if a calculation is stored or unstored

MainSpring

MainSpring

Sorting portals dynamically using FileMaker

A common feature I like to provide on my FileMaker list view layouts is clickable headers that sort records based on that column. Realistically, you don’t always have the luxury of being in a simple 1 table list view. In this blog, I will walk through a consistent way to dynamically sort related data in portals, using the column headers. I would like to preface this blog by saying this is not a concept I invented. It was taught the concept from a coworker – who learned it from a blog or

MainSpring

MainSpring

When to think about abstraction

Overview of when it would be beneficial to use abstraction in FileMaker Sometimes you can benefit from a method called abstraction where you use what’s called “indirection.” Indirection is a way that you can automatically iterate through a series of steps like set variable or set field. For instance, let’s say you needed to bring the contents of one set of fields in a table and create new related records in another, a process very common when dealing with legacy app data after import

MainSpring

MainSpring

Naming files through scripting in FileMaker

Choosing the Name From exporting data to excel sheets to custom print layouts, automated naming for exported files can help with organization and create a more professional look. The first thing to consider when scripting to automate file naming would be to determine a field that makes the record or set of records unique. For single records, it will most likely be a user facing identification field such as, Job Number, Serial Number, or perhaps Username and Job Title as long as it’s

MainSpring

MainSpring

Naming files through scripting in FileMaker

Choosing the Name From exporting data to excel sheets to custom print layouts, automated naming for exported files can help with organization and create a more professional look. The first thing to consider when scripting to automate file naming would be to determine a field that makes the record or set of records unique. For single records, it will most likely be a user facing identification field such as, Job Number, Serial Number, or perhaps Username and Job Title as long as it’s

MainSpring

MainSpring

Generating Fake Data with FileMaker’s Improved JavaScript Integration

Learn how to generate massive amounts of test data in your FileMaker app by leveraging new FileMaker 19 features that allow you to interact directly with JavaScript. Part of good app development is testing with conditions that are similar to the environment you can expect your app to eventually operate in. One of those conditions is the amount of data your app is working with. It’s a not infrequent occurrence that someone comes to us with a system that worked well with a few records but

MainSpring

MainSpring

Generating Fake Data with FileMaker’s Improved JavaScript Integration

Learn how to generate massive amounts of test data in your FileMaker app by leveraging new FileMaker 19 features that allow you to interact directly with JavaScript. Part of good app development is testing with conditions that are similar to the environment you can expect your app to eventually operate in. One of those conditions is the amount of data your app is working with. It’s a not infrequent occurrence that someone comes to us with a system that worked well with a few records but

MainSpring

MainSpring

FileMaker 19 Add-ons And You

Overview of the new Add-ons feature in FileMaker 19 With FileMaker 19 comes several new tools that bolster the toolkit we have access to as developers. Among them is the Add-ons feature which allows you to simply select pre-developed features to quickly add and remove from an existing app. This affords us an order of magnitude leap in our ability to iterate when working on our apps. If we consider what the process looked like before we can recognize the substantial benefits in terms of t

MainSpring

MainSpring

FileMaker now supports Machine Learning

Breaking down FileMaker’s new (and really easy) way to implement machine learning. With the release of FileMaker 19, an extremely easy way to implement very complex machine learning has been made available to MacOS and iOS FileMaker custom apps. Machine Learning offers the ability to automate “identification and analysis” processes by using trained machine learning “models”. With FileMaker, it’s now easy to script an entire decision tree with both machine learning and human interaction; L

MainSpring

MainSpring

FileMaker now supports Machine Learning

Breaking down FileMaker’s new (and really easy) way to implement machine learning. With the release of FileMaker 19, an extremely easy way to implement very complex machine learning has been made available to MacOS and iOS FileMaker custom apps. Machine Learning offers the ability to automate “identification and analysis” processes by using trained machine learning “models”. With FileMaker, it’s now easy to script an entire decision tree with both machine learning and human interaction; L

MainSpring

MainSpring

FileMaker 19 Add-ons And You

Overview of the new Add-ons feature in FileMaker 19 With FileMaker 19 comes several new tools that bolster the toolkit we have access to as developers. Among them is the Add-ons feature which allows you to simply select pre-developed features to quickly add and remove from an existing app. This affords us an order of magnitude leap in our ability to iterate when working on our apps. If we consider what the process looked like before we can recognize the substantial benefits in terms of the

MainSpring

MainSpring

Automating emails using FileMaker 18’s Send Mail script step

As FileMaker developers, it’s common practice to need to contact the client records stored in the database, often scheduled daily, or weekly, or by a specific event. Without FileMaker’s ability to automate emails, this could become very time consuming. This blog post will cover the essential scripting techniques required to save time by automating emails and optimize communication with clients by attaching files. The Send Mail script step Right off the bat, the most important thing t

MainSpring

MainSpring

Automating emails using FileMaker 18’s Send Mail script step

As FileMaker developers, it’s common practice to need to contact the client records stored in the database, often scheduled daily, or weekly, or by a specific event. Without FileMaker’s ability to automate emails, this could become very time consuming. This blog post will cover the essential scripting techniques required to save time by automating emails and optimize communication with clients by attaching files. The Send Mail script step Right off the bat, the most important thing t

MainSpring

MainSpring

MainSpring adds FileMaker licensing to GSA Schedule

FREDERICK, MD—MainSpring, a FileMaker Business Alliance Platinum member and four-time North American FileMaker Partner of the Year, recently announced its exclusive letter of supply for FileMaker 18 licenses on the GSA Schedule, making it simpler and more affordable for government entities to purchase FileMaker licenses. This is the most recent addition over the span of their 20-year Schedule. The FileMaker licensing offering will serve as a complement to MainSpring’s existing FileMaker

MainSpring

MainSpring

MainSpring adds FileMaker licensing to GSA Schedule

FREDERICK, MD—MainSpring, a FileMaker Business Alliance Platinum member and four-time North American FileMaker Partner of the Year, recently announced its exclusive letter of supply on the GSA Schedule, making it simpler and more affordable for government entities to purchase FileMaker licenses. This is the most recent addition over the span of their 20-year Schedule. The FileMaker licensing offering will serve as a complement to MainSpring’s existing FileMaker development and FileMaker

MainSpring

MainSpring

When is it time to rebuild your app?

The reincarnation decision Whether it’s from age, functionality or neglect, all software eventually reaches its end of life. When we approach custom software with a client, we normally will evaluate several factors before deciding whether our engagement will be simple support, light rebuild or even a complete ground up reincarnation. Here are some of the factors we consider: Cost Cost is the factor that clients are interested in hearing our thoughts on; But it’s also one of

MainSpring

MainSpring

When is it time to rebuild your app?

The reincarnation decision Whether it’s from age, functionality or neglect, all software eventually reaches its end of life. When we approach custom software with a client, we normally will evaluate several factors before deciding whether our engagement will be simple support, light rebuild or even a complete ground up reincarnation. Here are some of the factors we consider: Cost Cost is the factor that clients are interested in hearing our thoughts on; But it’s also one of

MainSpring

MainSpring

Understanding FileMaker’s Data API

An API (application program interface) is a set of routines, protocols, and tools that specify how software components should interact. The purpose of the FileMaker Data API is to allow web services to access data in hosted databases. The FileMaker Data API conforms to Representational State Transfer (REST) architecture, so you may hear it referred to as a REST API. Your web service or application can make calls to the FileMaker Data API in order to get a token that authenticates the co

MainSpring

MainSpring

Understanding FileMaker’s Data API

An API (application program interface) is a set of routines, protocols, and tools that specify how software components should interact. The purpose of the FileMaker Data API is to allow web services to access data in hosted databases. The FileMaker Data API conforms to Representational State Transfer (REST) architecture, so you may hear it referred to as a REST API. Your web service or application can make calls to the FileMaker Data API in order to get a token that authenticates the co

MainSpring

MainSpring

Providing clarity for FileMaker Cloud

With the release of the latest generation of FileMaker Cloud, Claris has taken a big leap into cloud-based infrastructure on the FileMaker platform. However, using the name FileMaker Cloud, when there is another legacy version of FileMaker Cloud, as well as FileMaker Server on the cloud, things start to get confusing. I’ll try and outline some of the key differences in this article. FileMaker hosting products There are three FileMaker products to consider when hosting your FileMa

MainSpring

MainSpring

Providing clarity for FileMaker Cloud

With the release of the latest generation of FileMaker Cloud, Claris has taken a big leap into cloud-based infrastructure on the FileMaker platform. However, using the name FileMaker Cloud, when there is another legacy version of FileMaker Cloud, as well as FileMaker Server on the cloud, things start to get confusing. I’ll try and outline some of the key differences in this article. FileMaker hosting products There are three FileMaker products to consider when hosting your FileMa

MainSpring

MainSpring

MVP vs MVP: Minimum Viable Product vs Most Valuable Product

If I were to mention MVP vs MVP, what would be the first thing that comes to mind? For most people, they would be envisioning the greatest rivalries and epic battles in sports history. Perhaps Larry Bird vs Magic Johnson, or Peyton Manning vs Tom Brady, or Sidney Crosby vs Alexander Ovechkin. After all, the acronym MVP is mostly associated with Most Valuable Player. Within the agile development community, however, the acronym MVP represents something entirely different… The Minimum

MainSpring

MainSpring

MVP vs MVP: Minimum Viable Product vs Most Valuable Product

If I were to mention MVP vs MVP, what would be the first thing that comes to mind? For most people, they would be envisioning the greatest rivalries and epic battles in sports history. Perhaps Larry Bird vs Magic Johnson, or Peyton Manning vs Tom Brady, or Sidney Crosby vs Alexander Ovechkin. After all, the acronym MVP is mostly associated with Most Valuable Player. Within the agile development community, however, the acronym MVP represents something entirely different… The Minimum

MainSpring

MainSpring

×
×
  • Create New...