contact_custom_fields: Freshdesk Contact Custom Fields |
Catalog: Freshdesk
Schema: Freshdesk
Primary Keys: id
Label: Contact Custom Fields
Documentation:
Custom fields for contacts
Can retrieve data and change data using insert, update and delete.
Table Columns
The columns of the table contact_custom_fields are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
choices |
varchar2 |
Choices |
☐ |
Choices available (JSON). |
created_at |
datetime |
Created at |
☐ |
Date/time at which the record was created. |
customers_can_edit |
char |
Customers Can Edit |
☐ |
Whether the field can be updated by customers. |
default |
char |
Default |
☐ |
Whether the field is not a custom field. |
description |
varchar2 |
Description |
☐ |
Description. |
displayed_to_customers |
char |
Displayed to Customers |
☐ |
Whether the field is displayed in the customer portal. |
editable_in_signup |
char |
Editable in Sign-up |
☐ |
Whether the field can be updated by customers during signup. |
id |
int64 |
ID |
☑ |
Unique ID. |
label_for_customers |
varchar2 |
Label for Customers |
☐ |
User-interface label for customers. |
label |
varchar2 |
Label |
☐ |
User-interface label. |
name |
varchar2 |
Name |
☐ |
Name. |
portal_cc_to |
varchar2 |
Portal CC, To |
☐ |
'all' when a customer can add any requester to the CC list and 'company' when a customer can add only company contacts to the CC list. |
portal_cc |
char |
Portal CC |
☐ |
Whether customer can add additional requesters to a ticket. |
position |
int32 |
Position |
☐ |
Position. |
required_for_agents |
char |
Required for Agents |
☐ |
Whether the field is required for agents. |
required_for_closure |
char |
Required for Closure |
☐ |
Whether the field is required for closing the ticket. |
required_for_customers |
char |
Required for Customers |
☐ |
Whether the field is required for customers. |
type |
varchar2 |
Type |
☐ |
Type of custom field such as date, text, etc. |
updated_at |
datetime |
Updated at |
☐ |
Date/time at which the record was last updated. |