Download PDF
Download page Creating and Managing Fields.
Creating and Managing Fields
Using Schema Manager, you can create custom fields for standard or custom objects.
You cannot change the data type of a field once it is created. Additionally, you cannot delete a field if it is linked to other items such as objects, fields, or records.
To create a new field for a custom/standard object
- Log in to the Conga Platform as an admin user.
- Click the App Launcher (
) icon from the top-left corner then go to Admin Console > Schema Manager.
- Use Basic Search to locate the object you want to update. Click the object name to open object details.
- Click Create New Field.
Enter or select values in the following common fields:
The field containing data type column information is only visible and appropriate to that specific data type. All other fields without a data type column are displayed for all data types.
Field Description Display Name Enter a user-friendly display name for the field. Data Type Select the data type from the list. Other fields are rendered based on the data type selection. For a list of data types, see Custom Field Types. Field Name Accept this value or change it to override the default, which is auto-populated from the display name. For example, entering Test 123
in the Display Name field auto-populates the field name as "Test_123". You can enter up to 58 characters in this field.Description Enter a description of the field. This description will appear as additional information about the field's purpose or usage when you enable the Info Icon for the field in CX Studio. To learn more about enabling the info icon, see Managing Content Details View.
Data Type Description Default Value Enter or select a default value for the field, depending on the data type.
This field is only visible for Boolean, String, Currency, Date Time, Date, Picklist, MultiPicklist, Double, Decimal, Int, and Image data types.
Picklist Name Picklist Search and select the picklist that you will use for this new field. For more information on how to create a picklist, see Creating and Managing a Picklist. Length String Enter the string length. The maximum length for the String data type is 2000, and the maximum length for the LongString data type is 10000. Precision Currency, Double, and Decimal Specify the total length of the value. The maximum precision value that can be set is 24. Scale Currency, Double, and Decimal
Specify the total number of digits after the decimal point. The maximum scale value that can be set is 23.
This field is only used for display purposes for the Currency data type.
AutoNumber Initial Seed AutoNumber Enter the initial seed value. You can also add a prefix.
AutoNumber Prefix AutoNumber Enter the prefix to add to the initial seed value.
For example: If you add PLI as a prefix and your initial seed value is 00001, the new record will have the incremental number with the PLI prefix, e.g. PLI-00001, PLI-00002, and so on.
Complex Metadata Name Complex and Complex Array Search and select the complex metadata. Complex metadata is used to create a complex field by nesting multiple fields with different data types—such as strings or numbers—into a single field.
For more information on creating complex metadata, see Managing Complex Metadata.
Reference Object Name Reference Search and select the object that this field refers to. Lookup Object Name Lookup Search and select the lookup object. Target Object Rollup Search and select the name of the object that the rollup field value is dependent on. This lists objects with fields that have a Reference data type.
Target Object Field Rollup Search and select the field within the target object to be used for computation.
The target object field must have a Double, Integer, or Decimal data type and have queryable, numeric, and non-formula fields.
Rollup Function Rollup Select the appropriate function that applies to the field that this field targets. This lists options according to the data type of the target object field.
Is Sortable Enable this toggle to indicate that this field can be used as an order-by clause in search criteria.
- This field is enabled by default if you enable the Is Queryable field.
- Except for Auto Number, Long String, Complex, and Image, this field is visible for all data types.
Is Required Enable this toggle to make this field mandatory.
Except for Auto Number and Rollup, this field is visible for all data types.
Is Rich Text LongString Enable this toggle to use rich text formatting with this field. Is Unique Enable this toggle to mark the field as unique. This prevents the creation of a new field with the same name.
This field is only visible for String, Currency, Reference, Double, Decimal, and Int data types.
Is Queryable Enable this toggle to indicate that this field can be used in the where clause. Queryable fields can be used in order by clauses as well.
- When you enable this field, the Is Sortable field is enabled by default.
- Except for Auto Number, Complex, Long String, and Image, this field is visible for all data types.
Is Calculated Enable this toggle to indicate that this field is a formula field.
This field is only visible for Boolean, String, Currency, Date Time, Date, Reference, Double, Decimal, and Int data types.
Formula Click Construct a formula here to open the Formula Builder, which allows you to create simple to complex expressions used to calculate field values for your object. For more information on how to create a formula field, see Formula Builder.
This field is only visible if you enable the Is Calculated toggle.
- Click Save & Create New to start creating a new field or click Save to save the created field.
To update the field
- Click the More (
) icon for the relevant field from the list and select Edit.
- Modify the required fields as necessary.
- Click Save.
To deprecate the field
Only custom fields can be deprecated.
- Click the More (
) icon for the relevant field from the list and select Deprecate.
- From the confirmation dialog, click Confirm.
To delete the field
You cannot delete out-of-the-box (OOTB) fields. Only custom fields can be deleted.
- Click the More (
) icon for the relevant custom field from the list and select Delete.
- From the confirmation dialog, click Confirm