SEQNUMN

Syntax

SEQNUMN (name, initial_value_number)

Description

Returns the next sequential number in the named counter. The first number returned is the value of the initial_value_number parameter. After that, the count is incremented by one and returned.

Use named counters when more than one counter is needed for data in the same Map.

Arguments

name Named counter to index
initial_value_number Optional starting value for the sequence

Returns

Returns 1 the first time the function is called if the initial_value_number is not specified.

Remarks

The initial values are reset every time the Map is run.

Examples

SEQNUMN("MyCounter")

Returns: 1 the first time the function is called with the "MyCounter" sequence name, and 2 the next time it is called with it.

SEQNUMN("MyCounter", 123 )

Returns: 123 the first time the function is called with the "MyCounter" sequence name, and 124 the next time it is called with it.

Related Topics

Miscellaneous Functions

SEQNUM