FileMaker Tips

Now is the time to upgrade your legacy FileMaker Pro app

With impending updates to NRGship FM for UPS and FedEx, there is no time better than now to upgrade your end-of-life (EOL) FileMaker application. As of June 2024, EOL versions are defined as any release before FileMaker v19.6 from December 2022.

Besides the need to update for NRGship FM compatibility, there are numerous additional benefits according to Claris Partner Harlow Technologies.

  1. Pushing off updates makes future updates harder
  2. Lack of Claris support
  3. Older versions of FileMaker Go are not available on the AppStore
  4. Fixes for security vulnerabilities
  5. Newer is better – there are many time-saving features in new versions of FileMaker Pro

The other benefit we would add is compatibility with newer operating systems and hardware. Old versions of FileMaker Pro likely will not run on newer Macs. By upgrading at least to FileMaker 19.6 you have compatibility with the latest OS releases. If you have older hardware, any Mac since 2012 can be updated to macOS Catalina 10.15. This provides a base environment to mix old and new hardware so you can make plans  for future hardware and software updates.

The current NRG support policy states that NRGship requires a minimum of Claris FileMaker Pro v18 however it may work with older versions.

If you need assistance with upgrading or FileMaker licensing, please contact our sales department.

2024-05-02T17:49:37+00:00May 2nd, 2024|FileMaker Shipping, FileMaker Tips|

What’s the best barcode scanner to use with Claris FileMaker Pro?

We recently saw a posting on a FaceBook group requesting some help with barcode scanning in Claris FileMaker Pro. Handheld barcode scanners provide far greater speed and accuracy with data capture vs using a camera on a mobile device. Barcodes are fantastic for quick entry of invoice numbers, pick slips, skus, inventory location and so much more. Previosuly we’ve talked about data capture with Zebra mobile devices however a USB or bluetooth scanner can also be connected to your desktop or mobile device. While there are a plethora of barcode scanners available, Zebra barcode scanners are very rugged and provide the ability to configure to send pre/post scan data which provides for much more robust integration. We also recommend barcode scanners with 2D capabilities so you can leverage smaller QR or other similar symbologies that can pack larger amounts of data in a small space. By purchasing a scanner with 2D functions can you future-proof  your hardware investment.

Zebra DS2200

Zebra DS2200 Series Barcode Scanner

Zebra DS2208 – USB 1D/2D For around $100 this cabled scanner will provide a lifetime of use.


Zebra CS60 – Bluetooth Companion 1D/2D While a little more costly, this scanner can connect to a desktop or mobile device and provides durability and the ability to charge thru QI inductive charging.

Zebra/Motorola Symbols DS6878-SR 1D/2D – Budget Option This discountinued model is available on Amazon at a huge savings and can be used cabled or wireless.

In the video below we walkthru how to implement barcode scanners in Claris FileMaker Pro. By using  pre-scan options available on Zebra scanners you can execute a FileMaker script before the scanned data is passed. This allows you to send the cursor to a specific layout/field or display a dialog for data capture so that your users aren’t required to click in specific fields before scanning.


Contact us if you’d like to discuss using barcodes with FileMaker Pro!

2023-07-15T22:36:59+00:00May 23rd, 2023|FileMaker Tips, Tools & Tips|

Here’s how to upload multiple images using JavaScript in FileMaker Web Viewer

A question was recently posted about the limitation of FileMaker’s native scripting which only allows importing single images from a mobile device’s camera app. Using a WebView and simple JavaScript, we can utilize a HTML form which can import multiple images. Those images are then converted to Base64 text and passes to a FileMaker Script which then parses them out into multiple records. This method will work in the FileMaker app, in FileMaker Go, or in WebDirect for iOS and Android users.

Uploading multiple images is easy with basic scripting

I started out by searching for a suitable form and existing JavaScript for the image capture. I found a lot of samples, but had issue getting JS file objects converted over to Base64. This sample was perfect as it already had code which turned the images into JSON and Base64 which would be super easy to parse in my FileMaker script.

