CustomFieldDefinitions: Teamleader Focus Custom Field Definitions |
Catalog: Teamleader
Schema: V2
Primary Keys: id
Label: Custom Field Definitions
This is a read-only table. The Teamleader Focus API may not support changing the data or the Invantive UniversalSQL driver for Teamleader Focus does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Teamleader Focus API.
Table Columns
The columns of the table CustomFieldDefinitions are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
configuration_extra_option_allowed |
boolean |
Extra Option Allowed |
☐ |
|
configuration_options |
string |
Configuration Options |
☐ |
|
context |
string |
Context |
☑ |
Type of data for which this custom field can store values, such as 'company' or 'project'. |
group |
string |
Group |
☐ |
Group for grouping multiple custom fields in the web frontend. |
id |
string |
ID |
☑ |
Unique ID of the custom field definition. |
label |
string |
Label |
☐ |
Label for display with the value in the web frontend. |
required |
boolean |
Required |
☑ |
Whether a value must be provided. |
type |
string |
Type |
☑ |
Type of the values stored, such as 'auto_increment', 'integer', 'contact', 'number' or 'multi_line'. |
value_id |
string |
Value ID |
☐ |
|
value_type |
string |
Value Type |
☐ |
|
value |
string |
Value |
☐ |
|
10-09-2024 14:03 Version 24.1.8-BETA+4877