PP

User Tools

Site Tools

Trace:
general:form_field_edits

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
general:form_field_edits [2017/01/17 16:23] – created jstanfordgeneral:form_field_edits [2017/12/07 21:29] (current) – jstanford
Line 1: Line 1:
-The following fields will have edits when used on a dynamic form: +The following fields will have edits when used on a dynamic form:\\  \\   
- +BBB If a column has a DATA_TYP of STATE in DR_ORD_OPT_TYP, the entry will appear as a drop-down list with all of the US states, territories, and insular areas spelled out. When one is selected, the standard two-character postal abbreviation is stored in the table.\\  \\   
-  * If a column has a DATA_TYP of STATE in DR_ORD_OPT_TYP, the entry will appear as a drop-down list with all of the US states, territories, and insular areas spelled out. When one is selected, the standard two-character postal abbreviation is stored in the table. +BBB If a column has a DATA_TYP of NUMERIC in DR_ORD_OPT_TYP, the data entered by the user is checked to ensure that there are no invalid characters. It allows either all numbers or spaces. No alpha or special characters are allowed.\\  \\   
-  * If a column has a DATA_TYP of NUMERIC in DR_ORD_OPT_TYP, the data entered by the user is checked to ensure that there are no invalid characters. It allows either all numbers or spaces. No alpha or special characters are allowed. +BBB If a column has a DATA_TYP of DATE in DR_ORD_OPT_TYP, the data is masked to force the format MM/DD/YYYY and checked to verify that it is a valid date. For example, 02/31/1995 is not a valid date, even though it is numeric and in the correct format.\\  \\   
-  * If a column has a DATA_TYP of DATE in DR_ORD_OPT_TYP, the data is masked to force the format MM/DD/YYYY and checked to verify that it is a valid date. For example, 02/31/1995 is not a valid date, even though it is numeric and in the correct format. +BBB For a DATA_TYP of AREACODE, the data is masked to force the format ###.\\  \\   
-  * For a DATA_TYP of AREACODE, the data is masked to force the format 999. +BBB For a DATA_TYP of PHONENUM, the data is masked to force the format ###-####.\\  \\   
-  * For a DATA_TYP of PHONENUM, the data is masked to force the format 999-9999. +BBB For a DATA_TYP of ZIP5, the data is masked to force the format #####.\\  \\   
-  * For a DATA_TYP of ZIP5, the data is masked to force the format 99999. +BBB For a DATA_TYP of ZIP4, the data is masked to force the format ####.\\  \\   
-  * For a DATA_TYP of ZIP4, the data is masked to force the format 9999. +BBB For a DATA_TYP of SSN, the data is masked to force the format ###-##-####.\\  \\   
-  * For a DATA_TYP of SSN, the data is masked to force the format 999-99-9999. +BBB In any cases where there are special characters in the display mask on the page, the characters are removed before saving to the SR_ORD table. Also, the date is reformatted to the format YYYYMMDD before saving.\\  \\   
-  * In any cases where there are special characters in the display mask on the page, the characters are removed before saving to the SR_ORD table. Also, the date is reformatted to the format YYYYMMDD before saving. +BBB For a DATA_TYP of EMAIL, the data is checked to ensure that it fits a standard email format. It must have at least one character before an "@" symbol, at least one character between the "@" and the final period, and at least two characters after the final period. For example, the smallest email address that would be considered valid is a@b.cd. There can be multiple periods in the address (e.g., first.last@email.net).\\  \\   
-  * For a DATA_TYP of EMAIL, the data is checked to ensure that it fits a standard email format. It must have at least one character before an "@" symbol, at least one character between the "@" and the final period, and at least two characters after the final period. For example, the smallest email address that would be considered valid is a@b.cd. There can be multiple periods in the address (e.g., first.last@email.net). +BBB If a column has an HTML_TYP of DROPDOWN and includes the name of a lookup table, lookup ID, and value fields, the drop down is populated from that table.\\  \\   
-  * If a column has an HTML_TYP of DROPDOWN and includes the name of a lookup table, lookup ID, and value fields, the drop down is populated from that table. +BBB If a column has an HTML_TYP of RADIO_YN, it displays as {{:images:radio_button.gif|}}Y {{:images:radio_button.gif|}}N.\\  \\   
-  * If a column has an HTML_TYP of RADIO_YN, it displays as {{:images:radio_button.gif|}}Y {{:images:radio_button.gif|}}N. +BBB If a column has an HTML_TYP of TEXT, and a FLD_LEN is given, the text entered into the field is limited to the number of characters specified in FLD_LEN.\\  \\  
-  * If a column has an HTML_TYP of TEXT, and a FLD_LEN is given, the text entered into the field is limited to the number of characters specified in FLD_LEN.+
general/form_field_edits.1484670217.txt.gz · Last modified: 2017/01/17 11:23 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.