Barcode Column

Barcode column and its formula counterpart allow entering specific code via input field on edit form and display it as QR code or barcode image on views, in record preview form and documents.

Barcode Column supports most of up-to-date industrial and retail 1D barcodes. Those are QR Code, EAN-13, UPC-A, EAN-8, UPC-E, Interleaved 2-of-5 and Standard 2-of-5 are all-digit codes. Code 128, Code 93 and Code 39 can be used to display alphanumeric input.

While editing TeamDesk performs basic validation for allowed characters and matching check digits according to barcode type.

On output TeamDesk generates vector based image (which scales perfectly) to both web pages and documents.

If the column comprises the data that don't look or behave the way you want, you may edit column General Properties and the properties defined by the column type.



Properties defined by the column type:

Barcode dimensions

Please note that on web pages the barcode images are generated using the most compact presentation. Narrow bar is exactly 1 pixel wide, height is set to either 15% of width or to 1/4 inch, whatever is larger.

By default, documents follow the same convention. You can override default size by specifying desired dimension via field code. Yet, to avoid subpixel rendering horizontal scaling is performed to multiples of minimal width (2x width, 3x width and so forth). If dimensions specified are not enough to display the image, #ERR is displayed instead.

QR Codes

QR codes use rather complex text encoding scheme. There are many ways to encode the same text and some ways are more efficient than others. While we are trying to squeeze as much as possible out of input text, we cannot do some transformation without your consent. For example, all uppercase letters take less space than lowercase letters. When encoding, say, link to your website, try uppercasing address and case-insensitive parameters. For example, below are two QR codes, one to the left is HTTP://TEAMDESK.NET and one to the right is http://teamdesk.net. See the difference?

On a side note we are using error correction level M for our QR code implementation. Hence up to 15% of data can be restored if printed QR code is damaged.

QR codes and links

While you can encode links to open your favorite website using QR codes there are couple of other link types that might be useful, especially on mobile devices. Please note, however, that support for those link types may vary depending on mobile OS and scanner application.

mailto:<email>?subject=<subject text>&cc=<cc-email>&bcc=<bcc-email>&body=<body-text>

Opens email program with new email message. subject, cc, bcc and body parameters are all optional but their support varies between scanner applications.

tel :+0123456789

Calls the phone number

facetime:+0123456789

Calls Apple FaceTime number.

sms :+0123456789

Opens messaging application with new text message to phone number.

smsto :+0123456789:<message-text>

Acts are previous one, but pre-fills message with specified text.

Other Options of the Barcode column

Help

When the Help text property is filled in, the question mark is displayed near the field name on the View/Edit form. If you point to this question mark, the pop-up with a tip or a help text message will be shown.

Next: Location Column