Linked record from Airtable gives IDs rather than values

[Simon_Gray]

I am filling a Word Template with values from an Airtable linked record.
I’m receiving the record ID rather than its contents in the resulting Word document.

I have managed to get this work for a single ID (converting it to text) but I can’t get it to work when the linked record is an Array.

[dilipborad]

Hello @Simon_Gray,
When you get record data from Airtable which includes linked records, it always returns that linked table field data as record ID. It always starts with the prefix rec***.

Now how to fix that and get all the Text only instead of these RecIDs.
2 ways you can use it.

1. Create a new formula field on the same table, and use that same linked field. In your case use {Product} as a formula value.
   OR
2. Use the Lookup field to select the Text field from that other table. (I recommend this.)

Now refresh your Airtable module select that field and then use it on the next module.

[Simon_Gray]

I am close to making this work, but I suspect that the last step is not possible.

I am trying to get each Product on to an individual line and I now achieve this in Make, but when the field is updated in Word, all of the products are placed on the same line again.

I have tried Get( and Split( commands and this does what I want in Make but doesn’t get transferred to the template.

Is this a limitation of the Word Template module?