GraphQLRepositoriesfield
entities.field
Read field records with the field repository, and change them with the field mutations. Same records as the REST Fields entity.
Queries
Fields of entities { field { … } }.
| Kind | Field | Returns |
|---|---|---|
| QUERY | getById(entityId: ID!)Returns the record with the given id, or null when there is none. Deleted records are returned as well. | FieldEntity |
| QUERY | getByIds(entityIds: [ID!]!)Returns the records with the given ids; ids without a record are left out. Deleted records are returned as well. | [FieldEntity!]! |
| QUERY | getAll(limit: Int, offset: Int, filter: FieldFilterInput, orderBy: [FieldOrderByInput!], includeDeleted: Boolean)Returns the records that match the filter, paged with limit and offset. | [FieldEntity!]! |
| QUERY | getByCriteria(filter: FieldFilterInput, orderBy: [FieldOrderByInput!], includeDeleted: Boolean, before: String, after: String, first: Int, last: Int)Returns the records that match the filter as a cursor-paginated connection. | FieldEntityConnection |
| QUERY | getPublished(limit: Int, offset: Int, filter: FieldFilterInput, orderBy: [FieldOrderByInput!], includeDeleted: Boolean)Returns the published records that match the filter, paged with limit and offset. | [FieldEntity!]! |
| QUERY | getDrafts(filter: FieldFilterInput, orderBy: [FieldOrderByInput!])Returns the records that match the filter, with pending unpublished changes applied where a draft exists. | [FieldEntity!]! |
| QUERY | getDraftById(entityId: ID!)Returns the record with the given id, with its pending unpublished changes applied when a draft exists. | FieldEntity! |
Mutations
| Kind | Mutation | Does | Returns |
|---|---|---|---|
| MUTATION | deleteField(input: DeleteDraftFieldInput!) | Soft-delete | DeleteFieldPayload |
| MUTATION | createField(input: CreateDraftFieldInput!) | Create one record | CreateFieldPayload |
| MUTATION | updateField(input: UpdateDraftFieldInput!) | Update fields | UpdateFieldPayload |
Types
The types this repository uses, each with its fields and their descriptions. Types several repositories share, such as PageInfo and the filter fields, are in the types index.
FieldEntity object 51 fields: isDeleteProtected, hasDraft, id, …
Field of an entity, built-in or custom, with its name, type and configuration.
| Field | Type | Description |
|---|---|---|
isDeleteProtected | Boolean! | True when the record is protected against deletion because it must always exist in the space. Deleting a record that is not protected can still fail on other checks. Read-only. |
hasDraft | Boolean | True when the record has unpublished draft changes, including pending translation changes, that can be published. |
id | ID! | Unique identifier of entity. |
isDeleted | Boolean | True when the field is marked as deleted (soft-delete). |
modified | DateTime | Last modification time. |
created | DateTime | Creation time. |
entityName | String! | Related entity name for field (e.g. Account, Contact, Lead, Opportunity, ...). Must be a concrete entity: abstract parents such as LeadOppty or Activity are rejected. To share a field between Lead and Opportunity (or Task and Appointment), create it on one of them and set mapDependency to the other. |
apiName | String | Immutable and generated name. This name is used for integrations. |
name | String! | User friendly name for field. |
useLang | Int | When true, the field name is treated as a translation key and resolved through the translation system; otherwise the literal name is shown. |
columnName | String | Storage column name for the field; used as the filter key in API queries. |
columnSource | Int | Storage origin of the field: on the main entity record, on the custom-field data record, or computed. |
relationId | String | For relation-typed fields, identifier of the relation kind that connects this entity to the related entity. Empty for non-relation fields. |
relationWithEntityId | String | For relation-typed fields, the entity the field points to (e.g. Contact, Account). Empty for non-relation fields. |
sharedWithFieldId | ID | When the field is shared between abstract entities (e.g. Lead and Opportunity), id of the counterpart field on the other entity. Empty when the field is not shared. |
systemType | Int | Whether the field is System (built-in, immutable), Protected (built-in, limited changes), or Custom (user-created). |
typeId | String! | Type of the field. Supported field types are: checkbox, currency, currency_foreign, date, datetime, dropdown, email, float, input, integer, multiselect_checkbox, phone, radio, sequence, text_area, url |
compositeFieldId | ID | For sub-fields of a composite field (e.g. the value/currency parts of a foreign currency field), id of the parent composite field. Empty for top-level fields. |
dataSetId | ID | Optional custom data set id can be set. |
parentOptionsFieldId | ID | For dependent dropdown/radio fields, id of the parent field whose selected value restricts the options shown on this field. |
calcFormula | String | Calculated formula used for fields which supports calculation. |
defaultValue | String | Value pre-filled into this field on newly created records, as text converted to the field type; empty for no default. Accepted only by field types that support a default value. |
sequenceSetId | ID | For sequence-typed fields, id grouping the FieldSequence rows that drive auto-numbering for this field. |
sequenceId | UUID | Deprecated; always returns null. Use sequenceSetId and FieldSequence instead. |
systemRequired | Boolean | True when the field cannot be made optional (enforced by the platform). |
isPublished | Boolean | True when the field configuration is published; false while the field exists only as an unpublished draft. |
systemReadonly | Boolean | True when the field cannot be made writable (enforced by the platform). |
useInGlobalSearch | Boolean | If this field is allowed in global search. |
settings | JSONString | Type-specific configuration for the field (e.g. rollup definition, calculated formula, AI options). Shape depends on type_id; null for fields that need no extra configuration. |
isUnique | Boolean | If true, then there will be an API validation if value of entity is unique. |
dataSet | [FieldDataSetRelation!] (1 args) | For dropdown, radio, and multiselect-checkbox fields, the set of available options. Empty for other field types. |
lookup | LookupProperty | Lookup field definition. |
sequencePattern | String | Deprecated - previously returned sequence pattern used for sequence type of field. |
sequence | SequenceProperty | Sequence field definition. |
rollup | RollupProperty | Rollup field definition. |
options | FieldOptionsProperty | Type-specific settings of the field, such as the decimal places of a number or the display of a record card; the shape depends on typeId. Empty for types without settings. |
aiOptions | FieldAiOptions | AI Smart Field options. Available for input, text_area, integer, float, email, phone, url, currency. |
advancedFormula | AdvancedFormulaProperty | Formula of a calculated formula field - the expression, its result type and display - as a JSON object conforming to the AdvancedFormulaProperty type; empty for other field types. |
sourceFieldId | String! | For derived fields, id of the underlying source field that drives this field's value (e.g. the value side of a composite currency field). |
sourceTypeId | String! | Underlying primitive type id of the field, after resolving composite/rollup/lookup wrappers. |
useInInterfacePreview | Boolean! | True when the field can be used in the record interface preview pane. |
translatedName | String! | Field name resolved into the current user's language. When useLang is true, the name is looked up via the translation system; otherwise name is returned as-is. |
fieldPermissions | [FieldPermissionEntity!] (1 args) | Per-user-role access overrides for this field. Empty when the field uses default access (full access for all roles). |
originalDatasetFieldId | UUID | When multiple dropdown/radio fields share a data set, id of the field that originally defined the data set. Null when this field is the originator or has no data set. |
nameTranslations | JSONString! | Map of locale codes to translated field names (e.g. {"en-US": "First name", "de-DE": "Vorname"}). Empty when no translations are defined. |
nameTranslated | String | Field name in the current user's language, taken from nameTranslations. Empty when no translation is available for that language. |
primitiveType | String! | Primitive value type of the field (e.g. STRING, INT, BOOL, DATE, ENUM), derived from sourceTypeId. |
isReadonlyOnRecurrentAppointment | Boolean! | True when the field cannot be edited on individual occurrences of a recurring appointment (changes must be made on the recurrence master). |
isAvailableForWebresource | Boolean! | True when the field can be referenced from a Webresource URL template. |
isAvailableForAdvancedFormula | Boolean! | True when the field can be used as an input in an advanced calculated formula expression on this entity. |
instancePermissions | [EntityPermsEnum!]! (1 args) | Permissions the current user has on this record, out of the requested ones. |
FieldEntityConnection object pageInfo: PageInfo!, edges: [FieldEntityEdge]!, totalCount: Int
Paginated list of Field records.
| Field | Type | Description |
|---|---|---|
pageInfo | PageInfo! | Pagination data for this connection. |
edges | [FieldEntityEdge]! | Contains the nodes in this connection. |
totalCount | Int | Total number of items in the connection. |
FieldEntityEdge object node: FieldEntity, cursor: String!
A Relay edge containing a FieldEntity and its cursor.
| Field | Type | Description |
|---|---|---|
node | FieldEntity | The item at the end of the edge |
cursor | String! | A cursor for use in pagination |
FieldFilterInput input AND, OR, NOT, globalSearchQuery, one condition per field
Filter conditions for Field records. Conditions on different fields are combined with AND; use OR, AND and NOT for other combinations.
| Input field | Type | Description |
|---|---|---|
OR | [FieldFilterInput!] | Matches records that meet at least one of the listed filters. |
AND | [FieldFilterInput!] | Matches records that meet all of the listed filters. |
NOT | FieldFilterInput | Matches records that do not meet this filter. |
globalSearchQuery | String | Search term matched against the fields that the global search covers for this entity. |
id | EntityFilterStringField | Unique identifier of entity. |
isDeleted | Boolean | True when the field is marked as deleted (soft-delete). |
modified | EntityFilterDateTimeField | Last modification time. |
created | EntityFilterDateTimeField | Creation time. |
entityName | EntityFilterStringField | Related entity name for field (e.g. Account, Contact, Lead, Opportunity, ...). Must be a concrete entity: abstract parents such as LeadOppty or Activity are rejected. To share a field between Lead and Opportunity (or Task and Appointment), create it on one of them and set mapDependency to the other. |
apiName | EntityFilterStringField | Immutable and generated name. This name is used for integrations. |
name | EntityFilterStringField | User friendly name for field. |
useLang | EntityFilterNumberField | When true, the field name is treated as a translation key and resolved through the translation system; otherwise the literal name is shown. |
columnName | EntityFilterStringField | Storage column name for the field; used as the filter key in API queries. |
columnSource | EntityFilterNumberField | Storage origin of the field: on the main entity record, on the custom-field data record, or computed. |
relationId | EntityFilterStringField | For relation-typed fields, identifier of the relation kind that connects this entity to the related entity. Empty for non-relation fields. |
relationWithEntityId | EntityFilterStringField | For relation-typed fields, the entity the field points to (e.g. Contact, Account). Empty for non-relation fields. |
sharedWithFieldId | EntityFilterStringField | When the field is shared between abstract entities (e.g. Lead and Opportunity), id of the counterpart field on the other entity. Empty when the field is not shared. |
systemType | EntityFilterNumberField | Whether the field is System (built-in, immutable), Protected (built-in, limited changes), or Custom (user-created). |
typeId | EntityFilterStringField | Type of the field. Supported field types are: checkbox, currency, currency_foreign, date, datetime, dropdown, email, float, input, integer, multiselect_checkbox, phone, radio, sequence, text_area, url |
compositeFieldId | EntityFilterStringField | For sub-fields of a composite field (e.g. the value/currency parts of a foreign currency field), id of the parent composite field. Empty for top-level fields. |
dataSetId | EntityFilterStringField | Optional custom data set id can be set. |
parentOptionsFieldId | EntityFilterStringField | For dependent dropdown/radio fields, id of the parent field whose selected value restricts the options shown on this field. |
calcFormula | EntityFilterStringField | Calculated formula used for fields which supports calculation. |
defaultValue | EntityFilterStringField | Value pre-filled into this field on newly created records, as text converted to the field type; empty for no default. Accepted only by field types that support a default value. |
sequenceSetId | EntityFilterStringField | For sequence-typed fields, id grouping the FieldSequence rows that drive auto-numbering for this field. |
systemRequired | Boolean | True when the field cannot be made optional (enforced by the platform). |
isPublished | Boolean | True when the field configuration is published; false while the field exists only as an unpublished draft. |
systemReadonly | Boolean | True when the field cannot be made writable (enforced by the platform). |
useInGlobalSearch | Boolean | If this field is allowed in global search. |
isUnique | Boolean | If true, then there will be an API validation if value of entity is unique. |
sequencePattern | EntityFilterStringField | Deprecated - previously returned sequence pattern used for sequence type of field. |
FieldOrderByInput input Asc or Desc per field
Sorting of Field records. Set exactly one field in each item; list several items to sort by more fields, in order of priority.
| Input field | Type | Description |
|---|---|---|
id | OrderByEnum | Unique identifier of entity. |
isDeleted | OrderByEnum | True when the field is marked as deleted (soft-delete). |
modified | OrderByEnum | Last modification time. |
created | OrderByEnum | Creation time. |
entityName | OrderByEnum | Related entity name for field (e.g. Account, Contact, Lead, Opportunity, ...). Must be a concrete entity: abstract parents such as LeadOppty or Activity are rejected. To share a field between Lead and Opportunity (or Task and Appointment), create it on one of them and set mapDependency to the other. |
apiName | OrderByEnum | Immutable and generated name. This name is used for integrations. |
name | OrderByEnum | User friendly name for field. |
useLang | OrderByEnum | When true, the field name is treated as a translation key and resolved through the translation system; otherwise the literal name is shown. |
columnName | OrderByEnum | Storage column name for the field; used as the filter key in API queries. |
columnSource | OrderByEnum | Storage origin of the field: on the main entity record, on the custom-field data record, or computed. |
relationId | OrderByEnum | For relation-typed fields, identifier of the relation kind that connects this entity to the related entity. Empty for non-relation fields. |
relationWithEntityId | OrderByEnum | For relation-typed fields, the entity the field points to (e.g. Contact, Account). Empty for non-relation fields. |
sharedWithFieldId | OrderByEnum | When the field is shared between abstract entities (e.g. Lead and Opportunity), id of the counterpart field on the other entity. Empty when the field is not shared. |
systemType | OrderByEnum | Whether the field is System (built-in, immutable), Protected (built-in, limited changes), or Custom (user-created). |
typeId | OrderByEnum | Type of the field. Supported field types are: checkbox, currency, currency_foreign, date, datetime, dropdown, email, float, input, integer, multiselect_checkbox, phone, radio, sequence, text_area, url |
compositeFieldId | OrderByEnum | For sub-fields of a composite field (e.g. the value/currency parts of a foreign currency field), id of the parent composite field. Empty for top-level fields. |
dataSetId | OrderByEnum | Optional custom data set id can be set. |
parentOptionsFieldId | OrderByEnum | For dependent dropdown/radio fields, id of the parent field whose selected value restricts the options shown on this field. |
calcFormula | OrderByEnum | Calculated formula used for fields which supports calculation. |
defaultValue | OrderByEnum | Value pre-filled into this field on newly created records, as text converted to the field type; empty for no default. Accepted only by field types that support a default value. |
systemRequired | OrderByEnum | True when the field cannot be made optional (enforced by the platform). |
isPublished | OrderByEnum | True when the field configuration is published; false while the field exists only as an unpublished draft. |
systemReadonly | OrderByEnum | True when the field cannot be made writable (enforced by the platform). |
useInGlobalSearch | OrderByEnum | If this field is allowed in global search. |
isUnique | OrderByEnum | If true, then there will be an API validation if value of entity is unique. |
sequencePattern | OrderByEnum | Deprecated - previously returned sequence pattern used for sequence type of field. |
AdvancedFormulaPropertyParams input 5 fields: formula, type, displayOption, …
Definition of an advanced formula field: the formula, the type of its result and how the result is displayed.
| Input field | Type | Description |
|---|---|---|
formula | String! | Expression evaluated to produce the field value, referencing other fields by id. |
type | AdvancedFormulaTypeEnum! | Result type of the formula — integer, float, currency, string, date, datetime or bool. |
displayOption | AdvancedFormulaDisplayOptionEnum | How a numeric result is formatted — Number, Percentage, Days, Months, Years or Custom (uses displayOptionCustomValue as a suffix). |
displayOptionCustomValue | String | Custom suffix appended to the result when displayOption is Custom. |
decimalPlaces | Int | Number of decimal places a numeric result is rounded to for display. |
CreateDraftFieldInput input 23 fields: clientMutationId, modified, created, …
Parameters of the createField mutation.
| Input field | Type | Description |
|---|---|---|
clientMutationId | String | Optional client-supplied identifier passed on a mutation input and echoed back unchanged on its payload, so a client can correlate the response with its request (Relay convention). |
modified | DateTime | Last modification time. |
created | DateTime | Creation time. |
entityName | String! | Related entity name for field (e.g. Account, Contact, Lead, Opportunity, ...). Must be a concrete entity: abstract parents such as LeadOppty or Activity are rejected. To share a field between Lead and Opportunity (or Task and Appointment), create it on one of them and set mapDependency to the other. |
name | String! | User friendly name for field. |
typeId | String! | Type of the field. Supported field types are: checkbox, currency, currency_foreign, date, datetime, dropdown, email, float, input, integer, multiselect_checkbox, phone, radio, sequence, text_area, url |
dataSetId | ID | Optional custom data set id can be set. |
parentOptionsFieldId | ID | For dependent dropdown/radio fields, id of the parent field whose selected value restricts the options shown on this field. |
calcFormula | String | Calculated formula used for fields which supports calculation. |
defaultValue | String | Value pre-filled into this field on newly created records, as text converted to the field type; empty for no default. Accepted only by field types that support a default value. |
useInGlobalSearch | Boolean | If this field is allowed in global search. |
isUnique | Boolean | If true, then there will be an API validation if value of entity is unique. |
dataSet | [FieldDataSetItem!] | For dropdown, radio, and multiselect-checkbox fields, the set of available options. Empty for other field types. |
mapDependency | String | Set at field creation to also create this field on another (related) entity, identified by its entity api name — used to share/map the field across entities. Write-only on create. |
lookup | LookupPropertyParams | Lookup field definition. |
sequencePattern | String | Deprecated - previously returned sequence pattern used for sequence type of field. |
sequence | SequencePropertyParams | Sequence field definition. |
rollup | RollupPropertyParams | Rollup field definition. |
options | FieldOptionsPropertyJSONString | Type-specific settings of the field, such as the decimal places of a number or the display of a record card; the shape depends on type_id. Empty for types without settings. |
aiOptions | FieldAiOptionsParams | AI Smart Field options. Available for input, text_area, integer, float, email, phone, url, currency. |
advancedFormula | AdvancedFormulaPropertyParams | Formula of a calculated formula field - the expression, its result type and display - as a JSON object conforming to the AdvancedFormulaProperty type; empty for other field types. |
fieldPermissions | [FieldPermissionNoFieldBackrefInput!] | Per-user-role access overrides for this field. Empty when the field uses default access (full access for all roles). |
nameTranslations | JSONString | Map of locale codes to translated field names (e.g. {"en-US": "First name", "de-DE": "Vorname"}). Empty when no translations are defined. |
DeleteDraftFieldInput input clientMutationId: String, id: ID
Parameters of the deleteField mutation.
| Input field | Type | Description |
|---|---|---|
clientMutationId | String | Optional client-supplied identifier passed on a mutation input and echoed back unchanged on its payload, so a client can correlate the response with its request (Relay convention). |
id | ID | Unique identifier of entity. |
FieldAiGeneralOptionsParams input 8 fields: prompt, dataSourcesEnabled, webSearchEnabled, …
What the AI uses to generate the value of an AI Smart Field: the prompt and the enabled data sources.
| Input field | Type | Description |
|---|---|---|
prompt | String! | Instruction the AI follows to generate the field value; it can contain placeholders for values of the record. |
dataSourcesEnabled | Boolean! | When true, the AI can use the data sources enabled below (web search, record data, related records and documents); when false, it uses none of them. |
webSearchEnabled | Boolean! | When true (and dataSourcesEnabled), the AI can search the web. |
recordDataEnabled | Boolean! | When true (and dataSourcesEnabled), the AI receives the field values of the record. |
relatedRecordsEnabled | Boolean! | When true (and dataSourcesEnabled), the AI receives the related records listed in relatedRecords. |
relatedRecords | [FieldAiOptionsRelatedRecordParams!]! | Kinds of related records the AI receives, one item per kind. |
recordDocumentsEnabled | Boolean! | When true (and dataSourcesEnabled), the AI receives the documents attached to the record. |
recordDocumentsFilter | FieldFilterParams | Condition selecting which attached documents the AI receives; all when not set. |
FieldAiOptionsParams input isEnabled: Boolean!, general: FieldAiGeneralOptionsParams!, valueUpdate: FieldAiValueUpdateOptionsParams!
AI Smart Field settings of a field: whether AI generates its value, from which data and when.
| Input field | Type | Description |
|---|---|---|
isEnabled | Boolean! | When true, the field is an AI Smart Field whose value is generated by AI. |
general | FieldAiGeneralOptionsParams! | What the AI uses to generate the value: the prompt and the data sources. |
valueUpdate | FieldAiValueUpdateOptionsParams! | When the AI value is generated or updated. |
FieldAiOptionsRelatedRecordParams input targetEntity: EntityNameEnum!, targetEntityApiName: String, entityRelationId: ID, filter: FieldFilterParams
Kind of related records the AI receives when it generates the value of an AI Smart Field.
| Input field | Type | Description |
|---|---|---|
targetEntity | EntityNameEnum! | Entity of the related records; CustomEntity for a custom entity (see targetEntityApiName). |
targetEntityApiName | String | API name of the custom entity when targetEntity is CustomEntity; null otherwise. |
entityRelationId | ID | Id of the relation that links the record to these related records: a system entity relation or a lookup field. |
filter | FieldFilterParams | Condition selecting which related records the AI receives; all when not set. |
FieldAiValueUpdateOptionsParams input 6 fields: manualEnabled, autoUpdateOnRecordCreate, autoUpdateOnRecordUpdate, …
When the value of an AI Smart Field is generated or updated.
| Input field | Type | Description |
|---|---|---|
manualEnabled | Boolean! | When true, users can request a new AI value for a record manually. |
autoUpdateOnRecordCreate | Boolean! | When true, the AI value is generated when a record is created. |
autoUpdateOnRecordUpdate | Boolean! | When true, the AI value is generated again whenever a record is updated. |
autoUpdateScheduled | Boolean! | When true, the AI values are generated again on the schedule in autoUpdateSchedule. |
autoUpdateSchedule | FieldAiValueUpdateScheduleParams | Schedule of the periodic update; used when autoUpdateScheduled is true. |
autoUpdateScheduledFilter | FieldFilterParams | Condition limiting which records the scheduled update processes; all records of the entity when not set. Each generated value consumes AI credits. |
FieldAiValueUpdateScheduleParams input date: DateTime, timeOfDay: Int, dayOfWeek: [Int!], dayOfMonth: [Int!]
Schedule of the periodic update of AI Smart Field values.
| Input field | Type | Description |
|---|---|---|
date | DateTime | Date and time the schedule runs once. Set for a one-time schedule; left empty for recurring schedules that use the time-of-day and day fields instead. |
timeOfDay | Int | Time of day a recurring schedule runs, in minutes after midnight (0 to 1439). |
dayOfWeek | [Int!] | Weekdays a weekly schedule runs on, from 1 (Monday) to 7 (Sunday). |
dayOfMonth | [Int!] | Days of the month a monthly schedule runs on, from 1 to 31. |
FieldDataSetItem input 5 fields: id, optionName, optionNameTranslations, …
Option of a dropdown, radio or multiselect field, as set when creating or changing a draft field.
| Input field | Type | Description |
|---|---|---|
id | UUID | Id of an existing option to change; leave empty to add a new option. |
optionName | String! | Label of the option shown to users; translations go in optionNameTranslations. |
optionNameTranslations | JSONString | Map of locale codes to translated option names (e.g. {"en-US": "Hot"}). |
calcValue | Float! | Numeric value of the option, used in calculation formulas. |
allowedBy | [ID] | For dependent fields, the values of the parent field this option is available for. |
FieldPermissionNoFieldBackrefInput input masterRightId: UUID!, permissionLevel: AccessLevelFieldEnum!
Access level a user role gets to a draft field, overriding the default access.
| Input field | Type | Description |
|---|---|---|
masterRightId | UUID! | Id of the user role the access override applies to. |
permissionLevel | AccessLevelFieldEnum! | Access the user role gets to the field. |
LookupPropertyParams input 7 fields: entityType, tabName, filter, …
Definition of a lookup field: the entity it links to, which records can be selected and the tab that shows the linked records.
| Input field | Type | Description |
|---|---|---|
entityType | LookupEntityTypeEnum | Entity the lookup field links to; CustomEntity for a custom entity (see entityApiName). |
tabName | String! | Name of the tab that shows the records linked through this field. |
filter | FieldFilterParams | Condition limiting which records can be selected in the field. |
showRelated | Boolean! | When true, the field offers only records related to the record being edited (e.g. the contacts of its account). |
entityApiName | String | API name of the linked custom entity when entityType is CustomEntity; null otherwise. |
oppositeLookupFieldId | UUID | Id of the matching lookup field on the linked entity, which shows the same links from the other side. Set by the server; ignored on input. |
hasPrimaryRelation | Boolean | When true, one of the linked records can be marked as primary. Cannot be switched back to false once enabled. |
RollupPropertyParams input 7 fields: entityRelationId, targetEntity, entityApiName, …
Definition of a rollup field: which related records it aggregates and with which function.
| Input field | Type | Description |
|---|---|---|
entityRelationId | ID | Relation the rollup follows to reach the related records: the name of an entity relation, or the id of the lookup field on the source entity for a custom relation. |
targetEntity | EntityNameEnum! | Entity kind whose related records are aggregated by this rollup. |
entityApiName | String | API name of the target custom entity, set when targetEntity is a custom entity. |
aggregationFunction | RollupFieldAggregationFunctionEnum! | How related values are combined — Count, Average, Sum, First, Last, Min or Max. |
fieldId | ID | Id of the field whose values are aggregated; null for Count, and for First and Last when the whole related record is returned. |
filter | FieldFilterParams | Field-condition filter selecting which related records are aggregated. |
sortFieldId | ID | Id of the field the related records are sorted by to pick the First or Last one. |
SequenceItemPropertyParams input id: ID, pattern: String!, filter: FieldFilterParams, lastParticle: SequenceParticlePropertyParams
One numbering sequence of a sequence field: its number pattern, the records it numbers and the last number it issued.
| Input field | Type | Description |
|---|---|---|
id | ID | Id of the sequence; empty for a new sequence. |
pattern | String! | Pattern template used to generate auto-numbered values (e.g. "{prefix}{year}-{####}"). |
filter | FieldFilterParams | Conditions a record must meet to be numbered by this sequence; empty matches every record. |
lastParticle | SequenceParticlePropertyParams | Last number issued by the sequence and its period. Read-only. |
SequenceParticlePropertyParams input year: Int!, month: Int!, sequenceNumber: Int!
Last number issued by a numbering sequence of a sequence field, with the year and month of its numbering period.
| Input field | Type | Description |
|---|---|---|
year | Int! | Year of the numbering period; 0 when the pattern has no year. |
month | Int! | Month of the numbering period; 0 when the pattern has no month. |
sequenceNumber | Int! | Last number issued in the period. |
SequencePropertyParams input defaultItem: SequenceItemPropertyParams!, items: [SequenceItemPropertyParams!]!
Automatic numbering of a sequence field: a default numbering sequence and conditional ones chosen by record filters.
| Input field | Type | Description |
|---|---|---|
defaultItem | SequenceItemPropertyParams! | Sequence used for records that match none of the items. |
items | [SequenceItemPropertyParams!]! | Conditional sequences, checked in order; a record is numbered by the first one whose filter it matches. |
UpdateDraftFieldInput input 20 fields: clientMutationId, id, isDeleted, …
Parameters of the updateField mutation.
| Input field | Type | Description |
|---|---|---|
clientMutationId | String | Optional client-supplied identifier passed on a mutation input and echoed back unchanged on its payload, so a client can correlate the response with its request (Relay convention). |
id | ID | Unique identifier of entity. |
isDeleted | Boolean | True when the field is marked as deleted (soft-delete). |
modified | DateTime | Last modification time. |
created | DateTime | Creation time. |
name | String | User friendly name for field. |
useLang | Int | When true, the field name is treated as a translation key and resolved through the translation system; otherwise the literal name is shown. |
parentOptionsFieldId | ID | For dependent dropdown/radio fields, id of the parent field whose selected value restricts the options shown on this field. |
calcFormula | String | Calculated formula used for fields which supports calculation. |
defaultValue | String | Value pre-filled into this field on newly created records, as text converted to the field type; empty for no default. Accepted only by field types that support a default value. |
useInGlobalSearch | Boolean | If this field is allowed in global search. |
dataSet | [FieldDataSetItem!] | For dropdown, radio, and multiselect-checkbox fields, the set of available options. Empty for other field types. |
lookup | LookupPropertyParams | Lookup field definition. |
sequence | SequencePropertyParams | Sequence field definition. |
rollup | RollupPropertyParams | Rollup field definition. |
options | FieldOptionsPropertyJSONString | Type-specific settings of the field, such as the decimal places of a number or the display of a record card; the shape depends on type_id. Empty for types without settings. |
aiOptions | FieldAiOptionsParams | AI Smart Field options. Available for input, text_area, integer, float, email, phone, url, currency. |
advancedFormula | AdvancedFormulaPropertyParams | Formula of a calculated formula field - the expression, its result type and display - as a JSON object conforming to the AdvancedFormulaProperty type; empty for other field types. |
fieldPermissions | [FieldPermissionNoFieldBackrefInput!] | Per-user-role access overrides for this field. Empty when the field uses default access (full access for all roles). |
nameTranslations | JSONString | Map of locale codes to translated field names (e.g. {"en-US": "First name", "de-DE": "Vorname"}). Empty when no translations are defined. |
CreateFieldPayload object field: FieldEntity, clientMutationId: String
Result of the createField mutation.
| Field | Type | Description |
|---|---|---|
field | FieldEntity | The created record. |
clientMutationId | String | Optional client-supplied identifier passed on a mutation input and echoed back unchanged on its payload, so a client can correlate the response with its request (Relay convention). |
DeleteFieldPayload object field: FieldEntity, clientMutationId: String
Result of the deleteField mutation.
| Field | Type | Description |
|---|---|---|
field | FieldEntity | The deleted record. |
clientMutationId | String | Optional client-supplied identifier passed on a mutation input and echoed back unchanged on its payload, so a client can correlate the response with its request (Relay convention). |
UpdateFieldPayload object field: FieldEntity!, clientMutationId: String
Result of the updateField mutation.
| Field | Type | Description |
|---|---|---|
field | FieldEntity! | The updated record. |
clientMutationId | String | Optional client-supplied identifier passed on a mutation input and echoed back unchanged on its payload, so a client can correlate the response with its request (Relay convention). |
AccountCardProperty object showArchivedRecords: Boolean!
Settings of the account card of leads, opportunities and quotes, which shows their linked accounts.
| Field | Type | Description |
|---|---|---|
showArchivedRecords | Boolean! | If true, archived records are shown when selecting and displaying the linked records in this card. |
AdvancedFormulaDisplayOptionEnum enum Number, Percentage, Days, Months, Years, Custom
How a numeric formula result is displayed.
| Value | Description |
|---|---|
Number | Plain number. |
Percentage | Shown as a percentage. |
Days | Shown as a number of days. |
Months | Shown as a number of months. |
Years | Shown as a number of years. |
Custom | Shown with the custom suffix given in displayOptionCustomValue. |
AdvancedFormulaProperty object 5 fields: formula, type, displayOption, …
Definition of an advanced formula field: the formula, the type of its result and how the result is displayed.
| Field | Type | Description |
|---|---|---|
formula | String! | Expression evaluated to produce the field value, referencing other fields by id. |
type | AdvancedFormulaTypeEnum! | Result type of the formula — integer, float, currency, string, date, datetime or bool. |
displayOption | AdvancedFormulaDisplayOptionEnum | How a numeric result is formatted — Number, Percentage, Days, Months, Years or Custom (uses displayOptionCustomValue as a suffix). |
displayOptionCustomValue | String | Custom suffix appended to the result when displayOption is Custom. |
decimalPlaces | Int | Number of decimal places a numeric result is rounded to for display. |
AdvancedFormulaTypeEnum enum integer, float, currency, string, date, datetime, bool
Data type of the result of an advanced (calculated) formula.
| Value | Description |
|---|---|
integer | Whole number. |
float | Decimal number. |
currency | Monetary amount. |
string | Text. |
date | Calendar date. |
datetime | Date with time. |
bool | True or false. |
ClosingDateProperty object isRecurrenceEnabled: Boolean!
Settings of the closing date field of opportunities: whether recurrence is enabled.
| Field | Type | Description |
|---|---|---|
isRecurrenceEnabled | Boolean! | If true, recurrence is enabled for this closing-date field. |
ContactAccountCardProperty object showArchivedRecords: Boolean!
Settings of the related accounts card of contacts, which shows the accounts a contact is linked to.
| Field | Type | Description |
|---|---|---|
showArchivedRecords | Boolean! | If true, archived records are shown when selecting and displaying the linked records in this card. |
ContactCardProperty object showArchivedRecords: Boolean!
Settings of the contact card of leads, opportunities and quotes, which shows their linked contacts.
| Field | Type | Description |
|---|---|---|
showArchivedRecords | Boolean! | If true, archived records are shown when selecting and displaying the linked records in this card. |
CountryProperty object enableCustomValues: Boolean!
Settings of a country field: whether values outside the country list are accepted.
| Field | Type | Description |
|---|---|---|
enableCustomValues | Boolean! | If true, values outside the predefined country list can be entered. |
CurrencyForeignProperty object decimalPlaces: Int!
Settings of a foreign currency field: the number of decimal places shown.
| Field | Type | Description |
|---|---|---|
decimalPlaces | Int! | Number of decimal places the value is rounded to for display. |
CurrencyProperty object decimalPlaces: Int!
Settings of a currency field: the number of decimal places shown.
| Field | Type | Description |
|---|---|---|
decimalPlaces | Int! | Number of decimal places the value is rounded to for display. |
DueDateProperty object isRecurrenceEnabled: Boolean!
Settings of the due date field of tasks: whether recurrence is enabled.
| Field | Type | Description |
|---|---|---|
isRecurrenceEnabled | Boolean! | If true, recurrence is enabled for this due-date field. |
FieldAiGeneralOptions object 8 fields: prompt, dataSourcesEnabled, webSearchEnabled, …
What the AI uses to generate the value of an AI Smart Field: the prompt and the enabled data sources.
| Field | Type | Description |
|---|---|---|
prompt | String! | Instruction the AI follows to generate the field value; it can contain placeholders for values of the record. |
dataSourcesEnabled | Boolean! | When true, the AI can use the data sources enabled below (web search, record data, related records and documents); when false, it uses none of them. |
webSearchEnabled | Boolean! | When true (and dataSourcesEnabled), the AI can search the web. |
recordDataEnabled | Boolean! | When true (and dataSourcesEnabled), the AI receives the field values of the record. |
relatedRecordsEnabled | Boolean! | When true (and dataSourcesEnabled), the AI receives the related records listed in relatedRecords. |
relatedRecords | [FieldAiOptionsRelatedRecord!]! | Kinds of related records the AI receives, one item per kind. |
recordDocumentsEnabled | Boolean! | When true (and dataSourcesEnabled), the AI receives the documents attached to the record. |
recordDocumentsFilter | FieldFilter | Condition selecting which attached documents the AI receives; all when not set. |
FieldAiOptions object isEnabled: Boolean!, general: FieldAiGeneralOptions!, valueUpdate: FieldAiValueUpdateOptions!
AI Smart Field settings of a field: whether AI generates its value, from which data and when.
| Field | Type | Description |
|---|---|---|
isEnabled | Boolean! | When true, the field is an AI Smart Field whose value is generated by AI. |
general | FieldAiGeneralOptions! | What the AI uses to generate the value: the prompt and the data sources. |
valueUpdate | FieldAiValueUpdateOptions! | When the AI value is generated or updated. |
FieldAiOptionsRelatedRecord object targetEntity: EntityNameEnum!, targetEntityApiName: String, entityRelationId: ID, filter: FieldFilter
Kind of related records the AI receives when it generates the value of an AI Smart Field.
| Field | Type | Description |
|---|---|---|
targetEntity | EntityNameEnum! | Entity of the related records; CustomEntity for a custom entity (see targetEntityApiName). |
targetEntityApiName | String | API name of the custom entity when targetEntity is CustomEntity; null otherwise. |
entityRelationId | ID | Id of the relation that links the record to these related records: a system entity relation or a lookup field. |
filter | FieldFilter | Condition selecting which related records the AI receives; all when not set. |
FieldAiValueUpdateOptions object 6 fields: manualEnabled, autoUpdateOnRecordCreate, autoUpdateOnRecordUpdate, …
When the value of an AI Smart Field is generated or updated.
| Field | Type | Description |
|---|---|---|
manualEnabled | Boolean! | When true, users can request a new AI value for a record manually. |
autoUpdateOnRecordCreate | Boolean! | When true, the AI value is generated when a record is created. |
autoUpdateOnRecordUpdate | Boolean! | When true, the AI value is generated again whenever a record is updated. |
autoUpdateScheduled | Boolean! | When true, the AI values are generated again on the schedule in autoUpdateSchedule. |
autoUpdateSchedule | FieldAiValueUpdateSchedule | Schedule of the periodic update; used when autoUpdateScheduled is true. |
autoUpdateScheduledFilter | FieldFilter | Condition limiting which records the scheduled update processes; all records of the entity when not set. Each generated value consumes AI credits. |
FieldAiValueUpdateSchedule object date: DateTime, timeOfDay: Int, dayOfWeek: [Int!], dayOfMonth: [Int!]
Schedule of the periodic update of AI Smart Field values.
| Field | Type | Description |
|---|---|---|
date | DateTime | Date and time the schedule runs once. Set for a one-time schedule; left empty for recurring schedules that use the time-of-day and day fields instead. |
timeOfDay | Int | Time of day a recurring schedule runs, in minutes after midnight (0 to 1439). |
dayOfWeek | [Int!] | Weekdays a weekly schedule runs on, from 1 (Monday) to 7 (Sunday). |
dayOfMonth | [Int!] | Days of the month a monthly schedule runs on, from 1 to 31. |
FieldDataSetRelation object entity: DataEntity!, allowedBy: [ID!]
Option of a dropdown, radio or multiselect field, with the parent field values it is available for.
| Field | Type | Description |
|---|---|---|
entity | DataEntity! | Option of the data set. |
allowedBy | [ID!] | For dependent fields, the values of the parent field this option is available for; null when the field has no parent options field. |
FieldOptionsProperty union RollupProperty | TextAreaProperty | CurrencyProperty | CurrencyForeignProperty | ProductPriceProperty | MultiSelectProperty | FloatProperty | IntegerProperty | ClosingDateProperty | DueDateProperty | LookupSettingsProperty | AdvancedFormulaProperty | FileUploadProperty | OnlineFormProductServicesProperty | AccountCardProperty | ContactCardProperty | OpptyCardProperty | ParentAccountCardProperty | ProjectAccountCardProperty | ContactAccountCardProperty | ProjectContactCardProperty | LinkedItemsProperty | GenderProperty | CountryProperty | LastContactedDateProperty
Type-specific settings of a field; which member type is returned depends on the field type.
FileTypeEnum enum Document, Spreadsheet, Presentation, Pdf, Drawing, Image, … (9 values)
Category of files accepted by a file-upload form field.
| Value | Description |
|---|---|
Document | Text documents (e.g. .pdf, .doc, .docx, .odt, .txt). |
Spreadsheet | Spreadsheets (e.g. .xls, .xlsx, .ods, .csv). |
Presentation | Presentations (e.g. .ppt, .pptx, .odp). |
Pdf | PDF files only. |
Drawing | Drawings and CAD files (e.g. .odg, .dwg, .dxf). |
Image | Images (e.g. .jpg, .png, .gif, .heic, .webp). |
Audio | Audio files (e.g. .mp3, .m4a, .wav, .flac). |
Video | Video files (e.g. .mp4, .mov, .mkv, .avi, .webm). |
Custom | Extensions listed in customFileExtensions. |
FileUploadProperty object 5 fields: maxFiles, maxFileSize, fileTypes, …
Settings of a file upload field: how many files, how large and of which types can be uploaded.
| Field | Type | Description |
|---|---|---|
maxFiles | Int! | Maximum number of files that can be uploaded to this field. |
maxFileSize | Int! | Maximum size per file, in MB. |
fileTypes | [FileTypeEnum!]! | Allowed file-type categories (e.g. image, document); used when file-type restriction is enabled. |
customFileExtensions | [String!]! | Additional allowed file extensions when the Custom file type is selected (e.g. ".dwg"). |
fileTypesEnabled | Boolean! | If true, uploads are restricted to the configured file types and custom extensions; otherwise any file type is accepted. |
FloatProperty object useThousandSeparator: Boolean!, decimalPlaces: Int!, unit: String
Display settings of a decimal number field: decimal places, thousands separator and unit.
| Field | Type | Description |
|---|---|---|
useThousandSeparator | Boolean! | If true, the value is displayed with a thousands separator (e.g. 1,000). |
decimalPlaces | Int! | Number of decimal places the value is rounded to for display. |
unit | String | Unit label appended to the displayed value, such as "kg". |
GenderProperty object showOnForms: Boolean!, showNonBinaryOption: Boolean!
Settings of the gender field of contacts: whether it is offered on online forms and whether it has a non-binary option.
| Field | Type | Description |
|---|---|---|
showOnForms | Boolean! | If true, the gender field is shown on online forms. |
showNonBinaryOption | Boolean! | If true, a non-binary option is offered in addition to the standard gender options. |
IntegerProperty object useThousandSeparator: Boolean!, unit: String
Display settings of a whole number field: thousands separator and unit.
| Field | Type | Description |
|---|---|---|
useThousandSeparator | Boolean! | If true, the value is displayed with a thousands separator (e.g. 1,000). |
unit | String | Unit label appended to the displayed value, such as "kg". |
LastContactedDateProperty object lastContactedDateDefinitionFieldId: UUID
Settings of the last contacted date field of accounts and contacts: the date field that replaces the calculated value, if any.
| Field | Type | Description |
|---|---|---|
lastContactedDateDefinitionFieldId | UUID | Id of the Date / DateTime field whose value replaces the system-calculated Last Contacted Date. When null, the system calculation (the most recent completed call/email task, appointment, sent email or text message) is used. |
LinkedItemsProperty object showArchivedRecords: Boolean!
Settings of the linked items field of activities, emails, memos and other records that can be linked to several records.
| Field | Type | Description |
|---|---|---|
showArchivedRecords | Boolean! | If true, archived records are shown when selecting and displaying the linked records in this card. |
LookupEntityTypeEnum enum Account, Contact, Lead, Opportunity, Task, Appointment, … (12 values)
Entity that a lookup field links to.
| Value | Description |
|---|---|
Account | Company or organization the sales team works with; contacts, leads, opportunities and activities are linked to it. |
Contact | Person the sales team works with, usually linked to one or more accounts, leads and opportunities. |
Lead | Potential sale in its early stage that moves through a lead process until it is qualified into an opportunity or lost. |
Opportunity | Potential deal with a value and closing date that moves through the steps of a sales pipeline until it is won or lost. |
Task | Task (e.g. a to-do or a call) owned by a user, with an optional due date, and linked to records. |
Appointment | Meeting or call scheduled in the calendar, with its invited users and contacts, linked to the records it concerns. |
Product | Product or service in the catalog that can be added as a line item to opportunities and quotes. |
OpptyProductRelation | Product line of an opportunity. |
Client | Users of the space. |
Project | Project delivered for an account or run internally, with its objectives, activities and progress. |
Quote | Price offer for a customer, usually prepared from an opportunity, with product line items; it moves through a quote process. |
CustomEntity | Record of a custom entity, a kind of record the space defines (such as Vehicle or Contract) in addition to the built-in entities. |
LookupPrimaryRelationResolutionEnum enum FirstAddedIntoLookup, LastAddedIntoLookup, LatestCreatedWithinLookup, OldestCreatedWithinLookup
Rule that picks the primary related record when a lookup links several records.
| Value | Description |
|---|---|
FirstAddedIntoLookup | The record added to the lookup first (default). |
LastAddedIntoLookup | The record added to the lookup most recently. |
LatestCreatedWithinLookup | The most recently created linked record. |
OldestCreatedWithinLookup | The oldest linked record. |
LookupProperty object 7 fields: entityType, tabName, filter, …
Definition of a lookup field: the entity it links to, which records can be selected and the tab that shows the linked records.
| Field | Type | Description |
|---|---|---|
entityType | LookupEntityTypeEnum | Entity the lookup field links to; CustomEntity for a custom entity (see entityApiName). |
tabName | String! | Name of the tab that shows the records linked through this field. |
filter | FieldFilter | Condition limiting which records can be selected in the field. |
showRelated | Boolean! | When true, the field offers only records related to the record being edited (e.g. the contacts of its account). |
entityApiName | String | API name of the linked custom entity when entityType is CustomEntity; null otherwise. |
oppositeLookupFieldId | UUID | Id of the matching lookup field on the linked entity, which shows the same links from the other side. Set by the server; ignored on input. |
hasPrimaryRelation | Boolean | When true, one of the linked records can be marked as primary. Cannot be switched back to false once enabled. |
LookupSettingsProperty object primaryRelationResolution: LookupPrimaryRelationResolutionEnum
Settings of a lookup field, such as which linked record is treated as the primary one.
| Field | Type | Description |
|---|---|---|
primaryRelationResolution | LookupPrimaryRelationResolutionEnum | When several records are linked through the lookup, determines which one is treated as the primary related record (e.g. the first one added into the lookup). |
MultiSelectProperty object advancedVisualization: Boolean!
Display settings of a multiselect field.
| Field | Type | Description |
|---|---|---|
advancedVisualization | Boolean! | If true, selected values are rendered with the advanced (chip/tag) visualization instead of a plain comma-separated list. |
OnlineFormProductServicesProperty object 8 fields: showTotalAmount, showProductImages, productSelectionLimitEnabled, …
Settings of a products and services field of online forms: which products are offered and how they are shown.
| Field | Type | Description |
|---|---|---|
showTotalAmount | Boolean! | If true, the combined total amount of the selected products is shown. |
showProductImages | Boolean! | If true, product images are shown in the product list. |
productSelectionLimitEnabled | Boolean! | If true, the number of products that can be selected is limited (see maxSelectedProducts). |
maxSelectedProducts | Int | Maximum number of products that can be selected when the selection limit is enabled. |
fields | [ID!]! | Ids of the product fields shown for each selectable product. |
productListType | ProductListTypeEnum! | Whether the selectable products are a fixed static list or a dynamically filtered set. |
staticProducts | [ID!] | Ids of the products offered when the product list type is static. |
dynamicProductsFilter | FieldFilter | Filter selecting which products are offered when the product list type is dynamic. |
OpptyCardProperty object showArchivedRecords: Boolean!
Settings of the opportunity card of quotes, which shows their opportunity.
| Field | Type | Description |
|---|---|---|
showArchivedRecords | Boolean! | If true, archived records are shown when selecting and displaying the linked records in this card. |
ParentAccountCardProperty object showArchivedRecords: Boolean!
Settings of the parent account card of accounts, which shows the parent account in the account hierarchy.
| Field | Type | Description |
|---|---|---|
showArchivedRecords | Boolean! | If true, archived records are shown when selecting and displaying the linked records in this card. |
ProductListTypeEnum enum Static, Dynamic
How the products offered in an online form are chosen.
| Value | Description |
|---|---|
Static | A fixed list of products (staticProducts). |
Dynamic | Products matching a filter (dynamicProductsFilter). |
ProductPriceProperty object decimalPlaces: Int!
Settings of a product price field: the number of decimal places shown.
| Field | Type | Description |
|---|---|---|
decimalPlaces | Int! | Number of decimal places the value is rounded to for display. |
ProjectAccountCardProperty object showArchivedRecords: Boolean!
Settings of the account card of projects, which shows their linked accounts.
| Field | Type | Description |
|---|---|---|
showArchivedRecords | Boolean! | If true, archived records are shown when selecting and displaying the linked records in this card. |
ProjectContactCardProperty object showArchivedRecords: Boolean!
Settings of the stakeholders card of projects, which shows their linked contacts.
| Field | Type | Description |
|---|---|---|
showArchivedRecords | Boolean! | If true, archived records are shown when selecting and displaying the linked records in this card. |
RollupFieldAggregationFunctionEnum enum Count, Average, Sum, First, Last, Min, Max
How a rollup field combines the values of the related records it summarizes.
| Value | Description |
|---|---|
Count | Number of related records. |
Average | Average of the related values. |
Sum | Total of the related values. |
First | The first related record when ordered by sortFieldId; the result links to that record. |
Last | The last related record when ordered by sortFieldId; the result links to that record. |
Min | Lowest related value. |
Max | Highest related value. |
RollupProperty object 7 fields: entityRelationId, targetEntity, entityApiName, …
Definition of a rollup field: which related records it aggregates and with which function.
| Field | Type | Description |
|---|---|---|
entityRelationId | ID | Relation the rollup follows to reach the related records: the name of an entity relation, or the id of the lookup field on the source entity for a custom relation. |
targetEntity | EntityNameEnum! | Entity kind whose related records are aggregated by this rollup. |
entityApiName | String | API name of the target custom entity, set when targetEntity is a custom entity. |
aggregationFunction | RollupFieldAggregationFunctionEnum! | How related values are combined — Count, Average, Sum, First, Last, Min or Max. |
fieldId | ID | Id of the field whose values are aggregated; null for Count, and for First and Last when the whole related record is returned. |
filter | FieldFilter | Field-condition filter selecting which related records are aggregated. |
sortFieldId | ID | Id of the field the related records are sorted by to pick the First or Last one. |
SequenceItemProperty object id: ID, pattern: String!, filter: FieldFilter, lastParticle: SequenceParticleProperty
One numbering sequence of a sequence field: its number pattern, the records it numbers and the last number it issued.
| Field | Type | Description |
|---|---|---|
id | ID | Id of the sequence; empty for a new sequence. |
pattern | String! | Pattern template used to generate auto-numbered values (e.g. "{prefix}{year}-{####}"). |
filter | FieldFilter | Conditions a record must meet to be numbered by this sequence; empty matches every record. |
lastParticle | SequenceParticleProperty | Last number issued by the sequence and its period. Read-only. |
SequenceParticleProperty object year: Int!, month: Int!, sequenceNumber: Int!
Last number issued by a numbering sequence of a sequence field, with the year and month of its numbering period.
| Field | Type | Description |
|---|---|---|
year | Int! | Year of the numbering period; 0 when the pattern has no year. |
month | Int! | Month of the numbering period; 0 when the pattern has no month. |
sequenceNumber | Int! | Last number issued in the period. |
SequenceProperty object defaultItem: SequenceItemProperty!, items: [SequenceItemProperty!]!
Automatic numbering of a sequence field: a default numbering sequence and conditional ones chosen by record filters.
| Field | Type | Description |
|---|---|---|
defaultItem | SequenceItemProperty! | Sequence used for records that match none of the items. |
items | [SequenceItemProperty!]! | Conditional sequences, checked in order; a record is numbered by the first one whose filter it matches. |
TextAreaProperty object isRichText: Boolean!
Settings of a text area field: whether it holds rich text.
| Field | Type | Description |
|---|---|---|
isRichText | Boolean! | Whether field should be displayed in rich text editor |