When creating a google doc from template on airtable, how can I format the out put so it will print on multiple lines or maintain any of the formatting it has from airtable as a “long text” field?
Can I preserve formatting and line breaks when creating a Google Doc from an Airtable template?
Hi
It’s been a while since we’ve heard from you here so I just wanted to check in to see how you’re getting on. If you still need any help on this please let us know! 🙂
There are different types of line breaks.
Check to make sure both HubSpot fields are using the same type of line break.
[:newline:] - matches newline (\n) characters
[:return:] - matches carriage-return (\r) characters
The linebreak is present in hubspot. And it seems the text is the same as zapier passes the one field in hubspot to two fields in airtable. However, the formatting in airtable is inconsistent; despite the airtable fields being the same type with the same settings.
If the data is originating in HubSpot, then check the formatting in HubSpot.
I’ve definately checked the formatting in the zap, and its consistent for both - It’s a single field leaving hubspot, no formatting applied in the zap, going to two airtable fields which had the same format.
With this specific case we can see the error - In one instance the line breaks are preserved and present in airtable, and subsequently present in google docs. In the other, it does not.
🤷
If data is being populated from a Zap, then I would check the formatting of that field in the Zap step being used.
Thanks.
The text seems to be formatted differently.
When expanding, I can see the line break in one.
But that is also strange, as both values were populated in the same zap step which copied the information from Hubspot to airtable.
Any reason why would it have formatted one with a linebreak?
Is the data formatted in the Long Text field the same way?
Might help to expanded the width/height of the row to see.
Or you can copy/paste out to another program to see.
Thanks,
they are both “long text” in Airtable.
Check the formatting of the fields in Airtable to make sure they are configured the same.
Here is an image of a google doc, generated from template. Both fields here come from the same airtable field - which is formatted to be long text in airtable. In one instance it prints without linebreak, in the other it prints with linebreak. I want to consistently output with the linebreaks.
The template is a google doc with a table to keep a pretty page; however, each of these cells are the same.
Here is a picture of the template:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.