Set up page fields

PDF
Products
All Creatio products

Add, modify, hide or delete fields on a record page in the Page Designer. You can also manage the section data structure (i. e., the list of section columns). Creatio adds a new column to the section data structure after you add a new field to the section page and save the changes.

When selecting a column in the Page Designer’s toolbar, review the list in the Existing column block first. The designer might already have the needed column ready for placement. If such a column does not exist, use the elements from the New column block.

Add a field based on the existing column 

The Existing columns block of the Page elements menu displays columns that are already available in the section. These columns are not always displayed on the record page, but they are used in the Creatio database and cannot be deleted.

Some of the columns can be required on the object level: you cannot create a record in the database if you do not fill them out. Required columns are marked with an asterisk (*) (Fig. 1).

Attention. Add all required columns as fields to the record page to ensure that the record page opens correctly.

Fig. 1 A required field in the Page Designer
scr_section_wizard_required_field.png

To add existing columns to the page:

  1. Open the relevant section, e. g., Requests.

  2. Click ViewOpen Section Wizard.

  3. Take the following steps in the Section pages block of the Section Wizard:

    1. Click Edit page if the section has a single page.

    2. Click the link to the relevant page if the section has several pages.

  4. Drag existing columns from the Existing columns area to the record page.

    The areas where you can place the field are highlighted. The names of the columns present on the page are highlighted in gray, but you can add the columns again.

    Fig. 2 Adding existing columns to a record page
    gif_section_wizard_drag_existing_columns.gif

Attention. If you add a new column to a page in the Page Designer and accidentally drop it on top of another column, the new column does not appear in the Page Designer's working area.

To change the column width, drag the edge of a corresponding field.

You can also change the column height for multiline text fields (Fig. 3).

Fig. 3 Resizing a multiline field
gif_section_wizard_enlarge_column_size.gif

Attention. Make sure the unique Code value of the new column does not coincide with the code of other configuration objects. Collision of unique object codes leads to compilation errors, as well as block the modification of schema and integration of Creatio data with external services.

To modify the field properties, highlight the field and click btn_section_wizard_column_edit.png (Fig. 4).

Fig. 4 Edit a field in the Page Designer
chapter_section_wizard_edit_column.png

To delete a field from the page, highlight the field and click btn_delete_record_on_dtl.png (Fig. 5).

Fig. 5 Deleting a field from the record page
gif_section_wizard_delete_column.gif

Attention. Removing a field from the page will not delete the corresponding column from the section object. You can delete an object column through the Configuration section only. Learn more in developer documentation: Creatio IDE. Besides, you can only delete the columns you created yourself and only if they have not been added to object pages. Delete the columns from the package in which you defined them. Base columns, such as “Id,” “Created by,” etc., cannot be deleted.

Add a field based on a new column 

The New column block of the page elements area displays available types of columns that you can add to the page.

See the type list below:

Column type

Type of field on the page

Case

String

A text field. Can contain letters, numbers, and other characters. Multiline text fields support line breaks and can have a variable height. String fields have several additional parameters. Read more >>>

Single line fields: the Full name and Full job title fields on the contact page.

Multiline fields: the Result details field on the activity page.

Integer

A numeric field that can only contain integer numbers (no fractional numbers).

If you use a field of “Integer” type on the page, the analytical data based on the values of this field will be rounded up to integers.

The Age field on the contact page.

Decimal

A numeric field that can contain fractional numbers.

The Payment amount field on the invoice page.

Date/time

“Date/Time” type fields register calendar data.

The Start and Due fields on the activity page.

Lookup

Lets you select values from a manually created or imported list. The values available for selection are stored in the corresponding lookups. Users can fill out lookup fields by selecting a value from either a drop-down list or selection box. Lookup fields have several additional parameters. Read more >>>

Drop-down list lookup fields: the Type and Role fields on the contact page.

Selection box lookup fields: the Owner and Reporter fields on the activity page.

Boolean

Can contain one of the two logic values: “Yes/No.”

A boolean field cannot be required.

Checkbox fields, such as the Remind owner, Remind author fields on the activity page.

To add a new field to the section:

  1. Open the relevant section, e. g., Requests.

  2. Click ViewOpen Section Wizard.

  3. Take the following steps in the Section pages block of the Section Wizard:

    • Click Edit page if the section has a single page.

    • Click the link to the relevant page if the section has several pages.

  4. Select the needed column type in the New column area and drag it to the page, similarly to adding existing columns (Fig. 6).

    Dragging a new column to the section page will add a new field of the corresponding type and a new corresponding column to the database.

    Fig. 6 Adding a new column to the record page
    chapter_section_wizard_drag_column_to_page.stg.gif

    Attention. When you add a new field to a page and save the changes in the Section Wizard, Creatio will add the corresponding column to the section object as well.

  5. Specify the parameters of the new column and the field from which to populate the column (Fig. 7). The set of available parameters differs depending on the type of field.
    Fig. 7 Set up the parameters
    scr_section_wizard_new_column_setup_example.png

Set up the “String” type field 

When managing string columns, you can use single line text fields or multiline text fields.

