Barcodes

Exact Forms Plus

Create barcodes in Exact Forms Plus

To have Exact Forms Plus create barcodes in the generated document, you need to use a formula in the Word document template.

Note

This feature is only available in Exact Forms Plus version 11.4 and later. If you're not sure which version you're using, submit a technical support case.

The format of the formula is as follows:

~=barcode(f[99],BCtype,wxh)~

f[99] = field id of the field in the table that holds the data of the barcode

bctype = this is the type of barcode you want to create in the document (add -t or -b to the end for linear barcodes to control text display)

wxh = width and height of the generated barcode

Example:

~=barcode(f[123],qrcode,50x50)~

This example creates a 2D QR Code image in the output document using the data found in field 123 in the master table. The barcode is 50W x 50H.

For Linear barcodes, you can control whether to show the text for the barcode on the top, on the middle, or not at all.

~=barcode(f[123],code39-t,100x50)~—displays text on top
~=barcode(f[123],code39-b,100x50)~—displays text on bottom

~=barcode(f[123],code39,100x50)~—does not display the text at all

You can download a sample barcode document template to test the formulas below.

To test using this template:

• Create a formula URL field in your table and copy and paste this in the formula code: URLRoot()&"db/"&Dbid()&"?a=dr&rid="&[Record ID#]

• Download and edit the sample template. Replace the f[258] placeholders in the template with the field id of the URL field you created. Do the same for the other f[999] placeholders, or use other existing fields in your table, or delete any codes in the template you are not interested in.

• Upload the modified template to your Document Templates table.

• When running Exact Forms Plus, make sure you reference the record ID# of the new document template record you uploaded.

• When the document is created, a QR code is generated that displays the record in your table when scanned.

Supported barcodes