Collect Formula Building – Masks

<< Click to Display Table of Contents >>

Navigation:  Collect > Collect Enterprise > Template Designer Page > Formula Builder >

Collect Formula Building – Masks

The Masks feature permits string fields to be additionally defined by the type (masking element) and number of characters allowed. The types of masking elements are provided in the table and can be used in combination.

 

The Mask feature is based on the Microsoft mask feature. For more information regarding masking elements please visit the link below:

https://msdn.microsoft.com/en-us/library/system.windows.forms.maskedtextbox.mask(v=vs.110).aspx

 

Masking
Element

Description

0

Digit (0-9) (required).

9

Digit (0-9) or space (optional).

#

Digit or space (optional). If this position is blank in the mask, it will be rendered as a space in the Text property. Plus (+) and minus (-) signs are allowed.

L

Letter (A-Z, a-z) (required).

?

Letter (A-Z, a-z) (optional).

A

Alphanumeric (A-Z, a-z, 0-9) (required).

a

Alphanumeric (A-Z, a-z, 0-9) (optional).

.

Decimal (separator). Commonly used in Currency ($2.50) values.

,

Comma (separator). Commonly used in Digit (thousands, 1,000) separation.

:

Colon (separator). Commonly used in Time (12:00) format.

/

Forward slash (separator). Commonly used as a Date (04/04/18) separator.

$

Currency (symbol).