Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

FileMaker Pro Barcode FAQ & Tutorial

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

 

Integrate Barcode Automation Into FileMaker Applications, Reports, Forms and Databases

Want to add bar codes to FileMaker Pro? We created this bar-code tutorial to help FileMaker users integrate bar code automation into existing FileMaker applications, reports, forms and databases. Once setup, the barcode may be viewed and printed from a PC or Macintosh as long as the barcode font is installed on each system.

User Comments

"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)

Method 1 - using Self Checking Fonts, MICR and OCR fonts

Self Checking Barcode Fonts, MICR and OCR fonts are compatible with FileMaker and may be used with ease. To use a self checking font such as Code 39 (AKA code 3 of 9), you need to insert a "*" before and after the data encoded. Therefore, if you encode TEST3OF9 in a barcode, you would need to display the text *TEST3OF9* in a field with the Code 39 font selected.

In this example, we add a dynamic Code 39 barcode field to a FileMaker ID name badge database. The barcode is created when this field is included on a form or report and the proper barcode font is selected for it. You may also download the method 1 example.

  1. First, you must install one of our Code 39 font packages. We recommend the Code 39 Font Advantage Package because this package includes fonts for the PC and Macintosh.
  2. In this example, the Employee ID field is the one we want to include in the barcode. NOTE: The field type must be "Text" for any field you are creating a barcode for.
    In this example, the Employee ID field is the one we want to include in the barcode. NOTE: The field type must be "Text" for any field you are creating a barcode for.
  3. Choose File - Define Fields. For the field name choose "Barcode" and for the field type choose "Calculation", then choose Create.
    Choose File - Define Fields. For the field name choose "Barcode" and for the field type choose "Calculation", then choose Create.
  4. In the "specify calculation" field, enter "*" & Employee ID & "*" so that the asterisk is appended to the beginning and ending of the "Employee ID" field that is required for a Code 39 barcode. Choose OK and then Done. The new field has now been created.
  5. With the database form 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, you will need to drag the edges of it to make it larger so the barcode can fit on it. NOTE: If you fail to make this field large enough, the barcode will only display a rectangle instead of a barcode.
  6. With the "Barcode" field selected, choose Format - Fonts and choose one of our Code 39 Fonts. In this example, we choose the IDAutomationHC39S font which is a "human readable" font provided in our Code 39 Font Advantage Package . In this example, we also choose "align center" so the barcode will appear in the middle of the field and we change the font size to 14 so it can be easily scanned.
  7. Now, when you choose View - Browse you will see a barcode in the form. After the form is printed, the bar code can be scanned.
  8. The same process may be used to create a barcode on a custom report. In this example, we open the "Exposition Name Tag" report in "Layout Mode", add the barcode field below and change the font of the barcode field to the IDAutomationHC39S barcode font. After the report is printed, the bar code can be scanned.

Method 2 - Combining multiple fields in a single barcode

With Code 39, you can also easily add tabs between two fields in a single barcode (in extended39) for example enter:
"*"& DataField1  & "$I" & DataField2 & "*"
in the specify calculation field (see method 1 step 4 above).

Special ! Free Choice of Complete Excel Training Course or Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Send payment proof to [email protected] 31 days after purchase date.  All purchases can be made via Id-Automations site



Instant Download and Money Back Guarantee on Most Software

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS