Skip to content

Latest commit

 

History

History
56 lines (49 loc) · 1.46 KB

formula.md

File metadata and controls

56 lines (49 loc) · 1.46 KB

Formulas for google sheet 🧪

1️⃣ The formula to generate consecutive code which is combination of letters and numbers

="QR"&ROW(A1)+1000
Output
QR Key
QR1001
QR1002
QR1002

Replace "QR" and the number 1000 with your desired letters and number

eg. ="CODE"&ROW(A1)+154

Output
QR Key
CODE155
CODE156
CODE157

2️⃣ Formula to generate random code for qr code(More secure)

=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99)
Output
QR Key
OJBXE36
LZGGR16
BDXHP18

3️⃣ Formula to generate qr code image url

="https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl="&ENCODEURL(A2)
Output
QR Key QR Key Url
QR1001 https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl=QR1001
QR1002 https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl=QR1002
QR1003 https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl=QR1003

4️⃣ Formula to generate qr code image in google sheets

=image("https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl="&ENCODEURL(A2))

Here "A1" is the column position

Output

image