Libre Barcode 39 in Google Doc Template

[Fabian_Weller]

Does anybody use the font Libre Barcode 39 in a Google Doc Workflow Template to create PDF?

Here you learn how to identify a Barcode.
Code 39 for 1234 looks like this:

When I write 1234 in a Google Doc and change the font into Libre Barcode 39 Text it looks like this:

It’s not scanable, because it is missing the red parts in the beginning and at the end of the code.

Here I learned to wrap it into asterisks like:
*1234*

When I do this it looks like this:

Now it’s scanable. But it has an unnecessary block at the end.

You have to cover it to scan the Barcode.

So I wrote *1234*__ to get this:

My question is: How can I get rid of the last part that is not necessary?

[Fabian_Weller]

Adding @Phil because you once told me about a customer who is using this font.

[Fabian_Weller]

Tagging @Aleksi @Peter @Phil - do you have any insights on that?

[Koichi_Tsuji]

Did you try and test other bar code generator service?

[Fabian_Weller]

Yes I’ve tried also this one but I prefer using the font Libre Barcode 39 in a Google Doc, so that I don’t have to use another service.

[Koichi_Tsuji]

hmmmmm. Exactly not sure how your problem comes, but what is going to happen if you wrap your expression to generate URL by ENCODEURL() expression? Basically the image (bar code/qr code) on the appsheet is generated out of URL we app creators defines, so old type of solution of “encode” may bring different result…

[Fabian_Weller]

docs.google.com

Barcode Test

Code 39 needs a Start and a Stop Fragment (red parts). Without these, the code is not scannable. https://www.barcodefaq.com/1d/code-39/ Text Barcode Result 1234 1234 Not scannable, because of missing Start and Stop Fragment. Additional 2 Space...

I tried to explain the problem in this document. Feel free to play around

[Koichi_Tsuji]

https://www.papersurvey.io/blog/how-to-use-mailmerge-with-paper-surveys

This article is talking about MS Word, but you may need to consider something over Google doc as well?

[Roberto_Fernand]

Question , because the qr code is generated in a virtual column is doesn’t get stored in the data source right?

Is there a way to make it appear in the data source as I am going to create a pdf from template from the data source and I need the qr code to be present.

Any Ideas on how to go about it?

[Fabian_Weller]

Generating Barcodes Tips & Tricks 💡

Try using this site to automatically create barcodes as virtual columns in your apps, in workflow emails, or in generated documents. One way to implement: Create a virtual column, set it as an image type Make the formula equal to below Make the barcode unique to your item ID by replacing the content with your other column values (like product ID, or website) =“https://barcode.tec-it.com/barcode.ashx?data=”&[website] =https://barcode.tec-it.com/barcode.ashx?data=community.appsheet.com An …