Transpose datastore columns into rows with linebreaks: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

17 January 2025

  • curprev 11:3111:31, 17 January 2025Smtxwiki talk contribs 577 bytes +577 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..."