Help

Re: Code 128 Barcode Generator?

5042 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex_Jacobson
4 - Data Explorer
4 - Data Explorer

I’m using Airtable to create product labels for my finished products and would like to use the Page Designer to create a barcode that could be scanned by either Airtable or Smartsheet. Anyone know a way to automatically convert my alphanumeric workorder number (B0194) to Code 128 (ÌBÇ!~ÅÎ) so I can use Libre 128 Font in Page Designer?

Thanks!!

Code 128 Barcode Generator?
14 Replies 14

Yes - I’ve actually done this but I needed an API process to do it. The process continually looks for records lacking the bar code image and then uses the data to generate it and upload it into the record.

Bryant_Gillesp1
5 - Automation Enthusiast
5 - Automation Enthusiast

@Alex_Jacobson

Instead of trying to use the Libre 128 Font, I went a different route when this came up on a couple of bases.

I used the following API to create the barcode.

It will return a barcode image that can be used with the Page Designer.

Step 1. Create a Formula field inside the Base.

Here’s an example from my base.
Screenshot 2019-08-13 17.00.40.png

Here’s the formula used in the screenshot

"http://bwipjs-api.metafloor.com/?bcid=code128&text="&{Field}

Just change {Field} to the name of the field you want to use to generate the barcode.

Step 2. Create an image element inside the Page Designer block

Include the {BarcodeURL} tag inside the Image url field of the image element.

46

Screenshot 2019-08-13 17.05.39.png

You should then see the barcode image render inside the Page Designer

Thanks Bryant! I ended up using Code 39 instead, which doesn’t need a translation, just needed to add * before and after: “B0194” = “B0194”. This was much simpler than trying to translate into 128 and since we only have 5 digit codes, the length isn’t an issue.

Neil_Baptista
5 - Automation Enthusiast
5 - Automation Enthusiast

Is there some way to get multiple barcodes on the same page?

I have a project which has multiple project tasks. I would like the project tasks to be printed out using page designer.

@Neil_Baptista - are you able to use the Code 39 instead of 128??

What kind of data are you storing in the barcode?

Moe
10 - Mercury
10 - Mercury

One of our extensions allows you to generate barcode images in bulk on Airtable.

@Bryant_Gillespie Do you know if your above approach still works?

I’ve tried to follow along with your detailed instructions, but somehow I can’t get page designer to generate a barcode.

I got the following setup:
Screenshot 2021-06-01 at 17.50.19

Screenshot 2021-06-01 at 17.50.36

But image seems to be broken despite being able to click the ‘BarcodeURL’ URL

@Kim_Trager1

Just tested this. Seems like it is still working for me.

Here’s some screenshots…
ScreenShot 2021-06-01 at 14.41.13@2x

ScreenShot 2021-06-01 at 14.40.57@2x

Here’s a link to the base from the screenshots.

Maybe just a fluke?

@Bryant_Gillespie Thanks for sharing this, turns out the barcode only show if you use the airtable in the browser and not the app.

Got it to work…