Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Code 128 Barcode Generator?

4597 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
Miroslav_Tunjic
6 - Interface Innovator
6 - Interface Innovator

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

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.

ScreenShot 2021-06-07 at 08.47.49@2x

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

ScreenShot 2021-06-07 at 08.48.19@2x

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()

ScreenShot 2021-06-07 at 09.05.12@2x

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

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

ScreenShot 2021-06-07 at 09.14.05@2x

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

ScreenShot 2021-06-07 at 09.20.59@2x

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.

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

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.