The Format section

This topic describes the Format section of the Data model. 

 

In this section, you can create, edit, and manage row templates, also called style templates, for each Entity in the Data model: you can configure different formatting elements (i.e. backgrounds, borders, fonts etc.) for each Member, for values related to Members, for totals and grand totals.

You can then apply the template to a Data View Object, which must have the Entity the template is associated with set By Row in the Axes area of the Layout definition.

 

You can access this section in one of the following ways:

  • Access the designer space of the desired Data model and click on the Format tile
  • Select a Data View in a Screen in Design Mode and then click on the "TEMPLATES" button under the "TEMPLATES" menu in the contextual right panel

Since a template is a configuration set to a specific Entity, it is saved in the Data model where that Entity resides, under the "Format" section. In this case, nothing is saved in the Capsule except for one or more links to the templates in use. If you need to share a template between different Board Platforms (for example, a template created in a Development environment that needs to be available also in a Production environment), you must use the Transporter tool or recreate it manually in the desired Platform.

 

The Format page displays a table with all existing templates that contains the following information:

  • Style template. This column displays the title of each template. This is what you will use to associate the template with a Data View
  • Entity. This column displays the name of the Entity that each corresponding row template is associated with.

The table is sortable and searchable using the interactive header fields.

 

 

Creating a row template

To create a new row template, proceed as follows:

  1. Click on "+TEMPLATE" in the upper left corner to bring up the "New template" pop-up window
  2. Enter the name of the new template in the "Title" field
  3. Choose the Entity to which you want to associate the template 
  4. (Optional). Enable or disable the "Set as default" checkbox. If enabled, the current template will be automatically applied to Data View Objects when said Entity is set By Row in the associated Layout.

You can create as many templates as needed, but there can be only one default template for each Entity of the Data model.

 

 

Managing and applying row templates

You can perform different actions on one or more existing row templates by selecting them and clicking on the different buttons that appear above the template list.

The available actions are described below.

  • To edit a template, select it and click on the "EDIT" button. See the next paragraph for more detailed information
  • To rename a template, select it and click on the "RENAME" button. A pop-up window will appear for you to enter the new name and save it
  • To create a copy of an existing template, select it and click on the "SAVE AS" button. A pop-up window will appear for you to enter the name of the copy of the template and save it
  • To delete one or more templates, select them and click on the "DELETE" button

You cannot change the Entity an existing row template is associated with. This is applies when you copy a template: the copy of the template will be associated with the same Entity as the original template.

 

To apply an already configured template to a Data View Object, proceed as follows:

  1. Select the desired Data View Object in a Screen in Design Mode. The Layout associated with the Data View must contain at least one Entity that has templates associated with it set By Row
  2. Open the "TEMPLATES" menu in the contextual right panel
  3. Select the desired template from the "Row template" drop-down list. The list is presented as a tree view with the Entities being the root and the templates associated with them being the leaf elements. You can also access the template configuration window to edit the chosen template by clicking the pencil icon next to the drop-down list

In the case where an Entity with a default template is used in the Layout associated with the Data View, the "Row template" drop-down list will automatically select that default template. 

It's important to understand the order in which Board applies formatting styles to the Data View, as this sequence determines how it will appear to the end user.
First, the default Data View style is applied, then the style defined via the Block Format button (if any). Finally, the row style defined in the Template section is applied (if any). If one of those properties is not defined, the previous one in the sequence is applied.

 

 

Editing a row template

To edit any template, select it from the list and click EDIT to open the template configuration window. From it, you can customize the cell background color, cell borders, font settings, and number format for the following elements of each row:

  • Members (Members of the Entity set By Row)
  • Values (the cells of the row)
  • Totals (all cells displaying calculated subtotals, if any)
  • Grand Totals

