Custom Fields

KANA Response creates a custom merge field for each custom field.  When a user selects a custom merge field for an outgoing message, KANA Response substitutes the data from the corresponding custom field.

How many custom fields can you create?

The number of custom fields you can create depends on the type of database you are using and the data type of the fields you are creating.  The following table outlines the KANA Response limits on custom fields.

Database

Non-searchable text fields

Other field types

SQL Server

1000

1000

Oracle

1000

1000

DB2

1000 (both types combined)

Custom fields considerations

When adding custom fields keep the following in mind:

Custom fields and departments

Custom fields are not affected by departments.  Custom fields exist only at the root level.

Custom fields and users

You can enable users to edit custom field data in a message in the Partition window in System Administration.

Custom Field Definition Pane

Name: Name of custom field

Description: Description  of custom field

Apply To: Indicates the type of custom field. There are three different type of custom field in Response

     1. Message

     2. Customer

     3. User

Encrypt: You can enable encryption for custom fields by checking the encrypt option.   Once encryption is turned, it is recommended not turn it off.  If needed, create a new custom field with all the same characteristics, but without encryption.

Classify Form Field: In Response KXMF format, custom fields are in key-value format.  Indicates whether the value of custom field passed into classify engine

Mask from Logger: Indicates whether the custom fields details can be logged. This is for PCI security

Apply value to same case messages: Indicates the custom field values are carried over to the new incoming messages within same case.

Hidden Field: Indicates whether the field should be hidden from users. Visible for administrators or users with "Show System Types Custom Fields" permission.

Allow editing: Makes field editable if "Message Custom Field" - allow editing is selected in System Admin -> Partition Screen. This applies to completed messages custom fields too. Custom Fields settings in System Admin -> Partition Screen take precedence over Custom Fields Screen in Content Admin so when editing custom fields is disabled in Partition then all custom fields marked as editable in Content Admin become disabled for editing. Fields settings are preserved so when Admin re-enables editing the fields again, fields previously marked as editable become editable again.

Data types for custom fields

Type

Description

Text

Any text that you want to be able to search and that fits in the following limits for each database:

  • SQL Server: 900 characters

  • Oracle: 700 characters

  • DB2: 255 characters

Long Text

 Any text you expect to be too long to fit into a Text field.  You cannot search this text.  The maximum size for this field is 2 GB.

True/False

 A response to a yes or no question.  Also called a Boolean type.

Date

 Text representing a date in one of the following formats:

  • mm/dd/yy

  • mm/dd/yyyy

  • mm-dd-yy

  • mm-dd-yyyy

  • standard SMTP formats

Integer

 A whole number.

Decimal

 A number containing a decimal point.

Option

 A option containing a set of values to be used as dropdown.

 


How do I add custom fields?

How do I edit a custom field?

How do I delete a custom field?