Can you generate a barcode from a key field calculation | Discussions

Expand all | Collapse all

Can you generate a barcode from a key field calculation

QuickBaseCoach Dev./Training04-20-2017 02:45

QuickBaseCoach Dev./Training04-20-2017 11:36

QuickBaseCoach Dev./Training01-28-2019 22:41

  • 1.  Can you generate a barcode from a key field calculation

    Bronze
    Contributor
    Posted 04-20-2017 01:25
    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!


  • 2.  RE: Can you generate a barcode from a key field calculation

    Posted 04-20-2017 02:38
    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-...


  • 3.  RE: Can you generate a barcode from a key field calculation

    Posted 04-20-2017 02:45
    I will post a cleaner example in the morning.


  • 4.  RE: Can you generate a barcode from a key field calculation

    Bronze
    Contributor
    Posted 04-20-2017 02:56
    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.


  • 5.  RE: Can you generate a barcode from a key field calculation

    Bronze
    Contributor
    Posted 04-20-2017 03:30
    We have a successful launch....thanks Mark



  • 6.  RE: Can you generate a barcode from a key field calculation

    Posted 04-20-2017 11:36
    Fantastic, result. Can you post the final formula that worked?


  • 7.  RE: Can you generate a barcode from a key field calculation

    Bronze
    Contributor
    Posted 04-20-2017 11:44

    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.



  • 8.  RE: Can you generate a barcode from a key field calculation

    Posted 04-20-2017 12:46
    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.


  • 9.  RE: Can you generate a barcode from a key field calculation

    Bronze
    Contributor
    Posted 01-05-2018 21:33
    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]
    & "\"\"/>


  • 10.  RE: Can you generate a barcode from a key field calculation

    Posted 01-28-2019 19:45
    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.


  • 11.  RE: Can you generate a barcode from a key field calculation

    Posted 01-28-2019 20:17
    I got it!!!

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


  • 12.  RE: Can you generate a barcode from a key field calculation

    Posted 01-28-2019 22:41
    Good for you! Well done.


  • 13.  RE: Can you generate a barcode from a key field calculation

    Posted 02-25-2019 20:00
    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,


  • 14.  RE: Can you generate a barcode from a key field calculation

    Posted 02-25-2019 20:43
    Please post the code for your formula as opposed to a screen shot.  Also the bar code would need to be a formula Rich Text field type, and not a text field type.


  • 15.  RE: Can you generate a barcode from a key field calculation

    Posted 02-26-2019 03:44
    Changing the field type did the trick. Thank you!