Difference between revisions of "Input Masks"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "''Under Construction'' ==Input mask type== Available in Form Section and Canvas Section fields. Fields must have a known width, i.e. bound to a field from a table or to a me...") |
Yvonne.milne (Talk | contribs) |
||
Line 4: | Line 4: | ||
Available in Form Section and Canvas Section fields. | Available in Form Section and Canvas Section fields. | ||
− | + | ||
+ | Using the named pictures 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: | Select from the listed options. This will populate the mask as follows: | ||
Line 63: | Line 65: | ||
|valign="top"|?<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 | |valign="top"|?<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 | ||
|- | |- | ||
− | |valign="top"|!A9X||VFP-style picture characters: | + | |valign="top"|!A9X||VFP-style picture characters: each picture character corresponds to a character in the value, e.g. AAA, A99. |
|- | |- | ||
|} | |} |
Revision as of 13:16, 2 February 2015
Under Construction
Input mask type
Available in Form Section and Canvas Section fields.
Using the named pictures 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: the digit is the number of decimal places |
@D | Date: ISO date YYYY-MM-DD |
@E | Email: |
@F | Number: |
@X | Text: accept alphanumeric characters |
@T | Time: |
@A | Alphabetic: accept alphabetic characters only |
@! | Upper Case |
@^ | Upper Case Alphabetic |
@I#,#,# | Integer value with maxlength,minvalue,maxvalue: e.g. @I10,100,1000 |
@F#,#,# | 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 |
!A9X | VFP-style picture characters: each picture character corresponds to a character in the value, e.g. AAA, A99. |
@9,3
That will restrict to 3 digits.
@9,3,5,200
That will restrict to 3 digits in the range 5 to 200