I have an automation that aggregates all the line items for an invoice - see attached image…
That works fine but I would like to have each item be on its own line. So somehow I need to be able to insert a break <br> presumably. Not willing to go to Make or Zapier for this.
How can I do this?
+32Does this look right? If so I’ve set it up here for you to check out!
The idea is to create a formula field that’ll put a new line in front of the value you want to display and to use that value in the automation instead:
' \n' & Name
This results in a leading newline and I’m not sure if you’re okay with that. To get rid of it we’d use a Run Script step to trim it out and you can find it in the base linked above as well:
Setup:
output.set('text', input.config().text.toString().trim())
Let me know if you have any issues setting it up!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.