Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Barcode Creation

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Andrew_Enright
9 - Sun
9 - Sun

Please add the ability for a formula to reference a alphanumeric string in column A and then generate a barcode in column B. When using Airtable as a backend for creative workflow, and you want barcodes in things like slugs and job tickets, this could be HUGE. Iโ€™m sure for small retailers too! Thanx.

11 Comments
Douglas_Forster
Airtable Employee
Airtable Employee

Hi @Andrew_Enright! Thanks for the suggestion โ€“ adding a way to create new barcodes from within Airtable is something weโ€™re considering.

Could you tell me some more about how youโ€™d like to generate a barcode in slugs and job tickets? E.g. generating a QR code that contains a link to an Airtable record?

Best,
Doug

Andrew_Enright
9 - Sun
9 - Sun

QRs are a fine option, linking to any data/URL. But they are large. A scaled and truncated linear barcode is much more useful for folks with cheap, traditional laser scanners and limited space. Best to have both options; they are different use cases. QRs are pretty useless unless mobile; and even then adoption is poor. As for traditional barcodes, my team could make code 39 or 128 work. Not sure of the greater market.

Jon_Jaques
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, Iโ€™ve created what I think is an ingenious solution to this! Let me see if I can describe it succinctlyโ€ฆ My primary field, โ€œAsset Tagโ€, for my Assets table is set to Type: Barcode. I then create a calculated field of Type: Formula, and I set the formula like so:

โ€œhttps://api.qrserver.com/v1/create-qr-code/?size=150x150&data=โ€ & {Asset Tag}

Format that field as a URL. Now, you have a link that if you click on it, it opens a tab, and displays a QR code via http://goqr.me/.

Now I know thatโ€™s not quite as good as what you asked for, but itโ€™s enabled me to get up and going.

Hope this helps!

Andrew_Enright
9 - Sun
9 - Sun

This addresses half the problem, thank you. As others have posted in various forum topics, there are services that allow the CREATION of barcode/QR images using Airtable field data. But we donโ€™t yet have a way to automatically pull those images back into Airtable. You can pull in the link, but not the imageโ€ฆ I support the addition of an Image URL field type: New Data Type: Image URL

Carlos_Gonzalez
5 - Automation Enthusiast
5 - Automation Enthusiast

Questionโ€ฆ

Iโ€™m attempting to implement this workflow for asset management at a post-production company. This workflow works, but itโ€™s a little clunky. Meaning it involves extra clicking and remembering to click the URL, save the image, and then upload the picture to airtable.

It seems to me like it should be easy for this to be solved with a ZAP! Has anyone done the following? Or know how to make this idea work?

You create a new asset. This new record has a row that autogenerates the QR code URL and the asset tag. This new asset is missing an attachment (QR code image at URL), so it is singled out in a view that filters out records missing an attachment. This action triggers the ZAP to visit the URL that the record is linked to. The image at the URL is saved or stored and then uploaded to the attachment record that it corresponds to. At the final step, Airtable might have to search for the matching URLโ€ฆ

Is this possible?Any thoughts on how to automate this workflow with scripting or something?

Andrew_Enright
9 - Sun
9 - Sun

Hi Carlos, I too think this MUST be possible via Zapier and have taken a few stabs at it off-and-on. Havenโ€™t cracked it yet, but will share here as soon as I have a few solid hours to throw at it. Agreed that this is a huge unlock for any workflow that must manage/traffic physical goods/archives.

Jonathan_Busse
4 - Data Explorer
4 - Data Explorer

Hi Carlos,

still searching for a solution? I automated the same workflow for my purposes and could open the solution for general use with some extra effort, if there is a needโ€ฆ

Andrew_Enright
9 - Sun
9 - Sun

All, pretty sure I posted this in a related thread, but weโ€™ve got this working via Zapier:

  1. New Record in View

  2. Find Record. Search Value equals unique ID from Step 1.

  3. Update Record. Custom Value for Record ID equals Record ID from Step 2 (e.g. rec9NIErJkWfCXz). Barcode Image URL equals barcode URL from Step 2 (e.g. http://www.barcodes4.me/arcode/c128b/CH01234.jpg). Barcode Image Attachment ALSO equals barcode URL from Step 2 (e.g. http://www.barcodes4.me/arcode/c128b/CH01234.jpg).

Abdulrahman_Alz
6 - Interface Innovator
6 - Interface Innovator

I made a simple tool that converts barcode numbers to barcode images. It supports all major barcode types, and can be scheduled or triggered by a webhook URL.

M_k
11 - Venus
11 - Venus

Hi @Abdulrahman_Alzanki

This is a great tool!

I wondered if you could also post this in the โ€œShow and Tellโ€ section, since I almost missed it.

Thank you,
Mary K