Difference between revisions of "Mapping Fields from Customised Forms"

From Hornbill
Jump to navigation Jump to search
 
Line 71: Line 71:
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_custom_p - h_custom_t
+
| align = "left"            | h_custom_p - h_custom_t
−
|                            <!-- Data Type/Capacity --> TEXT/unlimited*
+
|                            TEXT/unlimited*
−
|                            <!-- Description        --> ''TEXT'' custom fields p - t each suitable for holding large amounts of text characters of any type.
+
|                            ''TEXT'' custom fields p - t each suitable for holding large amounts of text characters of any type.
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_custom_21 - h_custom_25
+
| align = "left"            | h_custom_21 - h_custom_25
−
|                             <!-- Data Type/Capacity --> DATETIME/a single date-time stamp
+
|                             DATETIME/a single date-time stamp
−
|                            <!-- Description        --> ''DATETIME'' custom fields 21 - 25 each suitable for holding a single date-time stamp (YYYY-MM-dd HH:mm:ss). These columns should ONLY be used in conjunction with a date-time picker.
+
|                            ''DATETIME'' custom fields 21 - 25 each suitable for holding a single date-time stamp (YYYY-MM-dd HH:mm:ss). These columns should ONLY be used in conjunction with a date-time picker.
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_custom_26 - h_custom_30
+
| align = "left"            |h_custom_26 - h_custom_30
−
|                             <!-- Data Type/Capacity --> INTEGER/any whole number  
+
|                             INTEGER/any whole number  
−
|                             <!-- Description        --> ''INTEGER'' custom fields 26 - 30 each suitable for holding whole numbers. When mapping to these columns, ensure the following RegEx is specified in your Custom field settings: ''[0-9]''
+
|                             ''INTEGER'' custom fields 26 - 30 each suitable for holding whole numbers. When mapping to these columns, ensure the following RegEx is specified in your Custom field settings: ''[0-9]''
 
'''Note:''' Phone numbers are ''not'' Integers, do '''not''' use these fields to store phone numbers.
 
