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 door | In Airtable |
|---|---|
| Green: name, ticket ID and tier on screen | Attended ticked, Checked In At = scan time |
| Amber Already: when and where it was first scanned | Nothing changes |
| Red: a ticket from an older version, or not a ticket for this event | Nothing changes |
In Airtable
One table of tickets (or attendees), one record per ticket, with:
| Field | Type | Role |
|---|---|---|
| Ticket ID | Single line text | printed as the QR code |
| Holder Name, Tier | any | shown at the door after a scan |
| Attended | Checkbox | ticked by the scan |
| Checked In At | Date with time | the time of the scan |
On the ticket
- In the Template Builder, add
{{barcode:Ticket ID}}where the QR code should print. - 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]:
| Set | to |
|---|---|
| Attended | checked |
| Checked In At | the 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
- Open the station link on a phone, a tablet or the computer a scanner is plugged into.
- Type the PIN, then a name for this spot, for example "Door A".
- 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.