This FileMaker Pro file demonstrates the use of conditional formatting with a repeating field to draw the bars of a Code 39 (Code 3 of 9) barcode. This FileMaker Pro code 39 barcode generator uses a series of 16 “slots” per character which appear as wide or narrow bars. The intermediate barcodeBitFlags field simply tells each repetition of the repeating field whether or not to use a background fill color, creating the bars.
For the repeating field to display properly, the width must be set to 1 pt for each repetition that’s displayed. You will need 32 repetitions for the start and end characters (16 for each), in addition to 16 repetitions for each of the characters in the input field. An auto-enter calculation is used on the input field to remove invalid characters.
The good news about having this in native FileMaker objects is that you can adjust as needed for your specific usage. For example, if you want thicker bars, you can just increase the width of the repeating field. If you’re showing 200 repetitions, give it a try with a field width of 300, or 400. This will make the bars 50%, or 100% thicker than the original size.
The leading and trailing asterisk characters are required with Code 39 barcodes to indicate the direction of the barcode to the reader. These characters are not required with the “other” barcode plugin because that product supports only the Code 128 symbology instead of the Code 39 output. This alternate format could be implemented using the same bar/space methodology demonstrated in this file by changing the barcodeBitFlags calculation field to match the pattern in the bar/space column detailed online at:
Enjoy and let us know what ya think! Also please feel free to share, we just hope you give Excelisys a shout-out.
We’ve assembled a team of brilliant developers creative problem solvers and consummate professionals, workhorses and web wizards, who work tirelessly to provide you with the best custom solutions to your data management needs. If you’re looking for spineless, Fritos-munching, Mountain-Dew-drinking, living-in-mommy’s-basement, tunnel-visioned order-takers, you won’t find them at Excelisys. We only hire the best.
And you should too.
Our team brings more than 200 years of combined experience in custom database development and management to bear on your solutions. In developer years, just like in dog years, that’s closer to 1,400 years. And 1,400 years ago the Byzantine Empire still existed. Think about it.
We’ve worked with everyone under the sun-from Adobe, the Ayn Rand Foundation, Chevron and Cisco Systems to the University of Chicago, Yoga Journal and Zenith Travel-and they all love us. We know you’re probably thinking, “Those are all huge companies with truckloads of money.” Don’t worry about that; from our perspective, no job is too small! In fact, size really doesn’t matter to us. And unlike most people who say it, we really mean it. Just ask Ted Cheeseman, CEO of Cheeseman’s Ecology Safaris, or Neil King, President of King Shots, Inc., or Todd Golebiewski, Manager of River View Campground & Canoe Livery. You can even call them. Just check our references section and you’ll find their numbers there.
We’ve received the most feedback and some of the highest scores on FindFileMakerDevelopers.com, the data management world’s Service Magic-esque client feedback interface. See what our clients are saying: http://filemakertoday.com/filemaker-integration/item/excelisys?category_id=20.
Call us geeks, but we love solving database management problems. Seriously. And our love for what we do shows in the solutions we provide to our clients. And our solutions make our clients love us back. In fact, we have a 95 percent client retention rate. They just keep coming back for more.Website: www.excelisys.com