'Create Google Doc' automation loosing line breaks from formula fields

[Layla_Barron]

I'm using the 'create google doc' automation to output a grid of records.

One of my record fields is a formula field - which is concatenating 2 long text fields together, and using the '\n' in the formula to give me a line break between the two fields being pulled in.

This works fine in the airtable (it shows the line breaks) - but I loose the line break when the google doc is generated:

Any help very appreciated!! 🙂

Layla

[RonniEloff_VKDe]

Not sure if this will work (going back to my javascript programming days) have you tried 'CR'.

I know that \n is supposed to work but I have seen sometimes that got stripped out of my zapier

[Layla_Barron]

UPDATE: Found explanation and workaround here https://community.airtable.com/t5/automations/document-automator-and-line-break-in-grid/td-p/143856

[Layla_Barron]

Ah thanks so much for the reply - but that doesn't work unfortunately. Have found an explanation though below

[ScottWorld]

@Layla_Barron 

Because of the many limitations with Airtable’s native Google Docs automation, I typically recommend that people use Make’s Google Docs automations.

Since their modules support HTML code, you would just use normal HTML code in your Airtable formulas to represent your line breaks. (You may want to create additional formulas in your Airtable base that are used solely for these automations.)

When using HTML, you can get a line break through one of these methods:

<br><br>

or

<p></p>

There are probably other ways, too.

There can be a bit of a learning curve with Make, which is why I created this basic navigation video for Make, along with providing the link to Make’s free training courses.

p,s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld 

[irtiza]

XSS