I created a simple database to store the HTML data which the webview would render. I then added another field for the actual images. When the form is submitted, it calls FileMaker.PerformScriptWithOption and passes the JSON data. The FM script then performs some substitution on the form data so it parses properly so that it can decode the Base64 data into the container field.

You can download our sample file here. The file has a default user/pass of admin/admin.

Another option to research for multiple uploads is elemental_dropzone. Usability is similar for file browser image selection, but the JavaScript looks to be more complex.

Contact us if you’d like to discuss any of your complex FileMaker Pro needs!

6/8/2023 – Sample file updated, initial version only properly parsed PNG images, now parses JPEG files too.

2023-06-12T19:08:00+00:00March 5th, 2023|FileMaker Tips, General|

Join us at AutoEnter Live 2022


AutoEnter Live

NRG Software will be a sponsor at the AutoEnter Live: a 2-day virtual conference for the Claris Community on July 19 & 20. This event is free to attend and is being hosted by Proof+Geist and Soliant Consulting. Register for free on the AutoEnter Live website.

As a long-time sponsor of FileMaker DevCon, we’re excited to connect with the Claris developer community again. Drop by our virtual booth to hear about best-practices for shipping with FileMaker Pro, including how to use our carrier-certified NRGship solutions, Claris Connect or integrations with other web services. You’ll see how you can have shipping labels created right from your database in under 10 minutes to simplify your workflow and reduce shipping errors. While you’re there, don’t forget to signup to win some UPS unstoppable gear.



2023-03-07T23:05:49+00:00July 11th, 2022|FileMaker Shipping, FileMaker Tips, General, Press Releases|

Create device-agnostic HTML links for mapping data

We recently did a project where HTML emails were generated with a list of stops for a delivery route. During the testing phase, we found that creating map links across devices was not so simple.

Apple Maps Link

Apple’s iOS URL handler is maps: but the preferred method is to use with the location data. If you use this URL instead, it will open in the Apple Maps app on iOS/macOS or redirect to Google Maps on Windows/Android.

To display a map for a specific address, you would use a link like <A href=”,Infinite+Loop,Cupertino,California”>Map</A>

To display a map with a given latitude and longitude, you would use a link like <A href=”,4.341626″>Map</A>

For more information on Apple Maps links, check out the Apple Developer Documentation.

Google Maps Link

Sometimes mobile users don’t like the Apple Maps application and would prefer to use Google Maps instead. On iOS, there is no way to set a default Maps application so the workaround is to use a universal URL, simpliar to the Apple Maps URL. If the Google Maps app is installed on iOS or Android, the link will open in the app, otherwise it will open the map in the default web brower.

To display a map for a specific address, you would use a link like <A href=”,Infinite+Loop,Cupertino,California”>Map</A>

To display a map with a given latitude and longitude, you would use a link like <A href=”″>Map</A>

For more information on Google Maps links, check out the Google Maps Platform Documentation.


Note that all maps links should be properly URL encoded. Each mail application handles links differently and you must encode or you may face issues. If you are using Claris FileMaker Pro, a function like GetAsURLEncoded can be used to encode your link data.

Preferences are always nice

If possible, add a preference for each email recipient so that you can dynamically create the map link based on their desired map provider.

While our primary development efforts at NRG revolve around shipping and carrier APIs, we often assist other Claris developers with projects related to other APIs. Contact our sales department for more information on our custom development services.

2023-02-24T21:38:08+00:00February 2nd, 2022|FileMaker Tips, General|

Connect WordPress Ninja Forms to Claris FileMaker Pro


We recently saw a posting on a FaceBook group requesting some help with sending WordPress form data from Ninja Forms to Claris FileMaker Pro thru the Data API without the need for the paid add-on Ninja Forms Webhook plugin. Even with the Ninja Forms Webhook plugin, you’d still need server-side code that would take the form data and convert it into a format that could be used with the Data API.

Soliant Consulting has an article with code for FileMaker 17 but the poster had issue getting it to work with FileMaker 19.

FileMaker Webhooks

