Input Masks
From Lianjapedia
Revision as of 07:05, 3 February 2015 by Yvonne.milne (Talk | contribs)
Under Construction
Input mask type
Available in Form Section and Canvas Section fields and Grid Section columns.
Using the named Input mask types requires a bound data source: a field from a table, or a memory variable (m.memvar) with a default expression to specify the width of the corresponding picture.
Select from the listed options. This will populate the mask as follows:
Type | Mask |
---|---|
Custom | Not populated. |
Currency | @C2 |
Date | @D |
Email Address | @E |
Number | @F |
Text | @X |
Time | @T |
Alphabetic | @A |
Upper Case | @! |
Upper Case Alphabetic | @^ |
Custom input masks
Mask | Description |
---|---|
@C, @C2, @C4 | Currency: currency symbol followed by digits 0-9, comma for thousands and one decimal point. @C and @C2 indicate 2 decimal places; @C4 4 decimal places. |
@D | Date: ISO date YYYY-MM-DD. |
@E | Email: restricts input that would lead to an invalid email address such as multiple @, leading space, restricted symbols. |
@F | Number: accepts +/- prefix followed by digits 0-9 and one decimal point. |
@X | Text: accepts alphanumeric characters a-z, A-Z, digits 0-9 and printable symbols. |
@T | Time: hh:mm:ss. |
@A | Alphabetic: accepts alphabetic characters a-z, A-Z only. |
@! | Upper Case: accepts alphanumeric characters a-z, A-Z, digits 0-9 and printable symbols. Lower case alphabetic characters are converted to upper case. |
@^ | Upper Case Alphabetic: accepts alphabetic characters a-z, A-Z only. Lower case alphabetic characters are converted to upper case. |
@I#,#,# | Integer: integer value with maxlength,minvalue,maxvalue: e.g. @I10,100,1000. |
@F#,#,# | Double: double value with maxlength,maxdecimals,minvalue,maxvalue: e.g. @F10,2,0,10000. |
?<regular expression> | Regular expression: prefix with '?' to indicate a regular expression. e.g. ?\\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\\.[A-Z]{2,4}\\b (email address). Detailed information on regular expressions can be found here. |
!A9X | VFP-style picture characters: each picture character corresponds to a character in the value, e.g. AAA, !A99. ! upper case A alphabetic 9 numeric X alphanumeric. |
Notes on Client Support
Mask | Notes |
---|---|
@C, @C2, @C4 | Currently supported on the Desktop client only. |
@D | Currently supported on the Desktop client only. |
@E | Currently supported on the Desktop client only. |
@F | - |
@X | Currently supported on the Desktop client only. |
@T | Currently supported on the Desktop client only. |
@A | Currently supported on the Desktop client only. |
@! | - |
@^ | - |
@I#,#,# | Currently supported on the Desktop client only. |
@F#,#,# | Currently supported on the Desktop client only. |
?<regular expression> | Currently supported on the Desktop client only. |
!A9X | - |