'''Note:''' Phone numbers are ''not'' Integers, do '''not''' use these fields to store phone numbers.
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_custom_31 - h_custom_40
+
| align = "left"            | h_custom_31 - h_custom_40
−
|                             <!-- Data Type/Capacity --> TEXT/unlimited*
+
|                             TEXT/unlimited*
−
|                             <!-- Description        --> ''TEXT'' custom fields 31 - 40 each suitable for holding large amounts of text characters of any type.
+
|                           ''TEXT'' custom fields 31 - 40 each suitable for holding large amounts of text characters of any type.
  
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_backout_plan
+
| align = "left"            | h_backout_plan
−
|                             <!-- Data Type/Capacity --> Text/Unlimited*
+
|                             Text/Unlimited*
−
|                            <!-- Description        --> The Back Out Plan of a Change or Release Request
+
|                            The Back Out Plan of a Change or Release Request
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_support_plan
+
| align = "left"            | h_support_plan
−
|                             <!-- Data Type/Capacity --> Text/Unlimited*
+
|                             Text/Unlimited*
−
|                             <!-- Description        --> The Support Plan  of a Change or Relase Request
+
|                             The Support Plan  of a Change or Relase Request
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_communication_plan
+
| align = "left"            | h_communication_plan
−
|                             <!-- Data Type/Capacity --> Text/Unlimited*
+
|                             Text/Unlimited*
−
|                            <!-- Description        --> The Communication Plan of a Change or Release Request
+
|                            The Communication Plan of a Change or Release Request
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_test_plan
+
| align = "left"            | h_test_plan
−
|                             <!-- Data Type/Capacity --> Text/Unlimited*
+
|                             Text/Unlimited*
−
|                             <!-- Description        --> The Test Plan of a Change or Release Request
+
|                             The Test Plan of a Change or Release Request
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_implementation_plan
+
| align = "left"            | h_implementation_plan
−
|                             <!-- Data Type/Capacity --> Text/Unlimited*
+
|                             Text/Unlimited*
−
|                             <!-- Description        --> The Implementation Plan of a Change or Release Request
+
|                             The Implementation Plan of a Change or Release Request
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_security_implication
+
| align = "left"            | h_security_implication
−
|                             <!-- Data Type/Capacity --> Text/Unlimited*
+
|                           Text/Unlimited*
−
|                             <!-- Description        --> The Security Implications of a Change or Release Request
+
|                             The Security Implications of a Change or Release Request
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_change_justification
+
| align = "left"            | h_change_justification
−
|                             <!-- Data Type/Capacity --> Text/Unlimited*
+
|                             Text/Unlimited*
−
|                             <!-- Description        --> The Change Justification a Change Request
+
|                             The Change Justification a Change Request
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_release_justification
+
| align = "left"            | h_release_justification
−
|                             <!-- Data Type/Capacity --> Text/Unlimited*
+
|                             Text/Unlimited*
−
|                             <!-- Description        --> The Change Justification a Release Request
+
|                             The Change Justification a Release Request
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_release_plan
+
| align = "left"            | h_release_plan
−
|                             <!-- Data Type/Capacity --> Text/Unlimited*
+
|                             Text/Unlimited*
−
|                             <!-- Description        --> The Release Plan for a Release Request
+
|                             The Release Plan for a Release Request
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_disruption_level
+
| align = "left"            | h_disruption_level
−
|                            <!-- Data Type/Capacity --> VarChar/255 Characters
+
|                            VarChar/255 Characters
−
|                            <!-- Description        --> The Disruption Level of a Change or Release Request
+
|                            The Disruption Level of a Change or Release Request
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_change_category  
+
| align = "left"            | h_change_category  
−
|                             <!-- Data Type/Capacity --> VarChar/100 Characters
+
|                             VarChar/100 Characters
−
|                             <!-- Description        --> The Category of a Change Request
+
|                             The Category of a Change Request
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_release_category  
+
| align = "left"            | h_release_category  
−
|                             <!-- Data Type/Capacity --> VarChar/100 Characters
+
|                             VarChar/100 Characters
−
|                            <!-- Description        --> The Category of a Release Request
+
|                            The Category of a Release Request
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_proposed_start_time
+
| align = "left"            | h_proposed_start_time
−
|                            <!-- Data Type/Capacity --> DATETIME/a single date-time stamp
+
|                            DATETIME/a single date-time stamp
−
|                             <!-- Description        -->  The Proposed Start date/time of the a Change or Release Request - (YYYY-MM-dd HH:mm:ss). These columns should ONLY be used in conjunction with a date-time picker
+
|                             The Proposed Start date/time of the a Change or Release Request - (YYYY-MM-dd HH:mm:ss). These columns should ONLY be used in conjunction with a date-time picker
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_proposed_end_time
+
| align = "left"            | h_proposed_end_time
−
|                             <!-- Data Type/Capacity --> DATETIME/a single date-time stamp
+
|                             DATETIME/a single date-time stamp
−
|                            <!-- Description        -->  The Proposed End date / time of the a Change or Release Request - (YYYY-MM-dd HH:mm:ss). These columns should ONLY be used in conjunction with a date-time picker
+
|                            The Proposed End date / time of the a Change or Release Request - (YYYY-MM-dd HH:mm:ss). These columns should ONLY be used in conjunction with a date-time picker
  
 
|-
 
|-
−
| align = "left"            |<!-- Column Name  --> h_workaround
+
| align = "left"            | h_workaround
−
|                             <!-- Data Type/Capacity --> Text/Unlimited*
+
|                             Text/Unlimited*
−
|                             <!-- Description        -->  The Workaround for a Problem or Known Error record
+
|                               The Workaround for a Problem or Known Error record
  
 
|}
 
|}

Latest revision as of 21:34, 13 February 2024

This document can now be found at its new location in the Hornbill Document Library.

Mapping Fields from Customized Forms

Retrieved from "https://wiki.hornbill.com/index.php?title=Mapping_Fields_from_Customised_Forms&oldid=31969"