Import Multi-line Text into NetSuite

Integrator.io
, ,
1

Hey There,

I'm sure this is stupid simple. I'm trying to import some multiline text into the Message field of the NetSuite Task record. How do I insert a new line in my handle bar expression field mapping??

Looking to achieve

Name: Dave

Rank: General

Serial: 234234

using a handlebar express like...

Name: {{data.name}} // insert proper new line char here

Rank: {{data.rank}} // new line here

Serial: {{data.serial}}

Thanks!!

2

Hi David,

You can use the "join" helper like this -

{{join '\n' (join ": " "Name" data.name) (join ": " "Rank" data.rank) (join ": " "Serial" data.serial)}}

3

Hey @anirudhsundaram651-Anirudh-Sundaram" rel="nofollow noreferrer">Anirudh Sundaram, thanks, but that doesn't work. It reformats data by adding \, so I get \\n instead of new line.

4

Hi David, Eric,

Please try the following:

Name: {{Name}}
Rank: {{Rank}}
Serial: {{Serial}}

Here, we're sending the LF Unicode character to provide the Line Feeds.

This should populate the Message field on the Task record with the line breaks. Since this is a "long text" field, it requires some special handling. Please also note that when you view the record directly, it will appear as if there are only spaces. When editing the record, you should see the breaks.

Additionally, if you're importing into a Rich Text field in NetSuite, you can use
to insert line breaks between text.

5

Thanks for the help Dan!!