If you use Airtable to keep an inventory of items in your warehouse, you can save time by scanning QR codes with your iPhone and quickly updating your Airtable base as you restock your shelves or check items in and out.
In this tutorial, we’ll learn to create QR Codes for every record in an Airtable base. You’ll be able to print QR Codes for each product and attach them to your inventory shelves for easy scanning and updating information on every record. 🙌🏼
While Airtable’s iPhone app allows you to scan barcode numbers through your phone’s camera, it does not automatically generate unique barcodes every time a record is created.
What You’ll Need Beforehand
- 1x Airtable** free account **— Airtable is a combination of a spreadsheet & database.
- 1x Standard Library** free account** — A platform for building and deploying APIs, linking software tools, powering Slack apps, automating tasks, and more.
**Part 1: **We’ll learn how to build and publish a QRcode API service with Autocode
**Part 2: **We’ll use our QRCode API in an Airtable formula to automatically produce barcodes for each record (row) in Airtable.
Part 3: We’ll write a script to transform a bulk of image file URLs into image attachments in Airtable.
Part 1: How to Build a QRCode API with Autocode
Head on over and copy the QRCode template using this link:
https://autocode.stdlib.com/github/JanethL/QRCode/?filename=README.md
You will be prompted to sign in or create a free account. If you have a Standard Library account click Already Registered and sign in using your Standard Library credentials.
Give your project a unique name and select Start API Project from Github:
Navigate through the functions folder on the left and select QRCode.js file.
Standard Library automatically generates HTTP endpoints (URLs) for each file.
This URL consists of
<username>.api.stdlib.com/<projectName>@environment/<endpointName> and it will be available after you deploy your project in the next steps.
For example:
#business #technology #cloud-computing #saas #productivity #cloud
