Concatenate text from same column in query into single form field

nrichard1

I am trying to create a workflow that will concatenate comment entries which are currently displayed in a query section on the form I am working on. I need to populate a form field with all of the comments associated to the record. I have played with iter tasks and in-memory only helper tasks but I am having a hard time figuring out how to store the first comment then tell the workflow to store the second comment or concatenate it to the first...without overwriting the first comment.

Admin

Hi @sruch , can you take a look at @nrichard1 's question?

sruch

I had a look at this problem, and looked at a couple of potential solutions to working this out. I have seen and used the strcat function to do things like this. But I have not tried this for more than two pieces of text. Would it be too m uch trouble to open a ticket for this? I would like to get a solution for you, as well as get it into the Support knowledge base for future reference. I will keep an eye out for that and make sure you get an answer.

nrichard1

sruch Thanks for looking into this for me. I will open a ticket.

nrichard1

I worked out a solution! I used the triNotificationHelper and iterated through the comments, mapping triCommentTX to different text input fields on the helper, while using switches within the iter task so as not to overwrite the mapping on subsequent iterations. Lastly, mapping the concatenation of text input fields to my allcomments field.

sruch

nrichard1 Excellent news! Thank you for the update.

nrichard1

sruch is there a way to insert a line break within a workflow modify task? I would like to be able to visually separate the concatenated comments by putting each one on a new line in the text field but I'm not sure if it's even possible.

sruch

nrichard1 I did some looking and I think this might work: The HTML <br> tag denotes a line break, like a carraige return. Can you concatenate using that tag?

nrichard1

sruch just tested using <br> but it just inserts as text rather than a line break. Also tried \n but that didn't work either

sruch

nrichard1 If it is not too much trouble, could you drop a ticket for this? I can point this at Development and get you an answer. Thank you very much.

nrichard1

sruch thanks, opened case TS011771804