AppSheet QR & Barcode Generator
Generate a QR code or barcode for your AppSheet app.
Pick a type, fill in your column name, then copy the ready-made formula below and paste it into your AppSheet column.
Your formula
Copy this and paste it into an Image-type virtual column in AppSheet.
This formula already uses Column Name from above. Just make sure it matches the exact column name in your AppSheet table.
| Param | Controls | Accepted values |
|---|---|---|
| data | The column whose value becomes the QR code | your AppSheet column name |
| size | Image dimensions | e.g. 300x300 (max 1000x1000) |
| color | Foreground module color | hex without #, e.g. 000000 |
| bgcolor | Background color | hex without #, e.g. ffffff |
Common issues
Quick fixes for the problems people run into most. Still stuck? Use the Troubleshoot button at the top.
The formula shows as text or a link instead of a code
Set the virtual column's Type to Image. The formula builds an image address, and only an Image column displays it as a picture.
The QR code or barcode shows as a broken image
The image is created by a free online service, so the device needs an internet connection. Also check that the column name matches your table exactly and that the record has a value; an empty value has nothing to encode.
The barcode won't scan
Code 128 encodes standard keyboard characters. Letters with accents or non-Latin text can't be encoded, so use a QR code for those values instead.
Can I make the QR code bigger or change its colors?
Yes. Use the Size slider and the Foreground and Background colors, then copy the formula again. Keep a strong contrast between the two colors so phones can scan it.
I renamed my column and the code stopped working
The column name is written into the formula. Enter the new name in the generator and copy the formula again.
I've built 100+ AppSheet apps for inventory, POS, inspections, approvals and reporting, for clients in the USA, Europe and Asia.