Custom Forms
The custom_forms table contains data about custom forms in the organization, which are displayed when entities are created or conversations are logged.
This table can be used to determine which forms are present in which campaigns, as well as metadata about the custom form such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| name | The name of the custom form. Autogenerated and not displayed in the interface. | VARCHAR | Yes |
| description | This column is currently unused. | TEXT | Yes |
| campaign_id | The numerical identifier of the campaign this custom form is in. Relates to the id column in the campaigns table. |
INT4 | No |
| target_type | The type of object this custom field relates to. Always EntityType. |
VARCHAR | Yes |
| target_type_id | The numerical identifier of the entity type this custom form relates to. Relates to the id column in the entities table. |
INT4 | Yes |
| created_by_id | The numerical identifier of the user who created this custom form. Relates to the id column in the users table. |
INT8 | No |
| deleted_by_id | The numerical identifier of the user who deleted this custom form. Relates to the id column in the users table. |
INT8 | Yes |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |