Skip to main content

Code 128 Barcode Generator?


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

  • Inspiring
  • 3264 replies
  • August 13, 2019

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.


  • Participating Frequently
  • 6 replies
  • August 13, 2019

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

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.

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


  • Author
  • New Participant
  • 1 reply
  • August 14, 2019
Bryant_Gillesp1 wrote:

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

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.

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.


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 wrote:

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?


  • Inspiring
  • 368 replies
  • July 31, 2020

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


Kim_Trager1
Forum|alt.badge.img+10
  • Inspiring
  • 154 replies
  • June 1, 2021
Bryant_Gillesp1 wrote:

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

What kind of data are you storing in the barcode?


@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:

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


Kim_Trager1 wrote:

@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:

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…

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

Maybe just a fluke?


Kim_Trager1
Forum|alt.badge.img+10
  • Inspiring
  • 154 replies
  • June 1, 2021
Bryant_Gillesp1 wrote:

@Kim_Trager1

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

Here’s some screenshots…

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…


@Bryant_Gillespie
Very Cool!
but, when using, say “Link to record” function to generate the Code, Code Reader will open the link and Airtable will prompt you to login, download or register to Airtable.
how, or, what kind of Shared “link to record” function to use for the code reader to just open the link in the view only mode, like when sharing the view.
something like this:

Why?

Scenario: Catering staffing?
Waiter gets a link to Barcode, when clicked on link it will open a barcode, when scanned at the access point, it will open the view only record
Use case: ID & access control?

thx!


Miroslav_Tunjic wrote:

@Bryant_Gillespie
Very Cool!
but, when using, say “Link to record” function to generate the Code, Code Reader will open the link and Airtable will prompt you to login, download or register to Airtable.
how, or, what kind of Shared “link to record” function to use for the code reader to just open the link in the view only mode, like when sharing the view.
something like this:

Why?

Scenario: Catering staffing?
Waiter gets a link to Barcode, when clicked on link it will open a barcode, when scanned at the access point, it will open the view only record
Use case: ID & access control?

thx!


@Miroslav_Tunjic
I think the Barcode field type is more about quickly searching / finding records by the barcode within the mobile app than the use case you mentioned.

From your description, it sounds like you want it to open up a the Expanded Record View of a read-only Shared View. Is that right?

If that’s the case you’d want to do something like below and use the QR Code type…

1.) Create a Shared view for the table and view that has the catering info.

2.) Copy the URL structure from the expanded record within that Shared view.

3.) Use the URL structure in the formula you are using to generate the URL.

The formula should look something like this.

"https://airtable.com/{{your_shared_view_id}}/{{your_table_id}}/{{your_view_id}}/"&RECORD_ID()

From my Barcode Test base it would be this

"https://airtable.com/shrjJeGSYIkO4zt6H/tblWjU1xc9kEtKrRp/viwzSAKy8PTOy8ebt/"&RECORD_ID()

4.) Change the formula within the Barcode URL field to use the new URL.

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

**Note: You could also combine this into a single formula field if you wanted like this.

"http://bwipjs-api.metafloor.com/?bcid=qrcode&text="&"https://airtable.com/{{your_shared_view_id}}/{{your_table_id}}/{{your_view_id}}/"&RECORD_ID()

That’s it.

Now the staff member would be able to scan the QR code from the Page Designer (presumably printed out a piece of paper or ticket) and have it take them directly to the expanded record within that shared view you setup.


ScottWorld
Forum|alt.badge.img+20
  • Brainy
  • 8741 replies
  • June 9, 2021

Integromat has a built-in barcode generator. (Integromat is a low-code/no-code automation platform that has full Airtable support.)

It can generate QR codes, along with Code 39, Code 128, EAN-13, EAN-8, UPC-A, and UPC-E barcodes: if you need an additional barcode, you can email them and they will add it:

Also, MiniExtensions.com has both a QR Code extension and a barcode extension, although their barcode extension only operates in bulk.


Bryant_Gillesp1 wrote:

@Miroslav_Tunjic
I think the Barcode field type is more about quickly searching / finding records by the barcode within the mobile app than the use case you mentioned.

From your description, it sounds like you want it to open up a the Expanded Record View of a read-only Shared View. Is that right?

If that’s the case you’d want to do something like below and use the QR Code type…

1.) Create a Shared view for the table and view that has the catering info.

2.) Copy the URL structure from the expanded record within that Shared view.

3.) Use the URL structure in the formula you are using to generate the URL.

The formula should look something like this.

"https://airtable.com/{{your_shared_view_id}}/{{your_table_id}}/{{your_view_id}}/"&RECORD_ID()

From my Barcode Test base it would be this

"https://airtable.com/shrjJeGSYIkO4zt6H/tblWjU1xc9kEtKrRp/viwzSAKy8PTOy8ebt/"&RECORD_ID()

4.) Change the formula within the Barcode URL field to use the new URL.

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

**Note: You could also combine this into a single formula field if you wanted like this.

"http://bwipjs-api.metafloor.com/?bcid=qrcode&text="&"https://airtable.com/{{your_shared_view_id}}/{{your_table_id}}/{{your_view_id}}/"&RECORD_ID()

That’s it.

Now the staff member would be able to scan the QR code from the Page Designer (presumably printed out a piece of paper or ticket) and have it take them directly to the expanded record within that shared view you setup.


@Bryant_Gillespie

Man!!!
How ca i buy you a beer!!

THANK YOU, THANK YOU!!!

It was just this little push an ideas that was needed …

Ill let you all know know what i came up with :slightly_smiling_face:


Kim_Trager1 wrote:

@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:

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


I have the same problem, it doesn't work. Some time ago when I read the article I did a test and everything worked fine, not anymore.


Reply