Auto Numbering
The "Auto Numbering" property provides automatic numbering, assigning a distinct identifier to each form record.
In the Unique Id settings, you can use the following properties to set the automatic numbering
Select Question - This refers to the field in the record that will contain the unique identifier. Therefore, you should select the required form field here.
Template - In the template property, you can define a dynamic prefix for the auto-numbering format. This dynamic prefix can comprise of the following
A static text
A field value of the record can be included by using {}. For example, if you want to incorporate the transaction type into the auto-numbering format and the transaction type is stored in the 'transtype' field, you would use {transtype}.
Supported date variables
The following date variables are currently supported
year - e.g. 2024
day - e.g. 12
weekday - e.g. 1 to 7
quarter -
millisecond
weekNumber - e.g. 50
monthShort - e.g. Jan
weekdayShort - e.g. Sun
month - e.g. 12
second - e.g. 23
hour - e.g. 13
minute - e.g. 55
weekYear - e.g. 51
ordinal
monthLong - e.g. January
weekdayLong - e.g. Sunday
To use the date variable, enclose the variable in braces {} preceded by a #. For example, use {#year}.
Example of a dynamic template
T-{transtype}/{#year}/ will evaluate to T-INV/2024/
No of digits - Number of digits refers to the total length or size of the auto-generated number. This setting determines how many digits will be included in the generated number, ensuring consistency in the format. For example, if the number of digits is set to 6, the auto-numbering will display numbers like 000001, 000002, and so on, padding the numbers with leading zeros to maintain the specified length.
Count - Count is used to set the starting number.
Active - When enabled, auto-numbering will be activated. By default, it is turned off.
Currently, auto numbering can be set for only one field of a form.
Last updated
