Smtxwiki: Created page with "In case you have a multi select form field and you want to show the selected values in a readonly display field and you want to combine multiple columns of the datastore behind the multi-select field, you should use the Transpose function. For example: you have a list with persons and want to show from the selected person their email address and organisation: TRANSPOSE('||', ' - ', '
', '#REPLACE-FORMFIELD-FormName||PersonList||EmailAddress#', '#REPLACE-FORMFIELD..."

2025-01-17T10:31:17Z

Created page with "In case you have a multi select form field and you want to show the selected values in a readonly display field and you want to combine multiple columns of the datastore behind the multi-select field, you should use the Transpose function. For example: you have a list with persons and want to show from the selected person their email address and organisation: TRANSPOSE('||', ' - ', '<br />', '#REPLACE-FORMFIELD-FormName||PersonList||EmailAddress#', '#REPLACE-FORMFIELD..."

New page

In case you have a multi select form field and you want to show the selected values in a readonly display field and you want to combine multiple columns of the datastore behind the multi-select field, you should use the Transpose function. For example: you have a list with persons and want to show from the selected person their email address and organisation:

TRANSPOSE('||', ' - ', '<br />', '#REPLACE-FORMFIELD-FormName||PersonList||EmailAddress#', '#REPLACE-FORMFIELD-FormName||PersonList||Department#')

Do not forget to set the checkbox "Contains calculations" active

Transpose datastore columns into rows with linebreaks - Revision history