To customize the style of the desired elements in the template configuration window, proceed as follows:

  1. Select the items that you want to customize by clicking on the corresponding cells.
    You can select one or multiple items at once by holding the CTRL or SHIFT key on your keyboard and clicking on the desired cells. The selected items will be highlighted by a blue border. In addition, you can select all cells of the first row ("Default Row Template") to automatically apply the formatting to all other rows below
  2. Edit the following format settings as needed:
    • Choose a background color under the "BACKGROUND" menu
    • Choose a border color under the "BORDERS" menu and then choose the thickness of each border in their corresponding drop-down list
    • Configure the font under the "FONTS" menu. Here you can choose the font family, font size, text style, foreground color, and text alignment
    • Configure the following additional settings under the "OPTIONS" menu:
      • Symbol before. Enter a symbol, word, or phrase which will be added as a prefix to the values displayed in the selected cells
      • Symbol after. Enter a symbol, word, or phrase which will be added as a suffix to the values displayed in the selected cells
      • Decimal digits. Enter the number of decimal digits that are displayed after the comma in the values in the selected cells
      • Format negative numbers with parentheses. If enabled, negative numbers in the cells are displayed in parentheses and are not preceded by the minus sign
    • Configure default formatting for single Entities or single members of an Entity in the "UNDERLINE/SERIES DEFAULT FORMATTING" menu:
      • Data View underline height (property only for Data views). It sets the height of the underline for the Entity/member. If the value is greater than zero, it enables the underline on the Data view (0 = disabled). If different values are entered, the higher value is applied to all columns
      • Pattern. If a pattern is selected, the following two related properties appear below: 
        • Pattern color. Sets a fill pattern for the underline
        • Pattern background color. Sets a color for the underline background
      • Color. This property is only available if no pattern is selected. It defines a solid color for the underline of a Data view and for series/categories of any chart that has the corresponding Entity in the Layout associated with it
      • Border width. This option determines the border width for the series/categories of the chart. If the entered value is greater than zero, it also enables the border on the Data view underline, but in this case the width is fixed and won't change regardless of the configured value
      • Border color. Sets a color for the border of series/categories/underline.

        In the Data View, the properties you set in a template work also if the associated Entity is set by Column, is used in a “Refer To” or a  “Detail By” option. In charts, these properties also work if the associated Entity is set in the Series/Categories fields (and Categories, in the Pie chart) of the Layout, in a “Refer To” or in a  “Detail By” option.

        When a template is applied to categories of a Bar chart, border settings are ignored (no border is displayed). This is a known limitation.

        In case of a “Refer To” option in place, only the template set as default for charts for the chosen Entity is applied and it cannot be changed at the Object level, as the template has the highest priority over any other formatting option.
        In case of a “Refer To” option in place and no default template configured for charts on the chosen Entity, no template is automatically applied: to apply one, the user must select it manually from the “Row Template” dropdown menu under the “Templates” menu on the right.

        MULTIPLE TEMPLATES
        There can be only one template applied to a single Object: the template set manually in the "Template" widget has always the highest priority.
        If one or more "Refer To" options are set in the Layout and none of the configured Entities is linked to a default template, the template set in the "Template" widget is always applied.

        MULTIPLE DEFAULT TEMPLATES
        If no template has been set in the "Template" widget, the template is applied following the rules below.

        Layouts with multiple "Refer To" options OR multiple "Detail By" options
        If multiple "Refer To" options are set in the Layout and the corresponding Entities have a default template, the only template applied is the one defined by the first "Refer To" option encountered in the Block list. This also applies to Layouts with multiple "Detail By" options (and no "Refer To" options).

        Layouts with multiple "Refer To" options AND multiple "Detail By" options
        If one or more "Refer To" options are set in the Layout along with one or more "Detail By" options and the corresponding Entities have a default template, the only template applied is the one defined by the first "Refer To" option encountered in the Block list, as the "Refer To" option in this case has the highest priority.

         

        To ensure backward compatibility, a “SET AS DEFAULT FOR CHARTS” is at top of the “Row style template” configuration page (disabled by default).

        A “Formatting” column in the preview table shows the visual effect of the new settings.

        The properties are not available for columns other than the “Member” one

  3. Click on "SAVE" in the bottom right corner to save the template settings

The "Format negative numbers with parentheses" option shouldn't be used on cells where data entry is enabled, because it doesn't allow you to save manually entered values. 

Enable the "SET AS DEFAULT" option next to the template name to set it as the default one for the Entity it is associated with.

 

Format Behavior

The new “Disable default format template” property (checkbox) allows the Developer to override the formatting options applied by a template: when this happens, the formatting options become active again and can be changed freely. 
When the user overrides the last formatting options applied (via the Row style template, Block format, “Refer To” or “Detail By”, etc.), those options are kept as a starting point for the user, who can customize them as he sees fit.

If you set a template as default (for charts or for Data views), the template is automatically applied to all existing eligible Objects only if they have not been manually associated with other templates.
You cannot manually remove a template that is set as default for an Entity unless you enable the "Disable default format template".
You can create as many templates as needed, but there can be only one default template for each Entity of the Data model: setting a template as the default on the same Entity where a default template was already configured will make the last template created the default one.

If a template applies some custom formatting properties only to specific members of an Entity, other members of that Entity will inherit the existing formatting properties applied at the Object level.