Skip to main content

Serial Number

Serial number fields store business codes. They can generate the next code automatically according to a template and sequence rule.

Use a serial number field for values such as order numbers, ticket numbers, customer codes, asset codes, or other identifiers that need a consistent format.

Basic Settings​

SettingDescription
NameThe field label shown to users. It is required and should describe the code clearly
API NameThe stable technical name used by data APIs, scripts, formulas, imports, and integrations. It is required
RequiredRequires the field to have a value before the record can be saved
ReadonlyShows the generated code but prevents users from editing it
DisabledMakes the field unavailable for normal use
HiddenStores the generated code while hiding it from normal form pages

Serial number fields are usually left empty at runtime so Soln can generate the next value automatically.

Serial Number Config​

SettingDescription
TemplateDefines the final code format. Static text and supported tokens can be combined
Reset CycleControls whether the sequence never resets, resets yearly, resets monthly, or resets daily
Generate TimingControls when the number is generated: on create, on active submit, or after approval
Uniqueness StrategyControls whether uniqueness is checked against all values or only automatically generated values
Overflow StrategyControls what happens when the sequence exceeds the configured width: expand automatically or report an error
Number WidthMinimum width of the sequence number. The number is padded with leading zeros when needed
Start NumberThe first number used by the sequence
StepThe increment between generated numbers
PreviewShows an example value based on the current template and sequence settings

Template Tokens​

TokenMeaning
{YYYY}Four-digit year
{YY}Two-digit year
{MM}Two-digit month
{DD}Two-digit day
{SEQ}Sequence number, padded according to number width

Template Examples​

RequirementTemplateExample
Yearly order numberSO-{YYYY}-{SEQ}SO-2026-0001
Monthly ticket numberT-{YY}{MM}-{SEQ}T-2606-0001
Daily work orderWO-{YYYY}{MM}{DD}-{SEQ}WO-20260617-0001
Simple customer codeCUST-{SEQ}CUST-0001

Option Notes​

OptionNotes
Do not resetThe sequence keeps increasing across all dates
Reset by yearThe sequence restarts when the year changes
Reset by monthThe sequence restarts when the month changes
Reset by dayThe sequence restarts every day
Generate on createA number is assigned when the record is created
Generate on active submitA number is assigned when the record is formally submitted or activated
Generate after approvalA number is assigned after approval succeeds
Expand automaticallyIf the sequence grows beyond the configured width, Soln expands the width
Report errorIf the sequence grows beyond the configured width, generation fails and reports an error