Updated November 18, 2026 · By TypeFlow

Add a Record With Each Scan: Linked Records, Quantities and Cart

With A record is added to another table, each scan adds a record linked to the scanned one: a quantity counted at the station, fields picked before scanning, a question asked at the scan. A cart records several codes at once.

This page is part of Scan to Update. The example is a stock movement: each scan of an item's label adds a line in a Movements table. The scan can also change the scanned item, see Update the scanned record.


What you get

Two buttons at the station:

ButtonPicked before scanningCountedMovement added
Check OutCustomer, LocationQuantity out: 3Type = Out, Quantity = -3, Date = scan time
Check InLocation(nothing)Type asked at the scan (Out, In, Serviced), Date = scan time

In Airtable

Two tables, linked:

Equipment (or Products): the items that carry a label.

FieldTypeRole
Unit NumberSingle line textprinted as the barcode
StockRollup: SUM(Quantity) of Movementsthe stock, always up to date

Movements: one record per scan.

FieldTypeRole
EquipmentLink to Equipmentthe scanned item (filled by TypeFlow)
QuantityNumbercounted at the station
TypeSingle select: Out, In, Servicedset or asked by the button
DateDate with timethe scan time
Customer, LocationLinks to other tablespicked at the station before scanning
TypeFlow scan idSingle line textadded by TypeFlow, so a retry never adds a movement twice

On the label

In the Template Builder, add {{barcode:Unit Number}} to the label. Any barcode built from a field can be scanned: Code 128, QR Code or EAN-13. You can keep the codes you already use, such as a SKU or a supplier barcode: TypeFlow finds the item by the field's value. It also works on labels printed several times from a quantity, because every copy carries the same Unit Number.

Mapping tab: the Unit Number barcode set to Code 128, with the label preview

Set up the scan

In the Actions tab, open When a code is scanned. The station is drawn on the right and changes as you set it up.

1. What a scan does

  • Tick A record is added to another table, then choose Add it to: Movements.
  • Also tick Its record changes if the scan should change the item itself, for example its Status. Otherwise leave it unticked.
Step 1: A record is added to another table ticked, Movements chosen

2. Buttons

Check Out. Type the name, then under On the new Movements:

  1. Quantity in: Quantity. Turn on Removes from stock: the station counts 3, the movement gets -3.
  2. Set Type to Out.
  3. Set Date to the scan time.
  4. Chosen at the station before scanning: click Customer and Location.

If the panel says a text field is needed, click Add "TypeFlow scan id". It is added to Movements once, for every button.

Check Out button: Quantity in, Removes from stock, Type set to Out, Date set to the scan time, Customer and Location chosen at the station

Check In. Click + Add a button, name it, then:

  1. Quantity in: leave no quantity (1 per scan).
  2. Set Type to: click ask at the scan. The station asks Out, In or Serviced after each scan. Turn off Required to allow Skip.
  3. Set Date to the scan time.
  4. Chosen at the station before scanning: Location.
Check In button with Type asked at the scan

Then:

  • Can be scanned again: keep it on, so each scan adds a movement.
  • Shown after a scan: Unit Number, Equipment Type, Status.

3. Station

Copy the Link and the PIN, then click Turn on scanning. Generate the labels after that: only labels generated while scanning is on are recognised.


At the station

  1. Open the station link and type the PIN and a name, for example "Dock".
  2. Pick the button (Check Out), then the Customer and Location. They stay chosen for every scan until you change them.
  3. Type the quantity in Quantity out, then scan the label.
  4. On Check In, the station asks the Type after the scan: tap the answer, or press 1, 2 or 3 on the computer.

On a computer with a handheld scanner, Last scans on the right lists the 10 latest scans of this station.

Station on a computer: Check Out with Customer, Location and Quantity out, Last scans on the rightThe station asks the Type after a Check In scan: Out, In or Serviced, press 1, 2 or 3

Scan a whole delivery

Buttons that add a record show a Cart switch at the station.

  1. Turn on Cart.
  2. Scan every label. Each one is a line, with its quantity editable. An unknown code is flagged on its line before anything is recorded.
  3. Press Validate N lines. A question asked at the scan is asked once, for the whole cart.
Cart with 4 scanned labels, editable quantities and the Validate 4 lines button

Every movement is in History > Scans. Undo deletes a movement added by mistake, a single line or a whole cart.

Was this page helpful?