Updated November 18, 2026 · By TypeFlow

Update the Scanned Record: Change Airtable Fields When a Code Is Scanned

With Its record changes, a scan writes to the record behind the code: a fixed value, the time of the scan, or both. A code that can be scanned once shows Already the second time.

This page is part of Scan to Update. The example is an event ticket: at the door, a scan ticks Attended and writes Checked In At. To add a record to another table instead, see Add a record with each scan.


What you get

At the doorIn Airtable
Green: name, ticket ID and tier on screenAttended ticked, Checked In At = scan time
Amber Already: when and where it was first scannedNothing changes
Red: a ticket from an older version, or not a ticket for this eventNothing changes

In Airtable

One table of tickets (or attendees), one record per ticket, with:

FieldTypeRole
Ticket IDSingle line textprinted as the QR code
Holder Name, Tieranyshown at the door after a scan
AttendedCheckboxticked by the scan
Checked In AtDate with timethe time of the scan

On the ticket

  1. In the Template Builder, add {{barcode:Ticket ID}} where the QR code should print.
  2. In Mapping, set that barcode's type to Scan link. Each ticket gets its own code, tied to its record.

Set up the scan

In the Actions tab, open When a code is scanned. The setup takes the whole window, with the station drawn on the right as it will look.

1. What a scan does

Tick Its record changes only. Leave A record is added to another table unticked.

2. Buttons

One button is enough. Under On the scanned [table]:

Setto
Attendedchecked
Checked In Atthe scan time
  • Button name: leave it empty and the button is named after what it sets, or type "Check in".
  • Can be scanned again: leave it off. A second scan of the same ticket says "Already".
  • Shown after a scan: Ticket ID, Holder Name, Tier.

3. Station

  • Copy the Link and the PIN: send them to whoever works the door.
  • Click Turn on scanning. The panel shows Scanning is on.

Then generate the tickets. Only tickets generated while scanning is on carry a working code. A ticket generated in test shows a TEST banner and never writes to Airtable.


At the door

  1. Open the station link on a phone, a tablet or the computer a scanner is plugged into.
  2. Type the PIN, then a name for this spot, for example "Door A".
  3. Scan:
    • phone: the camera opens on its own;
    • computer: use a USB or Bluetooth handheld scanner, no setup needed. The last scans are listed on the right.

Every scan is in History > Scans: the ticket, the door, the time. Undo frees a ticket scanned by mistake.

Was this page helpful?