Skip to main content

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


Forum|alt.badge.img+6

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

 

 

5 replies

RonniEloff_VKDe
Forum|alt.badge.img+17

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


Forum|alt.badge.img+6
  • Author
  • New Participant
  • 4 replies
  • July 22, 2023

Forum|alt.badge.img+6
  • Author
  • New Participant
  • 4 replies
  • July 22, 2023
RonniEloff_VKDe wrote:

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


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


ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8768 replies
  • July 22, 2023

@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 


Forum|alt.badge.img
  • New Participant
  • 1 reply
  • July 23, 2023

Reply