Process: Find gaps in numbering

Find missing and repeated numbers in a numbered series: invoices, credit notes, cheques.

Help Centre › Building Processes

Find missing and repeated numbers in a numbered series: invoices, credit notes, cheques.

Add it to a process

In the process designer, open the Add step tab. Find Find gaps in numbering under Process, or type its name in the search box, and drag it onto the canvas.

Fields

FieldRequiredWhat it does
RowsNoVariable holding the rows, or a plain list of numbers
FieldNoField holding the number, when the rows are records (e.g. invoice number)
VariableNoVariable to store the result in (default: gaps)

What it gives back

  • {gaps} – missing (series, number, value), repeated (series, number, positions) and summary

See all Process steps.

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.