formatting Custom Field formatting

[Jeremy]

I am trying to build a email from the questions answered in a PCF I have got all the questions to appear in the custom field, however the questions are appearing in a paragraph. How can I split these out so that each response is on an individual line? e.g.

Current
skjgsdlfgldfsgjds sdfgsfs dfgsdf gds fgdsfg? sadfdsf sd fsdfs dsdf sdfs dfs? sdfsf sfs dfsa fsdfsfsdfs

Ideal
sadfsdf sad f dsaf asasf?
sdf saf rghgh ertwwfs wgds dfgdgds?
ets sdfs asfsdfs?

Can this be achieved via wiki formatting? If so what is the correct syntax?

[Steve Giller]

Which field are you injecting the values into? I believe it would need to be one of the TEXT fields to allow for cr/lf characters.

 

[Jeremy]

custom 31 as I need to build up potentially a large text response. @Steve Giller

[Steve Giller]

I'm advised a VARCHAR should also work, so it's not that.
I just added my Questions into CustomP as part of the BPM like so:

and when I output that to the timeline I got this with no extra formatting required.

I don't have email set up on my test, but if you can see the above in timeline but not the email I'd suggest using HTML breaks (<br />) or paragraphs (<p>...<\p>) to separate out the lines.

 

[Jeremy]

I am updating custom field like this... as it only needs to update if people answer a certain way.

This is our custom fields:

@Steve Giller Should the update be like this? <p>this is my question<\p> in each update box?

[Steve Giller]

That's the suggestion - I can't test this on my system as I don't have email set up, I'm afraid, but unless someone jumps in with a correction give that a try.

[Jeremy]

@Steve Giller I'm afraid this has not worked

[Steve Giller]

@Jeremy Is that from the email or the timeline? It's not possible to tell from the above post.

[Jeremy]

@Steve Giller this is the email, it also appears like this in the custom field

[Steve Giller]

OK, back the the drawing board.
Leading and trailing white-space, including line breaks, are removed when using the append function. At the moment the only way I can see to keep the line breaks is to use a '.' on its own line with the variable you're inserting in the line underneath.
This will add a full stop to the end of each sentence, but shouldn't be too obtrusive.

[Jeremy]

As this email is quite visible to managers etc in our institution I would like it look as polished as possible.

Not sure if anyone else has any ideas?

[Steve Giller]

The only workaround I have presently is to put each of those decision-based values into their own Custom Field, then use the individual fields in the email template with ESP conditions so that blanks are not shown.

[Jeremy]

@Steve Giller I can't export to custom fields as there are more questions than custom fields, which is why I am adding them to one unlimited custom field with formatting.

[Steve Giller]

@Jeremy Looking at the example above, as each element ends with a "?" you could try replacing "." with "?" as per my suggestion above, and that should look as expected.

Apart from that I could only suggest streamlining the questionnaire - if there are more than 40 questions in the ProCap I (as a customer) probably wouldn't bother answering.