Mapping Fields from Customised Forms: Difference between revisions

From Hornbill
Jump to navigation Jump to search
No edit summary
No edit summary
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
This document can now be found at its new location in the [https://docs.hornbill.com/servicemanager-config/customize/mapping-fields-from-customized-forms/ Hornbill Document Library].
[[file:hornbill-document-library.png|Mapping Fields from Customized Forms|link=https://docs.hornbill.com/servicemanager-config/customize/mapping-fields-from-customized-forms/]]
<!--
<div style="border:1px solid #90C0FF; background:#D0E0FF; width:99%; padding:4px; margin-bottom:10px;">
<div style="border:1px solid #90C0FF; background:#D0E0FF; width:99%; padding:4px; margin-bottom:10px;">
__NOTOC__[[Main Page|Home]] > [[Administration]] > [[Intelligent Capture Designer]] > Mapping Fields from Customised Forms
__NOTOC__[[Main Page|Home]] > [[Administration]] > [[Intelligent Capture Designer]] > Mapping Fields from Customised Forms
Line 47: Line 52:


|-
|-
| align = "left"            |<!-- Column Name  --> h_summary
| align = "left"            |h_summary
|                            <!-- Data Type/Capacity --> VARCHAR/255 characters
|                            VARCHAR/255 characters
|                            <!-- Description        --> The Summary field of a request
|                            The Summary field of a request


|-
|-
| align = "left"            |<!-- Column Name  --> h_description
| align = "left"            | h_description
|                             <!-- Data Type/Capacity --> TEXT/unlimited*
|                             TEXT/unlimited*
|                             <!-- Description        --> The description field of a request
|                             The description field of a request


|-
|-
| align = "left"            |<!-- Column Name  --> h_site
| align = "left"            |h_site
|                            <!-- Data Type/Capacity --> VARCHAR/64 characters
|                            VARCHAR/64 characters
|                            <!-- Description        --> The site field for a request
|                            The site field for a request
|-
|-
| align = "left"            |<!-- Column Name  --> h_custom_a - h_custom_o
| align = "left"            | h_custom_a - h_custom_o
|                            <!-- Data Type/Capacity --> VARCHAR/255 characters
|                            Data Type/Capacity VARCHAR/255 characters
|                            <!-- Description        --> ''VARCHAR'' custom fields a - o each suitable for holding up to 255 characters of any type.
|                            Description        ''VARCHAR'' custom fields a - o each suitable for holding up to 255 characters of any type.


|-
|-
| 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.


|-
|-
| 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


|}
|}
Line 175: Line 181:
* Once you have configured field mapping in your progressive capture custom forms, you may need to expose the mapped field on the request. See the [[Request_Details_Form_Designer|'''Request Details Form Designer''']] for more information.
* Once you have configured field mapping in your progressive capture custom forms, you may need to expose the mapped field on the request. See the [[Request_Details_Form_Designer|'''Request Details Form Designer''']] for more information.
* When creating your email template, simply look for the '''custom''' options available from the variables drop-down pick list. Selecting the required variable in your email template, will pass through the answer from your custom question which has been mapped to the corresponding custom field.
* When creating your email template, simply look for the '''custom''' options available from the variables drop-down pick list. Selecting the required variable in your email template, will pass through the answer from your custom question which has been mapped to the corresponding custom field.
 
-->
[[Category:Administration]]
[[Category:HDOC]]

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"