Published November 16, 2026 · Updated November 18, 2026 · By TypeFlow

Scan to Update: Update an Airtable Record by Scanning a QR Code

Scan to Update makes the barcode on a TypeFlow document do something in Airtable. When someone scans it at a TypeFlow station, TypeFlow changes the record the document came from (Status = Checked in), adds a record to another table (a stock movement), or both.


Overview

You already print documents with a code on them: event tickets, delivery notes, box labels, work orders. Until now, marking the record when the code was scanned meant searching for it in an Interface or using another tool.

With Scan to Update:

  1. TypeFlow generates the document with a code: a QR code tied to its Airtable record, or a barcode you already use (a SKU, a ticket number, a unit number) built from a field. You do not need a TypeFlow-specific code.
  2. Someone scans the code at a station: a web page on a computer with a handheld barcode scanner, a phone or a tablet.
  3. TypeFlow writes to Airtable, and the station shows the result full screen, with a sound.

A scan does one or both of these:

A scan...ExampleGuide
changes its recordAttended ticked, Checked In At = scan timeUpdate the scanned record
adds a record to another tablea stock movement: Quantity -3, Customer, LocationAdd a record with each scan
Actions tab of a ticketing flow: the document is saved to Airtable, then the record is updated when its QR code is scanned

Before You Start

  • Plan: Pro and above, and during the free trial.
  • Template: Template Builder (HTML) templates, with Airtable as the data source.
  • Airtable: the fields the scan writes to. To add records, a second table with a link field to the scanned one (for example Movements linked to Equipment).

How to Set Up

Step 1: Put a barcode on the template

In the Template Builder, add a barcode variable where the code should print. Two kinds can be scanned:

BarcodeHowUse it for
Scan linkIn Mapping, set the barcode's type to Scan link. TypeFlow makes a QR code tied to the record.Tickets, work orders: one document, one code. A code from an older version of the document is refused.
From a fieldAny Code 128, QR Code or EAN-13 built from a field, for example {{barcode:Unit Number}}.Labels, including labels printed several times.
Event ticket template with a barcode variable on the stubBarcode variable set to Scan link in the Mapping tab

Step 2: Set up the scan, in 3 steps

In the Actions tab, open When a code is scanned. The setup takes the whole window. On the right, What the station will look like draws the station from your settings as you go.

1. What a scan does. Tick one or both:

  • Its record changes: the scan sets fields on the record behind the code.
  • A record is added to another table: each scan adds one record, linked to the scanned one. Then choose the table in Add it to.

2. Buttons. The person scanning picks one button, for example Check Out or Check In. For each button:

BlockWhat you set
On the scanned [table]Set [field] to a value, the scan time, the station name, or ask at the scan
On the new [table]Quantity in (and Removes from stock), Set [field] to ..., and the links Chosen at the station before scanning (a customer, a location: up to 3)
Can be scanned againOff: a second scan of the same code says "Already". On: every scan counts.

ask at the scan puts a question on the station screen after each scan, for example the condition on return (up to 3 per button). Turn off Required to allow Skip.

Below the buttons:

  • Shown after a scan: the fields the person scanning sees, for example Ticket ID, Holder Name and Tier.
  • A code on no document (when a scan adds records): create the record, or refuse the code.

3. Station. Copy the Link and the 6-digit PIN, then click Turn on scanning. The panel shows Scanning is on, and every production document generated from now on carries a working code, whether you generate it from an Airtable button or an Airtable automation. Turn off stops all stations.

Under Advanced:

OptionChoices
A code from an older version of the documentRefuse it (recommended), Accept it, with a warning, or Accept it
Someone scans the code with their own phoneShow only whether it is valid (recommended), Show the station fields, or Show nothing
The 3-step setup: what a scan does, buttons, station, with the station preview on the right

Every choice is saved as you make it.


Guides

Each guide gives the settings in detail, with a worked example, the Airtable fields and what happens at the station:


Scanning at the Station

  1. Open the station link on the device.
  2. Type the PIN and a name for who or where is scanning (for example "Door A").
  3. Pick the button, and what is chosen before scanning (a customer, a location) if the button has any.
  4. Scan codes with:
    • a handheld barcode scanner (USB or Bluetooth scanner gun) on a computer: nothing to install, the station reads it like a keyboard, even on a French AZERTY keyboard. Last scans on the right lists the station's 10 latest scans, and a question asked at the scan is answered with 1, 2 or 3;
    • the camera of a phone or tablet: it opens on its own, and a question slides up from the bottom;
    • or type the code by hand.

On a button that adds a record, Cart lets you scan a whole delivery, check the lines, then Validate them at once.

With white label (Enterprise), your logo and company name from the e-signature branding show at the top of the station instead of TypeFlow's.

Each scan shows a full-screen result:

ColorMeaning
GreenApplied: Airtable is being updated
AmberAlready scanned, with when and where
RedReplaced by a newer document, cancelled, or not a code for this flow

Codes from test generations show a TEST banner and never write to Airtable.

Security: 5 wrong PINs lock the device for 15 minutes. Generating a new PIN closes every open station.


Scan Log, Undo and Retry

Every scan is listed in History > Scans, newest first, with the record, the flow, the button, the station, the time and its status: Written, Writing, Failed, Test, Already scanned, Refused or Undone.

  • Undo frees the code. If Airtable was already updated, TypeFlow restores the previous values on the fields that still hold what the scan wrote.
  • Retry Airtable sync sends a failed write again, for example after you reconnect a base. It never applies the scan twice.

Limits

  • Scan link: one record, one code. A record that prints several copies of the same label (Repeat X Times) cannot get a Scan link. Use a barcode built from a field instead.
  • Generate after Turn on. Documents generated before scanning was on are not recognised: regenerate them.
  • Airtable is updated within seconds, not instantly: the station confirms the scan first, then TypeFlow writes to Airtable in the background.
  • Scanning a code with a phone's own camera opens a read-only page. It never updates the record: only a station does.


FAQ

Was this page helpful?