Group Expression

The group expression can be used for Array functions like Max (array), Min (array), Mean (array), Sum (array), Length (String) or Concatenation (string).

You have to go through a three-step form wizard to enable this Control, i.e., Design, Validation & Advance. Let’s explain these steps below:

1st Step – Design

This is the first step of the “Group Expression” control form wizard. Here you are required to fill in the following details:

  1. Database Field Name (mandatory): Defines the name of the database field to which the component's data will be mapped and stored.
  2. Label Name (mandatory): Specifies the display name or title for a field or control in the user interface.
  3. Select Format Type: Select format type from the following H1, H2, H3, H4, H5, H6, P, Bold
  4. Column Width: Specifies the width of a column in a layout or grid system, allowing control over how much space the column occupies relative to others.

2nd Step – Validation

  1. Hidden Control?: Select “Yes” if you want the field to be invisible from UI but want the value to be submitted with the request
  2. Date Format: A property that defines the format in which a date is displayed or entered.
  3. Remove Comma’s From Number: A property that determines whether commas should be removed from a number, typically to handle formatting issues when numbers are displayed without thousands separators.

3rd Step – Advance

  1. Function: Select function from the following Max(array), Mean(array), Min(array), Sum(array), Len(String), Concat(String), etc.

Click “Confirm” and “Group Expression” control is configured.