Skip to main content
Keyword: Text

#EN #Excel #Keyword

Updated over a year ago

What is the keyword to use?

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

Description

Keyword to Use

Text control

text


Why use this keyword?

With this control, you will be able to:

  • Access to an alphanumerical keyboard

  • Can be used to read a barcode and add its value to the text control

  • Can be used to have a longer number input (15 digits maximum) and add a limit on it:

    • Greater than [...] (or equal)

    • Lesser than [...] (or equal)

    • Between two values

  • Usually is the type of control you use in a column to list items


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

Using three consecutive rows (or as we refer to it, 123) in the Excel spreadsheet, you can create a column.

  • Row 1 will be used for the TITLE

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

  • Row 2 will be used for the KEYWORD

    • The keyword defines what the column will be used for

  • Row 3 will be used for the VALIDATION RULE(S)

Here is an example:

Here is how it displays in the application:


Available validation rules for this keyword

STATE CHANGE

INVALIDITY (LIMITS)

AUTOMATION

FORMULAS

None.

Did this answer your question?