The Multiline text checkbox is unique to “String” type fields. Multiline text fields have variable heights and are designed for entering larger volumes of text that might take several paragraphs. For example, the Result details field on an activity page is a multiline field. If you select the Multiline text checkbox, you will be able to modify the field height in the Page Designer by dragging (Fig. 8).

Leave the Multiline text checkbox clear to add a single line text field.

Fig. 8 Resizing a multiline field
gif_section_wizard_enlarge_column_size.gif

Specify how many characters a page field can contain in the Text length field (Fig. 9). You can set the Text length field value to 50 characters, 250 characters, 500 characters, or make the field length unlimited.

Fig. 9 Specify the text length
scr_section_wizard_new_string_column_setup_example.png

Note. Text field length setup for the Pre-configured page business process element in the Pre-configured Page Designer works similarly.

Set up the “Decimal” type field 

The “Decimal” field lets you customize the precision of decimal numbers, ranging from 1 to 8 digits after the decimal point (Fig. 10). You can also select “Integer” to change the field type to “Integer”. Select “Currency” if you intend to use the field with financial data.

Fig. 10 Customize the number precision in the “Decimal” column
scr_section_wizard_setup_decimal_field.png

Note. Lowering the number precision for existing “Decimal” fields will make the calculated data based on these fields less accurate.

Set up the “Date/time” type field 

You can use the Format field to select the date format when setting up a “Date/Time” column for your section page (Fig. 11). The Format field provides the following options:

  • “Date.” The field will only display the specified date in the corresponding format.
  • “Time.” The field will only display the specified time.
  • “Date/Time.” The field will display both the specified date and time.
Fig. 11 Specify the “Date/Time” column format
scr_section_wizard_new_date_column_setup_example.png

When you modify the “Date/Time” column format for the existing section, the data in this column is updated for existing records as well. If the new column format is less precise than the previous format, the data for existing records also becomes less precise. For example, if you change the “Date/Time” format to “Date”, the time data will not display. In this case, Creatio will display a corresponding notification.

Note. “Date/Time” column format setup for the Pre-configured page business process element in the Pre-configured Page Designer works similarly.

Set up the “Lookup” type field 

Fill out the “Lookup” field by selecting a value from a list. To set up this field, specify the object to use as the lookup, the lookup view, and the connection type between the records in the current object and the lookup object.

Lookup object 

The list of lookup values is based on the records of a lookup object. Depending on whether the needed object already exists, select the Select existing lookup or Add new lookup option.

If you select an existing lookup, specify the lookup object in the Lookup field. For example, select the “Contact” object as a lookup for the Owner field (Fig. 12).

Fig. 12 Selecting an existing lookup
gif_section_wizard_existing_lookup_parameters.gif

Select Add new lookup to add a new Creatio object. Specify the name and title for the new lookup object (Fig. 13):

Fig. 13 Adding a new lookup field
gif_section_wizard_new_lookup_parameters.gif
  1. Specify a title that distinguishes the lookup object from other objects in the Title field.

  2. Specify a code for the new lookup object in the database in the Name field. The object name must contain a prefix. You can specify the prefix in the “Prefix for object name” (“SchemaNamePrefix” code) system setting. The prefix is set to “Usr” by default.

    Note. Saving the changes in the Section Wizard will automatically register a new lookup in Creatio and bind this lookup to the package where the Wizard saves changes. The lookup name will match the name specified in the Title field. You can view and modify the lookup content via the Lookups section. Learn more in a separate article: Manage lookup values.

Lookup view 

The lookup view determines the field type that represents a lookup column on a page:

  • Select the “List” view to make the lookup field a drop-down list (Fig. 14). This view is a good option for fields that contain a small number of lookup values.

    Fig. 14 A drop-down list view of a lookup field
    chapter_section_wizard_dropdown_list.png
  • Select the “Selection window” view to make the field open a selection box that contains lookup values (Fig. 15). Filter, edit or delete existing lookup records, as well as add new records in the box. This view is a good option if you use an object of a different section, e. g., Contacts, as a lookup.

    Fig. 15 A lookup selection box
    scr_section_wizard_dictionary_popup_window.png
  • If you want to preserve detail records when you delete the record to which the detail is linked, select the Block deletion if there are connected records with these values option. Otherwise, select Delete records with this value (Fig. 16).

    Fig. 16 Block the record deletion
    scr_block_deleting_records.png

Add a tooltip to the field 

  1. Open the relevant section, e. g., Requests.
  2. Click ViewOpen Section Wizard.
  3. Take the following steps in the Section pages block of the Section Wizard:
    • Click Edit page if the section has a single page.
    • Click the link to the relevant page if the section has several pages.
  4. Select a field that needs a tooltip and click btn_section_wizard_column_edit.png. If such a field does not exist yet, add it.
  5. Enter the text users are going to see in the Tooltip field of the column setup window (Fig. 17). You can add HTML markup to the tooltip. Use HTML to add bold text, lists, hyperlinks, and other formatting options.
    Fig. 17 Add a tooltip to the field
    scr_section_wizard_setup_tooltip.png
  6. Click Save.

    As a result, the field on the record page will have an icn_tooltip.png icon in the top left. Hover over the icon to see the tooltip (Fig. 18).

    Fig. 18 View a tooltip
    scr_section_wizard_open_tooltip.png