Making a field value Unique

Setting a form field as "unique" will not accept any duplicate values for the field, while submitting the form. Each value in this field will be unique and will not match another value. For example, an Employee ID field in an Employee form must be unique to identify each employee record. The following field types can be configured to contain unique values:

• Single-line text field, Email field.
• Number, Percent, Decimal, Currency fields
• Date, Date-Time fields

To set a field as unique while adding a field,

1. Drag and drop the required field to the form.
2. Click on Options.
3. Select the checkbox No duplicate entries.
4. Click "Done" to save the setting.

To set an existing field as unique,

1. Select the Form from the Forms Tab in Edit mode.
2. Place mouse over the field to be edited.
3. Select the Edit this Field option. The edit dialog will be displayed with the current field configurations.
4. Select the checkbox No duplicate entries
5. Click Done to update the changes.