Can you generate a barcode from a key field calculation

  • 2
  • 2
  • Question
  • Updated 11 months ago
  • Answered
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 and want to turn that into a barcode

The next item is to embed in the barcode a url to a PM form for that piece of equipment. I have already played with a QR code generator, set the code as a url to a form. I can scan the code and it takes me to the form. But now I want to tie that all together.....always a challenge!
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb

Posted 2 years ago

  • 2
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
Joey,
There was an old post in the previous Forum which I saved, but I can't find a link to it.

Trinity has solid expertise in adding code to an app which will make bar codes. Contact me if you need their contact info but they are at trinityis.com

If you want a free solution here are my notes

TIs there a way to automtically generate a code 128 barcode for a text field
How do I have a serial # barcode print on a form or report.
I create Work Orders in quickbase and then print them as an exact form. What I would like is to have The work order # appear as a barcode so that when the service tech returns with the work order we can scan the barcode and bring up the work order for completion by scanning the barcode on the form. (Printed Work Order)
I have searched the forum and have found nothing even close. Can someone please help.
Thank you
Wayne

• barcode help

Me too
Follow
Add or request more details
10 answers
• Sort: Votes
• dandiebolt_QB_Pirate
QuickBase Pro
• 4 years ago
You can write a formula to such a bar code image generating service:
http://www.morovia.com/free-online-ba...
"http://www.morovia.com/free-online-ba..." &
"?Symbology=5" &
"&BarHeight=1000" &
"&ShowHRText=1" &
"&NarrowBarWidth=20" &
"&Message=" & [InvoiceNumber] &
"&Rotation=0"
Unfortunately Morovia might not like you doing this. Google Charts has a QR barcode generation but no linear barcode. So you can use a PHP library:
http://pear.php.net/package/Image_Bar...
• Was this helpful?
• Yes
1
• No
0
Add comment
• mariah
• 6 months ago
actually,you may have a look at the barcode for reporting services http://www.keepautomation.com/guide/b..., Easily generate and draw high-quality linear &2D barcode images in Reporting Services

• Was this helpful?
• Yes
1
• No
0
Add comment
• dandiebolt_QB_Pirate
QuickBase Pro
• 4 years ago
http://www.morovia.com/free-online-ba...

• Was this helpful?
• Yes
0
• No
0
Add comment
• waynestur
• 4 years ago
Thanks Dan- Is there any way to automatically integrate this into a quickbase field- It kind of defeats the purchase if I have to type the Work Order # in the online program and then paste it back into quickbase.
Hope you can help - by the way the last solution you gave me worked like a charm.

Thanks
Wayne
• Was this helpful?
• Yes
0
• No
0
Add comment
• dmendoza
• 4 years ago
Hi Wayne.
Very easy to do with an exact form. I've done it numerous times.

What you want to do is install a free barcode font or purchase a 128 font. I recommend idautomation.com. The only kick is you would need to install that font on the pc's that print the exact form.
Then in your exact form assign the barcode font to the field you want to be barcoded. Then make sure the field looks something like this. *~Barcodefield~*
The asterisks start/stop the scan.
change "barcodefield" to the name of the numeric field you would like converted.

• Was this helpful?
• Yes
0
• No
0
Add comment
• Mark_Shnier , Your QuickBase Coach, Principal
QuickBase Solution Provider
• 4 years ago
Building on Dan's code which was this below, I created a Formula-URL field called [Bar Code] (note that I deliberated put a space on the h ttp to cause this forum to display the full link)
"h ttp://w ww.morovia.com/free-online-barcode-generator/barcode.asp" &
"?Symbology=5" &
"&BarHeight=1000" &
"&ShowHRText=1" &
"&NarrowBarWidth=20" &
"&Message=" & [Record ID#] &
"&Rotation=0"
Then I created a new Formula Text Field with HTML enabled called [Show Bar Code]
""
and the result on a List All report was to list the Bar Code representation of my [Record ID#]'s on the report on the screen.
I did it in two steps because I was getting tripped up by escaping the quotes.
You could probably do it this way while you explore if there is a more robust solution, as Dan says that maybe Morovia would not appreciate all the hits.
Mark

• Was this helpful?
• Yes
0
• No
0
Add comment
• juliew9855
• 3 years ago
You can write a formula to such a bar code image generating service.
• Was this helpful?
• Yes
0
• No
0
Add comment
• mariah
• 7 months ago
you may have a look at this http://www.keepautomation.com/online_...
• Was this helpful?
• Yes
0
• No
0
Comments (1)

o Nathan
o 7 months ago
o Reply
This is a very easy adaptation, took Marks code and made a simple modification.

Made a Formula url, called Barcode, then added the data from the form "[Barcode #]" (subtract the spaces in http and www)
"h ttp://w ww.keepautomation.com/online_barcode_generator/linear.aspx?DATA="&[Barcode #]&"&TYPE=7"

Then created a image display using a text formula.
""
Top of Form

Bottom of Form
• fdse
• 6 months ago
i google and find this barcode generating in code 128 service here, it contains a free trial version of this barcode sdk. check out to see if it is what you are looking for: http://www.rasteredge.com/how-to/csha...
• Was this helpful?
• Yes
0
• No
0
Add comment
• Nathan
• 6 months ago
I agree with Mariah, here is what I posted earlier using keepautomation.com

This is a very easy adaptation, took Marks code and made a simple modification.

Made a Formula url, called Barcode, then added the data from the form "[Barcode #]" (subtract the spaces in http and www)
"h ttp://w ww.keepautomation.com/online_barcode_generator/linear.aspx?DATA="&[Barcode #]&"&TYPE=7"

Then created a image display using a text formula.
""
• Was this helpful?
• Yes
0
• No
0
Comments (1)

o create
o 15 hours ago
o Reply
while for me, i totally support fdse. bercause i have used reasteredge to create code 128 barocde. and it creates barcode automatically just like you ask.
http://www.rasteredge.com/how-to/asp-...
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
I will post a cleaner example in the morning.
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb
Thanks Mark....I have done something like this in another program and had a link in the site to download the font. I would like to try to move away from that solution so that it is all in the app and automatic. I was going to use a QR code but may have to switch to a 128. Once I get this working, I will need to create a form and link it to the code. I setup a test today and it worked great on a simple form but this may be a little more involved to put the record id of the piece of equipment for the PM record.

By the way this is all for the PM app you helped me with. Looking to expand it some for asset management as well as an easier way to bring up the PM form for that piece of equipment. Will probably be in touch was I get the barcode generating.
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb
We have a successful launch....thanks Mark

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
Fantastic, result. Can you post the final formula that worked?
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb

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.

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
Thx for sharing that clean formula.  Just a final comment is that the solution will operate as long as the keep automation people stay offering that free service. My post was from   If you need rock solid bar coding that will last forever, Trinity can do that for you.  Contact Charles.
Photo of Adam Keever

Adam Keever

  • 996 Points 500 badge 2x thumb
Thanks Joey!

This works with the 2D data matrix as well:

"<img src=\"http://www.keepautomation.com/online_barcode_generator/datamatrix.aspx?DATA="
&[Matrix Data]
& "\"\"/>"

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]
& "\"\"/>"