Can you generate a barcode from a key field calculation

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-...

I will post a cleaner example in the morning.

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.

We have a successful launch....thanks Mark

Fantastic, result. Can you post the final formula that worked?

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.

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

This is an awesome thread!  I am super excited to implement a QR reader within one of my applications.  This will be used for asset management.  So basically I have all the fields identified within the description above.  However, what I need to know is how to write a formula to say "THIS RECORD".  What I want is when a technician arrives at an asset, they will scan a QR Code and their phone will route to the record for that asset within my QuickBase application.

I got it!!!

URLEncode(URLRoot() & "db/" & Dbid() &
        "?a=dr&rid=" & [Record ID#])

When I try to get the barcode image, using   "<img src=" &[Barcode Link]& ">", for some reason part of the tag is left out, and I get a "bad request" message



thank you,