Tips & Tricks - Multiple selection - Format values
Entries from a data group are presented in a view table. A further table column displays values from a child data group. In this case, the control type is set to "Multiple selection" by default. We will show you how you can format this table column to display number values, for example.
The table above shows the floating-point number "10.5" - an example value from a child data group - in the "Number" column. The number is shown as "1.05E1". The same value is shown in the "ID" column but formatted as wanted.
The "Number" data field from the child data group, which contains the value "10.5" in our example, is added as a column by clicking on "Add column / Data field". With this method, the value cannot be formatted.
To format the value as desired, proceed as follows: Add the primary key (PK)(S)ID of the child data group as described above as a
table column. Select the new table column and click on "Edit column".
Go to the "Displayed values" tab and select the "Values from applications" option. Then, select the primary key (PK)(S)ID as the saved value. Deactivate the "Adjust displayed value to saved value" option and click on "Edit displayed value". In the dialog that opens, select the "Number" field. Confirm all open dialogs with "OK", save the application and test the result in the browser.