[btgoligowski24]

Is it possible to insert line breaks in a set value action where you are using a formula for the value? We have several fields that need to have answers on a form, but that information needs to get transferred to another database that only has 1 text area field for it. It is easier and more visually appealing for our users to fill out this information via a variety of fields than it is to pre-populate a text field with the options and go from there. I’d like to use a workflow to enter all that information into one text area field, but have it be more reader friendly by creating line breaks.

Ex.

Question 1: Answer

Question 2: Answer

Question 3: Answer

Rather than concatenating everything like this: Question 1: Answer, Question 2: Answer, Question 3: Answer.

Thanks!

PS: I don’t know scripting yet, so I’d have to do this without that for now.
This is a cached copy. Click here to see the original post.

[zackb22]

{field1}|| ‘
’ || {field2}

Or here is a SuiteAnswer that shows another way of doing it for workflows.

https://netsuite.custhelp.com/app/an…20in%20formula

---

btgoligowski24 replied on 10/10/2016, 02:16 PM: Awesome! Thanks! I hadn’t thought of putting the
in the single quotes. I thought about coding it that way, but missed that one. I also found the other ones, but didn’t think to combine CHR(13) and CHR(10) together. This helps a lot, thanks again! Now I just hope I don’t run into a character limit in the formula field.

[Author]

Posts