We’ve built FileMaker webhooks for a varity of needs in the past and have found that creating a generic table to accept data is an easy way to add future functionality without having to change a lot of PHP code. Processing of the data is then handled inside of FileMaker with common scripting.

We created a github project for this free Ninja Forms plugin in hopes that it will benefit other FileMaker Pro users.

This project consists of two parts – the first is a WordPress plugin that you modify for your FileMaker Server host, and then upload to your web server. The second part is a FileMaker database that accepts the submitted form data. Please consult the readme file that is included with the download for a walkthru of configuring the plugin.

Our Approach

In order to simplify submission of multiple forms, we take an approach where we use a simple table that has two basic fields – the form name, and the form data as JSON.

Sample form data

There is then a script, Process Webhook, that gets invoked and that can be used to parse out the data for other needs. For example, if the form_title value is “Contact Me” then the script could create an entry in a “To Do” database for a salesperson so that they make contact with the person who submitted the form. Using a common table also allows for business logic in the processing script – for example, you don’t want create duplicate records in your CRM or you may want to add some filtering for invalid data.

If you’re interested in hearing more about how NRG can help connect your FileMaker database with WordPress, please contact our sales department.


2023-03-07T22:55:21+00:00September 20th, 2021|FileMaker Tips, Tools & Tips|

Here’s how to create FileMaker server-side Snapshot Links


Have you tried to create Snapshot Links in your server scripts but they fail when users try to open them? When creating Snapshot Links with server-side scripts, the IP of the host is used to create them which leads to invalid Snapshot Links for clients running outside the local network. Often, the host IP is an internal IP number which is not accessible to the outside world. When these Snapshot Links are emailed to users, they throw an error when they try to open them. Snapshot Links created using the FileMaker Pro application don’t have this issue because the links are built using the host used to access the database file, which should be a fully-qualified domain name (FQDN) if you’re using best practices.

Snippet from a Snapshot Link file showing the internal IP numbers

Using the Data File script steps that have been available since FileMaker 18, you can easily read in the Snapshot Link file, replace the IP number for, and then send the Snapshot Link in an email from a server script.

In the sample script below, we first go to the proper layout, record and sort order that we want the user to be on when they open the Snapshot Link. We then save the Snapshot Link. Once saved, we open the file and read the contents. The contents then have a simple subsitute to replace with the valid FQDN of the host. We then write the file back to disk and send it out as an email attachment. Problem solved!

Using FileMaker Data File script steps to fix the Snapshot Link file

NRG Software has utilized Snapshot Links to automate server-side reminders for common business needs like Reorder Emails, CRM follow-ups, etc. Please contact us if you’d like to discuss adding server-side automation to your FileMaker Pro solution.


2023-03-07T23:01:36+00:00August 26th, 2021|FileMaker Tips, General|

Updating FileMaker data with Zebra mobile devices


We were recently working on a project where we needed to verify order fulfillment and staging prior to pickup by the shipping carriers.

In most instances, we’d use FileMaker Go on an iPod Touch or iPad for mobile users, but this project required that we scan barcodes quickly for optimum performance.

As a proof of concept, we created a simple FileMaker Web Direct interface so that staff could scan boxes as they were packed, and before they were put onto a pallet. The Zebra TC20 is an Android 8.1 device that accesses Web Direct with it’s Chrome browser thru a wireless connection. The TC20 is ruggedized and features a built-in barode scanner which is perfect for use in a warehouse environment.

In the video below, you can see how this streamlined interface works. The user can choose from two scanning modes – one to verify packing and the other to mark which pallet the package is on awaiting pickup. We used just a single field for barcode scanning to reduce the overall complexity.

One option we considered was using FileMaker Go on an iPod Touch or iPad. We decided not to go this route for a variety of reasons:

  • Scanning with a Zebra handheld is significantly faster than using a handheld barcode scanner or iOS camera
  • Scanning barcodes is trickier with multiple appearing on the package. We wanted to reduce the chance of false-scans using the camera on the mobile device
  • External barcode scanners on iOS can be clunky to use. With the Zebra it’s one device to manage.
  • Using the the iPod Touch or iPad would require a ruggedized case
  • There’s greater chance of loss of device with an iPod Touch or iPad with seasonal staff
  • Using a iPod Touch sled like the Linea Pro adds considerable cost and requires the use of custom plugins along with the iOS App SDK.

