I'm attempting to create a calculated value on nintex form that concatenates a single value text field with all the values of a multi value choice field. IE: Text field contains "One", multi-value selected is "Two", "Three", "Four". I want my output to be "OneTwo", "OneThree", "OneFour" . Probably will put a separator between them. so actually "One~Two", "One~Three" and "One~Four".
Can you create a calculated field that displays the two fields together.. with the separator using quotations to notate not a calculation.
"Field1" "Field2" or (Field1)"~"(Field2)
I was able to do this in the workflow by using the regular expression tool to split the multiple values of my second values into a collection variable. I then used a for loop to concatenate the first variable with each member of the collection using the build string action.