CONCATENATE - combining answers through survey flow

What will happen is you eg. concatenate 3 fields but one of them is blank? eg. 3 Answers but the 2nd one is left blank. I suspect you'll get a double comma appearing? ie. Answer1,,Answer3. Is there something that can be done to replace the double comma ,, with just one comma? Might this be some JS code?

Thanks

Rod Pestell

Hi, Rod.
If you don't have a JS solution, a series of branches may be another option.
Using the CombinedText embedded field example from SaurabhPujare_Ugam's suggestion...

In your survey flow, create a branch with multiple IF criteria:
Answer 1 is not blank AND
Answer 2 is not blank AND
Answer 3 is not blank
Then CombinedText = Answer 1, Answer 2, Answer 3

Create another branch with the next combination of IF criteria:
Answer 1 is blank AND
Answer 2 is not blank AND
Answer 3 is not blank
Then CombinedText = Answer 2, Answer 3

Create another branch with the next combination of IF criteria:
Answer 2 is blank AND
Answer 1 is not blank AND
Answer 3 is not blank
Then CombinedText = Answer 1, Answer 3

Create another branch with the next combination of IF criteria:
Answer 3 is blank AND
Answer 1 is not blank AND
Answer 2 is not blank
Then CombinedText = Answer 1, Answer 2

Keep adding branches to address combinations of blanks or missing data.

Thanks brmckim, pretty complex if you have 20 options but it's a solution so thanks for the reply.

Hi there,

Is it possible to add the question text before each open-ended response in a concatenated field that combines a few open-ended responses?

It doesn't seem possible to include the question text in the delimiter field or to add it as part of fields 'a', 'b', or 'c'…

Is there any workaround?

Thanks in advance!