Skip to main content

How to Embed a Bar Code when you auto generate PDFs from Google form responses

Google Form To PDFs add-on allows you to generate professional looking documents (Invoices , Certificates , Business Documents etc). You can also generate and embed a Bar Code.Please read below to learn more.

Embed Native Bar Code​

Follow the below instructions for generating Bar code .

Basic Format to be used inside Template Document =Barcode(data)

note

Use the formula in a completely separate Paragraph without any text.

Examples: =Barcode(abc124n56) , =Barcode({{Form Field}})

The above formula by default uses code 128 Format and should satisfy most of the requirements if you do not have a special barcode format requirement .

Full List of Parameters to customize

=Barcode(<data>, type=code128 ,barWidth=1, barHeight=50,showHRI=true ,bgColor=#FFFFFF,color=#000000,fontSize=10)

  • Use barWidth and barHeight to customize the width and height of bars .Default value for barWidth is 1 and barHeight is 50

  • You can specify the type of barcode you want to generate using the type param .The default value is code128.As of now values supported for type are one of code128, ean13,ean8,code39,upc

Embed Bar Code using Embed Image​

You can also generate and embed Bar code using the Embed Image syntax while creating documents from form submissions

Examples:

{{ Embed Image, https://barcodeapi.org/api/auto/{{Response Number}}, 120, 120 }}

The websites referred for QR code and Bar code API are random and in no way we promote or recommend them . You can use any other public facing apis to generate and embed QRCode or Bar code.