Hi! I’m trying to design my workflow so it generates new document each time materials are taken out of inventory. For this reason I am using SUBSTITUTE(SELECT(…), “,”, " ") in my virtual colmn where I want to select code, name and amount of items taken out of my inventory so that every material is separated by line break in my detailed view. However, this solution doesn’t seem to apply and function in my google docs template and the items are separated by space without the line breaks. Is it possible to separate the items of list from select statement by line breaks in docs template? Thanks!
I want the generated pdf to look like this:
But in reality it looks like this: