Creating a QR Code from Appsheet is easy. Sometimes, we need a QR Code which is formed from several datas input. Let’s say, we have a form contained with identities like, Name, Address, etc. And, after filling the form, the QR Code will automatically generated from any data you want.
First, we have to create a Google Sheets for our table in Appsheet. In this case, i make Home Sheets with 4 columns (ID, Name, City & QR Code). We can see the QR Code links; it is formed from Kevin + London, so in my form, i want to create a unique QR Code from Name and City column, you can create it from any datas you want (like Address, Phone Number, Age, etc).
Now, open new Appsheet and add table from our Google Sheets -> Home Sheet.
In Home (View Column), set the ID as Key and Label. The Name & City is text type, and the QR Code as Image type. After that, we add Virtual Column to ‘store’ the virtual data. I add IDCODE virtual column, then add the formula with the codes:
CONCATENATE([Name],” “,[City])
This code means, IDCODE has the concatenation data from Name and City column.
In QR Code, add the formula with the codes:
CONCATENATE(“https://chart.googleapis.com/chart?chs=500x500&cht=qr&chl="&substitute([IDCODE];" “;”%20"))
This code means, QRCODE column generates a QR Code from goole api and the data is from our virtual column -> IDCODE with certain size. Don’t forget to go to App (side-left menu) and set the Home Table as a form. Now, i try to fill the form with Brian in Name, and Melbourne in City.
We can look the result, the QR Code is formed from Brian and Melbourne. I checked the QR Code with my phone, and get the same result: Brian Melbourne.
Congratulate your QR Code generator app is done!