Forum Discussion

Qrew Captain

9 years ago

Can you generate a barcode from a key field calculation

Has anyone come up with a native solution to generate a barcode that could be printed out to put on a piece of equipment for asset tracking. I have a key field calculation for the piece of equipment a...

Formulas and functions

Qrew Captain

9 years ago

Barcode Key Field (This field used to calculate a barcode number)

ToNumber("[Store #]")&
[Record ID#]&
[Related Store]&
[Equipment Type]

Barcode Link (URL Formula)

"http://www.keepautomation.com/online_barcode_generator/linear.aspx?DATA="&[Barcode Key]&"&TYPE=7"

Barcode Image (Text Formula)

"<img src=" &[Barcode Link]& ">"

I have not tried to use a QR code yet. The link above is for a Code 128.

JoshuaSmith
Qrew Trainee
6 years ago
Joey,

Thank you for this have u figured out a way to do a QR code for this. The 128 works great but I really need a QR for some of my items

------------------------------
Joshua Joshua
------------------------------
- AdamKeever1
  Qrew Commander
  6 years ago
  Here is code for a QR using the google api:
  "<img src=\"http://chart.apis.google.com/chart?cht=qr&chs=120x120&chl="
  &[Part]
  &[Quantity In]
  &[Non-Conformity Description]
  & "\"\"/>"
  
  Sub your field names in the square brackets.
  
  ------------------------------
  Adam Keever
  ------------------------------
  - JoshuaSmith
    Qrew Trainee
    6 years ago
    Adam Im getting an error message on the brackets at the end Please see
    
    "<img src=\"chart.apis.google.com/...
    &[N Project Number]
    &[Customer - Full Name]
    &[Project Status4]
    &"\"\"/>
    
    There are extra characters beyond the end of the formula.
    
    "<img src=\"chart.apis.google.com/...
    &[N Project Number]
    &[Customer - Full Name]
    &[Project Status4]
    &" \"\"/>
    
    More on syntax errors...
    
    Please advise I am getting a syntax error.
    
    ------------------------------
    Joshua Joshua
    ------------------------------