Airtable long text into Word Template
Hi, Im looking for some help with my Airtable and Microsoft Word Template integration. I have it set up and working fine for simple fields (like Name, Date etc) however I am having trouble with fields that require multiple lines or formating (like Address).
How it is entered in Airtable:
How Make picked it up from airtable:
How it goes into the Word Module:
How it looks in Word Template: (Name and Company are different fields)
How I would like it to look:
Any ideas/help much appreciated.
You can use this formula
on each space it will go to a new line. Unfortunately
will also split…
Thanks for this, makes sense.
Unfortunately, it still doesn’t seem to be working. I’m thinking the issues might be with how the key is entered in the word template, but I am having trouble finding any help documentation on this.
Your best bet I think is to split your address using the split() function. And then in your word template you break down your address placeholder like this:
Then you map those address item.
Split Airtable address
Map Word template:
Thanks, that was really helpful. I have ended up splitting it out in the template as you suggested, but using a combination of ‘Get’ and ‘Split’ functions when mapping so as to not use the extra Operation
then repeat for Address2 and so on
Hi, great to hear and nice nesting of functions to save on operations