# CustomFieldOptions: ActiveCampaign Custom Field Options - Catalog: `ActiveCampaign` - Schema: `V3` - Primary Keys: `id` - Label: Custom Field Options - Retrieve: True - Insert: True - Update: False - Delete: False ## Table Columns The columns of the table `CustomFieldOptions` 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. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `cdate` | `datetime` | Created | ☐ | Moment of creation. | | `field` | `int64` | Custom Field | ☑ | ID of the custom field the option belongs to. | | `id` | `int64` | ID | ☑ | Unique ID. | | `isdefault` | `int64` | Default | ☐ | Whether the option is chosen when nothing is filled in. | | `label` | `varchar2` | Label | ☐ | Text shown for the option. | | `orderid` | `int64` | Order ID | ☐ | Position of the option in the list. | | `udate` | `datetime` | Last Updated | ☐ | Moment of last change. | | `value` | `varchar2` | Value | ☑ | Value stored when the option is chosen. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `field` | [[V3-CustomFields\|V3.CustomFields]] | `id` | Candidate: Follows from the name of the column and held in every filled row of the sandbox on 2026-10-31; not stated by ActiveCampaign in the places read. |