Skip to main content

I am using ArrayUnique(values) as in a rollup field and then referencing this in a make.com scenario to output to a Word document. This works, but the output is a bit unfriendly.

Products 

Acer_Vero B7_B227Q,Acer_Vero B7_B277,Acer_Vero B7_B247Y  

I have tried changing the formula in the rollup field to something like ARRAYUNIQUE(values)&" - " but it has no effect.

Is there a way to format the output to make it a little more readable - the ideal would be separate lines.

 

EDIT: I have found how to add spaces etc using

ARRAYJOIN(ARRAYUNIQUE(values), ', ')
but is there any chance of adding a newline character (13) ?

Try this:

ARRAYJOIN(ARRAYUNIQUE(values), '\n')

 

Thanks but my output in Airtable doesn't look like that. The items are all on the same row, though I have the formula the same as yours.

ARRAYJOIN(ARRAYUNIQUE(values),'\n')
 
EDIT: but it looks ok in expanded view
EDIT EDIT: but it does look like yours if I set row height above Short. But still doesn't translated to make.com

Thanks but my output in Airtable doesn't look like that. The items are all on the same row, though I have the formula the same as yours.

ARRAYJOIN(ARRAYUNIQUE(values),'\n')
 
EDIT: but it looks ok in expanded view
EDIT EDIT: but it does look like yours if I set row height above Short. But still doesn't translated to make.com

Hmm, so it does show up as new lines on Make, it's just that when you put it into the Word doc it's not showing up as new lines, is that right?

Could you provide some screenshots of the data that's received by the Make module and the output on Word?  May I know what module you're using for the output so that I could try to test it?

Hmm, so it does show up as new lines on Make, it's just that when you put it into the Word doc it's not showing up as new lines, is that right?

Could you provide some screenshots of the data that's received by the Make module and the output on Word?  May I know what module you're using for the output so that I could try to test it?


It looks like it's a make.com problem rather than an Airtable problem - I have now confirmed that the Word Template module in Make does not pass on the newline characters - the input to the module is formatted correctly. I am now experimenting with Google Docs templates instead.

Thanks for all your help on this.

Reply


Terms & Conditions