Radio Cards

Behaves like Radio Buttons but each option will be displayed as a larger card.

Radio Cards are useful for drawing special attention to and providing extra explanation for the most important choices in a menu item.

Start value:
Return value:
Supported in: NewEdit Parameter page

Appearance

Three groups of radio cards.

  1. Small
  2. Medium
  3. Large

SQL

SQL Call: Retrieve values (mandatory)

SQL-statement that fills the control with possible values.

May modify database: No

Resultset: Values

Values for the control.

Table count: repeated exactly once
Row count: zero or more rows
Columns
<column with ordinal 1> mandatory string

Id values of the cards (also used as label if column at ordinal 2 is omitted)

<column with ordinal 2> optional string

Label of the cards (if column is omitted values from column at ordinal 1 is used)

Description optional string

Description to show for the option. Not usable when the control size is "Small".

DisabledReason optional string

Disable the option and display the column value as a tooltip.

HideUnlessCurrent optional bit

This column indicates that the value should only be shown as an option if it is the currently chosen value.

Icon optional string

The system icon to use for the option. Only one of this and Svg may be used.

IsRecommended optional bit

Signals to the user that this is the recommended option. Only usable when the control size is "Large".

Pill optional string

Displays text in a pill next to the label. Expects a string or a JSON object with the properties "text" and "color". Only usable when the control size is "Large". Not usable in conjunction with IsRecommended on the same card.

Svg optional binary

Binary data of an svg file to use for the option. Only one of this and Icon may be used.

Default value

SQL Call: Default value

Retrieves the default value for the control.

May modify database: No

Resultset: Default value

Table count: repeated exactly once
Row count: exactly one row
Columns
<column with ordinal 1> mandatory string
The default value

Validation

SQL Call: Validation

This call is only made if there is a field validation set for the field info and the field has any content. Fields used in an editable grid do not use this call.

Live Validation

Performs field validation when the user leaves the field or one of its dependencies is changed, initial values set by default value and initial values in edit-mode are not validated.

Save Validation

When saving the validation runs server side if the field value has changed. A field value is considered changed if in new mode the value is anything other than NULL. In edit mode it is considered changed if it has a value that was not returned by the GetEditFields procedure.

May modify database: No

Parameters

@Value string
The value of the field, the procedure will not be called if value is NULL.

Resultset: Validation messages (optional)

Table count: repeated zero or one time
Row count: zero or one row
Columns
Error optional string
Error message to display. Blocks the user from saving.
Info optional string
Informative message to display. Does not block saving.
Warning optional string
Warning message to display. Does not block saving.

Best practice

Name of stored procedure

The name depends on the usage. If the control is used to retrieve values from a lookup table then the procedure should be named "<Schema>.<LookupTable>_RadioCards". If it is not and the values are not directly linked to rows in a table or the functionality is specific for the current field (say for instance a choice between each of the last six years) then the procedure should be named "<Schema>.<Table>_<Field>_RadioCards".