New pages
Jump to navigation
Jump to search
- 11:52, 2 April 2025 Calculate the birthdate of a 18 year old person (hist | edit) [285 bytes] Smtxwiki (talk | contribs) (Created page with "Below is an example code to calculate the birthdate of a person that turns 18 today format('{0:yyyyMMdd}', DateAdd(ToDate('#REPLACE-FORMFIELD-FormName||TodayDateField||#'), -18, 'Y'))")
- 12:31, 17 January 2025 Transpose datastore columns into rows with linebreaks (hist | edit) [577 bytes] Smtxwiki (talk | contribs) (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...")