Airtable long text into Word Template

How To
,
1

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:
image

How Make picked it up from airtable:
image

How it goes into the Word Module:
image
image

How it looks in Word Template: (Name and Company are different fields)
image

How I would like it to look:
image

Any ideas/help much appreciated.

Many Thanks :slight_smile:

2

You can use this formula

image
image1232×1048 50.9 KB

on each space it will go to a new line. Unfortunately Street Name will also split…

3 Likes
3

Hi @Florian

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.

4

Hi @HC_Automation,

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:

{{street}}
{{city}}
{{country}}
{{zip}}

Then you map those address item.

  1. Split Airtable address

    image
    image847×569 34.4 KB

    image
    image982×696 63.3 KB

  2. Map Word template:

    image
    image882×1082 65.2 KB

1 Like
5

Hi @loic.wiseflow

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

image

then repeat for Address2 and so on :slight_smile:

1 Like
6

Hi, great to hear and nice nesting of functions to save on operations :+1:

1 Like