Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 21, 2023 09:08 AM - edited Jul 21, 2023 09:09 AM
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
Jul 21, 2023 11:59 AM - edited Jul 21, 2023 12:00 PM
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
Jul 22, 2023 04:18 AM
UPDATE: Found explanation and workaround here https://community.airtable.com/t5/automations/document-automator-and-line-break-in-grid/td-p/143856
Jul 22, 2023 04:18 AM
Ah thanks so much for the reply - but that doesn't work unfortunately. Have found an explanation though below
Jul 22, 2023 05:06 AM - edited Jul 22, 2023 05:07 AM
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
Jul 23, 2023 11:06 AM - edited Jul 23, 2023 11:15 AM