I’m working on a Zap that take the output of a long Microsoft Form and sends it to PDF Monkey. A bunch of the questions are long-answer with the potential for line breaks, and I’d like to convert those line breaks (“/n”) to html <br> tags. I know I can us the Formatter, but as far as I can tell, I have to do a formatter for each potential field in the Excel Spreadsheet the form dumps the responses into (the actual zap pulls form the spreadsheet, with the ”new row” trigger)
I’d really love a simple to way to do the same replace function on every column/cell/field in the new row, without having to set up a bunch of separate Formatters for each column/cell/field or having to specify each column/cell/field in a Code zap or similar (I’ve seen some things when searching about converting it to Line Items, but that won't work in my case as it requires comma-separated values and the paragraphs I’m wanting to format would have commas inside them).
Is this doable?