Design QR code

[Aniday]

Hi I require a QR code which has a unique number embedded in it

AS001B001P001ITM001 which corresponds to Super admin 001, brand 001, product 001 and item 001

This needs to reflect the values of above when scanned. ALso the QR code itself needs to be customisable with logo and text outside of qr code as a label. The label consists of QR code, logo and text.

And I need bulk generation of same. Is the Bulk QR code generator addon in google sheet capable of this and how do i do the same. I am a novice and would appreciate assistance on the same

Thanks

Aniday

[peterson]

Well, to create a QR code I usually use this service below

https://quickchart.io/documentation/qr-codes/

There you'll find a link and parameters you can use as a virtual column in your app, image type

And you can use your ID and other information to create a customizable QR Code, including image in the center. You just have to read the full page to understand how to do it. 

If you have difficulties to do that, search here for SVG images.

[baba_sawane]

Hi Aniday,

I understand you want to create QR Code for data within your app.

For this, you can:

Inside your data table, create a new virtual column with this formula (adapt the column name to your app columns) : 

concatenate("https://quickchart.io/qr?text=","AS",[SuperAdminvalue],"B",[Brandvalue],"ITM",[itemvalue],"&size=200¢erImageUrl=https%3A%2F%2Fdrive.google.com%2Fuc%3Fexport%3Ddownload%26id%3D1sfIlJuo4gLPbME_C_LmXSS26UmgHgFXC )

In bold is the export link of the logo of a company, that I added within my google Drive. 

You may replace this link with your own logo URL. Note that if you use Drive to upload the logo, it need to be shared to "anyone with the link", and the url must be in export format. Use this tool to convert your logo file Drive URL to export format : https://sites.google.com/site/gdocs2direct/

The virtual column type has to be Image. For further customization, please explore https://quickchart.io/qr-code-api/ .

Hope it helps !

edit : just saw there was another answer while I was writing, I'm sorry @peterson 

[peterson]

No problem, we're all here to help .

Regards