Barcode Font Encoder Plugin
integrates into FileMaker databases, reports and forms as a dynamic
- Supports many linear barcode types including Code 128, GS1 DataBar,
Code 39, Interleaved 2 of 5, UPC, EAN, Postnet and Intelligent Mail.
- 2D plug-ins for
QR-Code are available in their associated Font and Encoder packages.
- Compatible with FileMaker and FileMaker Pro Advanced versions
4 and higher for Windows and Mac environments.
- Time-saving templates designed to scale for large or small databases,
developers and standard users alike.
- Encode functions within a barcode to accommodate a wide variety
- Includes a database example with a barcoded form and report
that may be easily modified to support barcode types by changing
the calculated field.
- Free to use with the evaluation or purchased version of any
IDAutomation barcode font.
FileMaker Barcode Plug-In Overview
This FileMaker Barcode Font Plug-In easily integrates into FileMaker
databases, reports and forms as a dynamic calculated field, without
using special scripts when used with purchased or evaluation IDAutomation
barcode fonts. This FileMaker encoder tool supports many linear barcode
types, such as Code 128, Code 39, Interleaved 2 of 5, UPC, EAN, Postnet,
Intelligent Mail and more. The 2013 version of the plugin tool now includes
GS1 DataBar, Data Matrix, PDF417 and QRCode. This tutorial covers barcode
fonts, plug-ins and extensions for FileMaker versions 7 and higher on
Windows and Mac platforms.
Installation assistance and tutorial for
FileMaker Versions prior to 8.
FileMaker Pro Barcode Font
|"With the plug-in I was able to make the barcodes and print
them on Avery 6464 labels. The site also has a pretty good tutorial
(with lots of pictures) on how to implement a Barcode solution
using their fonts and plug-ins. I'd recommend this plug-in it
works fine.” - ISO FileMaker Magazine Forum
may be easily integrated into FileMaker as dynamic calculated fields
without the use of scripts. The barcode fonts and encoder tools used
in this tutorial are compatible with FileMaker Pro Advanced 10 and up.
Installation and Setup:
Install the selected barcode font and restart FileMaker to verify
that the fonts are available by viewing them in an application,
such as Word or Excel that allows font selection. If it is not
visible, restart the computer and try again. If the fonts still
do not appear, refer to IDAutomation's
barcode font problems and resolutions.
- First determine which barcode font to use:
Download the FileMaker Barcode Font Plug-In if using barcode
fonts other than
Code 39. Codabar and Code 39 are
and do not require the use of the plugin. 2D plug-ins for
QR-Code are available in the Integration folder of the associated package.
If FileMaker is running, restart the application.
- FileMaker Versions
8 and Up: Open the downloaded
IDAutomationFMplugin.zip file and copy
the "Windows Plugin\Version 8 and above" folder to the
Extensions sub folder
of the FileMaker folder. Example: "C:\Program
Files (x86)\FileMaker\FileMaker Pro 10 Advanced\Extensions". It will require administrative rights to add the plugin to the Extensions folder.
- FileMaker 8 and Up:
Open the downloaded
IDAutomationFMplugin.zip and copy the IDAutomation.fmplugin
file from the "Mac Plugin\version 8 and above" folder to
the 'Extensions' folder inside the FileMaker folder. Example:
"Applications-FileMaker Pro 10 Advanced-Extensions".
To verify that the plug-in is enabled, either create a "New
Database" or Open" a preexisting one off of the File menu.
Then select Edit - Preferences - Plug-in
on a Windows platform. On Mac OSX, select FileMaker Pro Advanced
- Preferences - Plugins. Click on the Plug-Ins tab to
ensure that the IDAutomation plug-in is enabled. Click the
checkbox in front of the plugin to enable, if not already.
Working with Self-Checking Barcodes
Self-Checking Barcode Fonts are the easiest to work with because
they do not require any encoding other than adding the start and stop
characters to make the barcode scannable. To encode numbers and uppercase
strictly numbers, consider
- With a database open,
choose File - Manage
- Database - Fields. For the field name, enter Code 39 Barcode
as in this example or other descriptive name. For the field type,
select Calculation, and then Create.
- On the Specify Calculation screen, in the field that
was named on the previous screen, for this example, enter
"*" & Field & "*" for Code 39
or "A" & Field & "B" for Codabar
so that the start/stop characters are appended to the beginning
and ending of the field will be encoded. Then at the bottom, choose
TEXT as the calculation result. The calculation that
is entered depends on the font used.
- FileMaker 9 and Prior: Apply the barcode font by right-clicking
on the Barcode Field and selecting the appropriate barcode font.
FileMaker 10 and above, while in layout mode highlight the Barcode
field and choose Format - Font - Configure/More Fonts
and select the appropriate font.
In this case, select IDAutomationHC39M for the Code 39 font.
|"It is simple and easy to integrate IDAutomation's fonts
into FileMaker Pro and as a Developer, I can't spend hours
with a simple Barcode - which in fact - technically spoken
- is quite complex. Therefore, it makes sense to first use
the Demo font and then simply buy the product.” - Alexis
Gehrt, Database Designs, Laax-Murschetg, Switzerland
- In the layout view, the Field Name will be barcoded,
but when switched to Preview View, the data itself is barcoded.
High Density Linear Barcodes
High Density barcodes, such as Code 128, Interleaved 2 of 5 and DataBar,
require additional encoding over and above what self-checking fonts
require. To encode numbers, punctuation, uppercase and lowercase characters
on a Windows platform and inside the USA,
is suggested. When creating complex barcodes, such as
GS1-128 or encoding functions such as Return or Tab, the
Barcode Font should be used with the IDAu_Uni_C128
function of the plug-in extension.
- With a database open, after creating the new field as outlined
above, choose External Functions
from the view of functions on the Calculation screen and select
the IDAu function that formats the data for barcode font
chosen. In this example, the IDAu_Code128 function was used in conjunction
with the Code 128 Font. Double-click on the function to have the
formula appear in the formula box.
IDAutomation's Code 39, UPC, EAN, MSI and
Interleaved 2 of 5 barcode fonts all have an equivalent Human Readable
version that may be used to display the text interpretation of the
encoded data. If Human Readable fonts are not being used but there
is still a need to have the text interpretation appear below
the barcode, select Insert - Field to add a special
field that consists of the data that will be encoded. This example
used "IDAu_Code128HR( Employee Number )" as the calculation field.
- Replace the text "parameter" with the field to be encoded
in the barcode from the Current Table options. Be sure to keep
the parenthesis as is and only change the parameter name.
- Select TEXT as the Calculation Result and click
OK. If database size is a concern, select Storage
Options and choose not to store the result in the database.
With the barcode fields now in the FileMaker report, choose
View - Browse Mode to confirm that the data is being
pulled dynamically from the fields and properly formatted to the
barcode font. Make sure that the data changes after moving to the
next record. When using the FileMaker Barcode Font Encoder Plug-in,
strange characters may appear in the field data, prior to applying
the font. This is normal encoding for the barcode font. When using
Barcode Font, a large amount of letters will appear and this
is normal as well.
Working with the Universal
When working on a Mac OSX platform, the
Barcode Font creates multiple Linear barcode types, such as
Interleaved 2 of 5,
USPS Intelligent Mail IMb from a single font and is the preferred font
when creating barcodes outside of the USA to avoid language and locale
DataMatrix, PDF417 or QR-Code
To encode large amounts of data, 800 characters or less, consider
meCards or VCards.
- Go to File - Manage - Database and create a new Field
Name and choose "Calculation" as the Type field and
- Choose External Functions from the view of functions
and select the IDDM for Data Matrix, IDPD for PDF417
or IDQR for QR-Code function that formats the data for barcode
font chosen. Double-click the function so the formula appears in
the formula box. Select TEXT as the Calculation Result and
choose OK. If database size is a concern, select Storage
Options and choose not to store the result in the database.
- With the database form or report open, choose View -
Layout Mode. Choose Insert - Field and select
the field named Barcode from the list of fields and choose
OK. After the barcode field appears on the form, size the
edges appropriately, if necessary, so the barcode can fit on it.
If this field is not large enough, the barcode will display a rectangle
instead of a barcode or a corrupted barcode may be created that
will not scan.
- While in Layout Mode, which
can be selected under the View Menu, highlight the Barcode
field and choose Format - Font - Configure/More Fonts.
On the next screen, select the appropriate barcode font and
move it over to the Appear in Menu column and click Apply to have
the barcode font applied to the field selected. If the fonts are
not in a readable format, deselect the "Show Fonts in Typeface"
Once the font has been moved, it will be listed under Format
> Font for future barcoding needs.
The "Inspector" window that can be accessed under the View
menu will also allow users to configure and apply the barcode font.
- Change to Preview Mode and confirm the barcode is complete.
- Choose Format - Align Text - Center to move the barcode
to the middle of the field, and then select the 12-point font size
or other size of choice.
|"We just purchased the product. I am using your fonts
with FileMaker and doing a software inventory for the Government.
It works great and I have found it very easy to set up.
Thanks again" - David Sinclair, APV4 Contractor (FPI)
- Choose View - Browse to verify that a barcode
displays in the FileMaker form or report. After printing, the barcode
may be accurately scanned with an
- If the FileMaker application that is being created is also going
to be distributed, the FileMaker Barcode Font Encoder Plug-in and
barcode font must also be distributed along with the database.
Creating GS1-128 Barcodes
The best way to generate GS1-128 barcodes is using the
IDAu_Uni_C128 function with the IDAutomation
Barcode Font. In the example below, the
~202 adds the FNC1 character before
the data and the |1 is the parameter
that sets the "apply tilde" to true, enabling the encoder to interpret
the ~202 correctly.
Human-readable text may be generated
beneath the GS1-128 barcode by inserting a new field and selecting the
plug-in function of IDAu_Uni_C128HR. In the example below, the following
string was used in the calculation field
Functions and Combining Multiple
Combining multiple fields into a single FileMaker barcode is easily
achieved when ApplyTilde is enabled. For example,
the following would encode "File" <Return> "Maker" <Tab> "Pro":
Combining two data fields with a tab between:
& "~009" & Field_2 & "|1")
With supporting symbologies, tabs may also be added by copying an
actual tab out of an application, such as Microsoft Word and adding
quotes around it, for example “
Barcode Function Method Names
The barcode functions listed below are available in the FileMaker
Barcode Font Encoder Plug-in and are only valid when used with the font
listed in the "Font to Use" column. Functions beginning with
IDAu_Uni should only be used with
Universal Barcode Font Advantage package.
Some of the barcode functions below have multiple parameters. When
this occurs, use the '|' (pipe) as the dividing character for these
additional parameters. If the additional parameters are omitted, defaults
will be used.
Barcode Function Method Definitions and Descriptions
- DataToEncode: A string value
that represents the data that is being encoded. Within FileMaker,
fields may be specified directly and text should be represented
in double quotes. Additional parameters are optional and are separated
with the "|" pipe character.
& GS1_Data_Field & "|1")
- N_Dimension: Determines the
width of the wide bars, which is a multiple of the X dimension.
The X dimension is determined by the font point size. Valid values
are 2, 2.5 and 3. The default is 2.
- IncludeCheckDigit: If
this value is 1, a check digit will be calculated automatically
and included in the barcode, if appropriate, for the chosen symbology.
Universal Font Example:
- ApplyTilde: In IDAu_Uni_C128,
the ApplyTilde option is set to 1, the tilde will be processed
to allow encoding of ASCII characters and generation of GS1-128
barcodes. Note: Parentheses may not be used
to encode the FNC1 character within IDAu_Uni_C128.
- ProcessTilde: In Data Matrix
and QR-Code when set to 1, the tilde will be processed to allow
direct encoding of
ASCII characters according to the format dnnn.
For example; ~d009 is
used to encode a tab and ~d013
encodes a return.
- IDAu_Code128: IDAu_Code128
only functions properly on FileMaker when
the system regional setting is
set to "English" and the 1252 Latin-1 codepage. To overcome
these issues, IDAutomation recommends using the
Barcode Font with the IDAu_Uni_C128
function. Within IDAu_Code128, the FNC1 character may be included
with the "Ê" ASCII 202
- PDF417 Parameters:
- EcLevel As Integer - This is the
Error Correction Level and acceptable values are 1-8.
- TotalColumns As Integer - This sets the
- TotalRows As Integer - This sets the number
- Truncated As Integer - Set to 1 for
truncated and 0 for non-truncated.
- PDFMode As Integer - The default of 0 is
binary mode; 1 is text mode which only encodes ASCII 9, 10,
13 and 32 - 127.
- ApplyTilde As Integer - Set to 1 for enable
Apply Tilde and 0 to disable.
Common FileMaker Barcode Font Problems and Solutions
Other FileMaker Barcode Products
Back to Top