Skip to main content
Keyword: Auto-Incremented Keys

#EN #Excel #Keyword

Updated over a year ago

What is the keyword to use?

In order to create a key type control, please use one of the following keywords:

Description

Keyword to Use

Auto-incremented key

key


Why use this keyword?

With this control, you will be able to:

  • Add a read-only and unique value on your forms that will auto-increment to never give you the same auto-incrementing number twice.

    • You can add custom text, a date and the auto-incrementing number to the value that will automatically display

  • This features requires an internet connection to work

    • The auto-incrementing number will be generated only when pressing on the field AND there is an internet connection present

      • The system reaches the website to obtain the next number in line

  • The generation of the auto-incrementing number cannot be undone


How to use this keyword?

As a FIELD

Using columns A, B and C in the Excel spreadsheet, you can create a field.

  • Column A will be used for the TITLE

    • The title will be displayed to add a description regarding your input;

  • Column B will be used for the KEYWORD

    • The keyword defines what the field will be used for;

  • Column C will be used for the VALIDATION RULE(S)

Here is an example:

Here is how it displays in the application:


As a COLUMN

This keyword cannot be used in a column.


Available validation rules for this keyword

STATE CHANGE

INVALIDITY (LIMITS)

AUTOMATION

  • Validation rules for keys

FORMULAS

Did this answer your question?