Skip to main content
Version: 2022

Columns

Introduction to columns​

This chapter contains the options for a column in the Subjects tab.

Columns tab on the Subjects screen* Overview of the Columns tab on the Subjects tab

Model settings​

Case type​

menu User interface > Subjects > tab Default/Variant > tab Columns > tab Form > tab Column

The Case type indicates, for instance, whether only capitals are permitted for the field.

Available options:

  • None
  • Upper case
  • Lower case
  • Initial caps
  • Proper case.

Type of column​

menu User interface > Subjects > tab Default/Variant > tab Columns > tab Form > tab Column

The Column type determines whether the field is presented as:

  • Editable
  • Readonly
  • Hidden.

The type can be defined differently in the grid and the form. However, the column defines the most unrestricted level.

note

The field added_by is set to readonly. It is possible to hide this in the grid. It is, however, not possible to make this normal in the form.

Copy​

Include in insert​

menu User interface > Subjects > tab Default/Variant > tab Columns > tab Form > tab Column

If a new row has to be added to a specific position in the grid, this new row needs to know information about the current row and its sorting. For example, if the grid is sorted by column order_no, the new row needs to know the order_no of the current row. This value is transferred to the default procedure so the new order_no can be determined.

Include in copy​

menu User interface > Subjects > tab Default/Variant > tab Columns > tab Form > tab Column

A record can be copied easily with [Ctrl]+[Alt]+[Plus], but this shouldn't always be possible for all fields. For example, for identity fields, status fields, and trace columns. With Include in copy, you can indicate if a field needs to be transferred when copying a row.

Copy to clipboard​

menu User interface > Subjects > tab Default/Variant > tab Columns > tab Form > tab Column

If Copy to clipboard is selected, it is possible to copy rows from the grid with [Ctrl]+[C].

In a data export, only columns for which Copy to clipboard is selected will be exported.

Performance​

menu User interface > Subjects > tab Default/Variants > tab Columns > tab Form > tab Performance

For some logic mechanisms in Settings, all columns are given automatically as a parameter. In the Performance tab, you can exclude columns not required for these mechanisms.

note

In each default, the Modified by field is filled with the current user. However, for some tables, the default is empty. You cannot turn off the default because then, Modified by will no longer be filled, but you can turn off the unused fields. Fewer data will be transmitted during the execution, so the performance will increase.

Performance settings with Columns Performance settings for columns

Look-up​

For each field you can indicate whether a look-up has to be displayed and which reference it should use.

menu User interface > Subjects > tab Default/Variants > tab Columns > tab Look-up

  1. Select the Show look-up box to make the required fields available.

  2. It is indicated, as default with the look-up table, how this has to be presented. You can deviate from this for each column in field Reference.

  3. In field Look-up control you can indicate for each field whether the look-up presentation field has to be displayed with a combo box, a pop-up window or both. If the look-up table is displayed with a pop-up window, this can be the standard, but a variant can also be displayed.

note

When Show look-up is selected, but no Reference ID filled, then two (or more) references are created. Select the correct table or reference.

Look-up settings for the Tables Overview of the Look-up settings for the Tables

Was this page helpful?