Creating Sequences

The use of SQL Sequencers is supported in Eforms. A sequence is a field that is assigned a sequential value each time the Eform is run. Setup is a two-part process.

The first part involves setting up the sequence inside SQL Server.
Open SQL Server Management Studio and look at the ECMT.Eforms database.
Under Programmability, right-click Sequences and choose New Sequence.

Enter a Sequence Name and a Sequence schema which is usually dbo.
Enter a data type. This is usually an integer but can be any numerical datatype.
Enter a Start value and a number to increment each sequence.
Click OK.

Once the Sequence is created in SQL Server, you can now create and configure the question in Eforms.

On your Eform Toolbar, choose Custom → Sequence Lookup.

Assign a Name/Title to the question.
Make the question Read-Only so no one can change the question value.
Enter the Lookup URL which is usually http(s)://website name/database name/sequence/
The Prefix property is optional and can be anything that you want to appear prior to the sequence number. In the example below, the eform is for Purchase Orders, so the prefix is PO-.
The Number Padding property determines how many places the number will show. Any number created less than the padding will have leading zeros.

The last step is to enter the question name as the Value Name entry of the Data Property section.