How to gen qr code on Google Sheet

 in case of a teacher or a home business that want to gen qr code for a student id or product id for selling things by scanning ,reanding and saving data


on Google account go to the drive 

and Google sheet 

Enter some of the data as below

Product id     product name    image

1234567891   rice

1234567892   book 

1234567893   pen 

on the image column copy and paste the code below 

=IMAGE(""& A2)

When A2 is a reference cell:colume for the product ID to gen as the Qr code image 

for the next row just copy the code by draging the tiny plus icon 

using this qrcode by print out and paste it on the card or on the pack of the product to sell by scan qrcode application 

Post a Comment

ใหม่กว่า เก่ากว่า