Launched: Barcode Pack

That’s amazing! Thank you for adding these.
The Coda team is on point as always. :slight_smile:

Great new pack! Is there an option to display a barcode number underneath the barcode image?

Setup your Barcode Number column, then setup your Barcode Image column, then you can use the Concatenate() formula to display both together in a third column. There’s a trick for adding a line break, which is Character(10).

Concatenate([Barcode Image],Character(10),[Barcode Number])
3 Likes

Thanks that’s very useful! The line break tip too. :slight_smile:

If you ever plan to do another pass on the barcode functionality, consider the below:

  1. Adding the numbers in the standardised way, see screenshot below for EAN13 example.
  2. Generating an SVG. You would need that to include the numbers.

These two things would really complete the barcode quest, slay the boss, save the kingdom. Everything. :slight_smile:

image

1 Like

That would require us using a different library than our current pack and would take some extra legwork from the engineers. We’ll keep this in mind for improvements in the future, but might not be too soon.

Are you using this to actually print up stickers or using this for display on screen only? With it being a new pack, I’m curious what everyones use-case is.

1 Like

I understand it would be complicated. Thank you for considering it!

We are using the SVGs for print, for package design of our products. So just bring the SVG in Photoshop or Illustrator.

We also often have to pass barcode sticker art to our factories. We usually pass them a PDF with one barcode sticker per page. Each page is exactly the size of the sticker.

If there was a good way to generate PDFs or print stickers directly from Coda, we would definitely use it. We are currently jumping through hoops sometimes to generate what files we need: include product name, SKU, barcode, variant info, other stuff.

1 Like

As a use-case, for printing, I must say that intend to build a doc dedicated to my collection of plants :herb: :grin: .(Inventory would be the right term)

I was really happy to see the new barcode pack because it will simplify greatly the attribution of a QR code to each of my plants (which is an idea I got before this pack was introduced).

By printing it and putting it on the pot, it will give me access to the summerized info of the plant if needed, without getting back to the all DB, which can save me a lot of time (I really have a lot of plants and I almost can’t keep track of them anymore).

If Coda can also be used as a Barcode Reader, it could also simplify the tracking of “events”, for example, watering them… Give them water > scan the QR Code > Marked as “watered” in the appropriated table… (this is an extrapolation, as I’m currently not (yet) working on my Plants DB and Coda can’t be used as reader for now (I think) :yum:)

I’ve tried a lot of Apps that already does that, but they don’t suit me or the way I take care of my plants, that’s why when I discovered Coda, I thought it would be the perfect tool to actually build this DB because of its dynamism and the way it works on mobile (like an “App”).

This is a personal project, but still a use-case :wink:

1 Like

[almost working solution] :slight_smile:
Each row in the table has a unique url, you can encod that url to the QR code.
Theoretically, you could use a QR reader to scan the QR on the pot and automatically open the row in coda.
Unfortunately, at the moment, coda only takes you to the right table but don’t opens the specific row (Maybe one of the experts here can find a workaround for that @Filmos @Paul_Danyliuk)

1 Like

I didn’t thought about that :grin: ! Thanks for the tip :grin: !
If it takes me to the right table, I can put buttons to a good use (on mobile) and it will already help a lot ! :grin:

I’ll keep that in mind building the DB :herb: :grin:
Thank you very much :grin:

Give this formula a try for a column button that is a hyperlink. It should open the actual row:

Concatenate(thisRow.Url(),"&modal=true")

The &modal=true appended at the end is what prompts the popup display.

3 Likes

Just sow it here: Pop open a row with a button
It is working with the QR code!

2 Likes

@BenLee and @Asaf_Dafna : Thank you very much :grin: ! I gonna try that :grin: ! (sooner than I thought :yum: )

Anyone with any experience with how someone might incorporate a barcode or qr ‘gun’ into a workflow with this?

(Off the top of my head…) Unique QR codes as physical/visual affiliate links for referral marketing campaigns. — The sponsor prints/etches the affiliate’s unique QR code onto the product their being sent, and when people stop them on the street to ask what it is, the affiliate can refer them through with the code!

Would love to have the ability to scan the barcodes with the phone camera.

2 Likes

We used this feature to print some barcodes for physical usage and scan with mobiles. It work (kind of) OK with the Coda app, but with the published docs this is very much messed up.

EDIT: Removing the Coda app on from the mobile solved it and now a row in a published doc can be referred to properly in a browser.

Hey Stefan canyou elaborate a bit on how you’re using it? I have a warehouse ERP doc and haven’t seen a natural way to incorpoarte the printing or scanning of barcodes.

Hi Johg,

Would it be too much to ask you to a share a version of the doc so I can see what your setup is?

Yeah I’m just wondering how its being used? Like you are you scanning with a phone? If so - using the camera? A QR reader? The coda app itself? And then what … it loads a page in coda? What do you do then … use it to update an inventory value? Wondering what the workflow is. Make sense?

1 Like

Yes, it does. Just wanted to check on your setup because there are few ways to go with it and some are better than the others depending on the relationship between tables.

Basically, what I did is:

  • Generate barcodes in a column for every item
  • Then in a separate column cobine barcode + text description / name of the item
  • Use a filter on the canvas to select an item from the list
  • Screenshot (best quality as of now) the item with barcode
  • Print
  • Then scan with any barcode scanner app and it opens the hyperlink to the item
  • Sign in and edit anything I want about this item.
1 Like