Another alternative to using Web Direct is building a native web app that communicates with the FileMaker backend using the Data API to update order status.

Please contact our Sales Department for further information if you’d like help creating a mobile warehouse solution.


2023-12-11T21:24:01+00:00July 27th, 2021|FileMaker Shipping, FileMaker Tips, General, Tools & Tips|

Who uses serial scales?


I was recently on a west coast virtual meetup event and there was a discussion about plugins and someone chimed in asking “who uses serial scales?” (or something like that…) With 20+ years of experience working with Claris FileMaker Pro customers in a warehouse, it’s fairly common for us to interface with these devices.

First off, scales used on a shop floor are very industrial and expensive. The Mettler Toledo PS60 looks to be bomb-proof and costs over $500. While current PS60’s have a USB interface, older models rely on the trusty serial protocol. We recently did a shipping integration where a customer had a flashy new dimensionalizer (that cost thousands of dollars) with a serial interface.

Mettler Toledo PS60

Talking to Serial Scales from FileMaker Pro

Interfacing with a serial scale from FileMaker Pro is easiest with a plugin like MBS or Troi Serial. Both work equally well for this use case. In the scripts below we go thru a simple process – we open a serial port, we then send some data to the device (based on device spec, some require a CR/LF or some other characters), then we receive a response back. Some scales return fractional values so we then apply a modifier as needed to get a proper weight in pounds.

Capturing the weight with MBS
Capturing the weight with Troi Serial

Note that on the Mac, you need to have an adapter for a serial scale. The preferred Tripp-Lite/Keyspan USA19-HS adapter requires drivers which will not work with macOS Big Sur. There are some serial to Bluetooth adapters which will provide connectivity for macOS.

The Keyspan USA19-HS Adapter

But what if you don’t like plugins? If you’re in the mood for a science project, you could build a microservice with a Raspberry Pi that communicates with a serial or USB scale, but then exposes it to FileMaker thru CURL. But why waste time when using a plugin is so simple?

If you don’t like science, another alternative is PrintNode, a paid service that installs on your desktop and provides an interface to scales (and printers) thru HTTP requests. PrintNode requires a bit of setup and configuration but is very powerul. One benefit of PrintNode is you can then capture weights using your app with FileMaker Go or FileMaker WebDirect. This opens a whole new world to mobile warehousing.

Alternatives to Serial Scales

Some USB scales are simply serial devices with a USB adapter. When you look at them from the operating system, they require a driver and show as a COM port or some variant. Other USB scales act as HID devices and require special applications to communicate with them using a USB vendor and product ID. We’ve found that dimensionalizers have the ability to communicate over IP using simple HTTP requests.

NRGship solutions for FileMaker have the ability to communicate with scales using serial, HID, PrintNode or IP. NRGship allows you to quickly integrate UPS, FedEx, USPS and LTL validation, rating and shipping into your app.

Please contact our Sales Department for further information if you need help communicating with scales from your own FileMaker Pro app.


2023-03-07T23:17:30+00:00May 26th, 2021|FileMaker Shipping, FileMaker Tips, General|

FileMaker Pro Image Magnifier

We recently worked on a project where a container field contained a detailed image and thought it would be useful if the user could zoom in on some areas.

With a FileMaker web viewer you can make use of JavaScript to add funtionality in FileMaker that doesn’t exist. With a quick Google Search we found a library that allowed magnification of images. We then created a test HTML document that magnified an image. That text was copied into a global template field and we replaced the image URLs with slugs. We then created a calc field in FileMaker to replace the slugs with container data encoded as Base64. In the video below, you can see how we went thru the process of adding the calculation.

Download Sample File

5/2/2023 – Sample file link has has been updated

7/6/2021 – Sample file has been updated so that the image is scaled to fit the webviewer size in the calc field.


2023-05-17T20:37:23+00:00April 4th, 2021|FileMaker Tips|
Go to Top