By using this website, you agree to our Terms of Use (click here)
Is it possible to add a line break to a formula used in an import scenario:
Need to format an address display for the large summary area of the task screen and want the address to look like an actual address
John Smith
1 Fake Street
Fakeville, CA 90210
A non-programmer "wonder if this would work" response:
In Excel you can do an Alt-Enter and get the cell to break
ABC alt-enter
DEF
Wondering if you could enter Jack B Quick alt[enter] One Jack Place alt[Enter]characters "Jackson, MS 13456"
and get
Jack B Quick
One Jack Place
Jackson, MS 13456 in the cell.
Don't have time to test/fuss with this - just a thought. A post I found suggested this :
=A1 & CHAR(10) & A2 & CHAR(10) & A3
The CHAR(10) inserts a line feed character, which is the same as is done by Excel when you press Alt+Enter.
Tried both of those and it did not work, may not be possible in an import scenario
I tried with a formula in Excel and didn't have any luck getting the line-breaks to function as desired either.
Might be a good post for the more technical forums. I'm sure there has to be a way. Maybe even create a case with Acumatica?
What specific screen and field are you trying to import this into?
The tasks screen, I am using the new Business Events feature of 2018 to automate the creation of tasks via an import script.
I tried this:
But I also didn't have any luck. It imported like this:
I'm guessing you already tried <br> ?
Because in reports that's what you have to use for line breaks.
I'm guessing you already tried <br> ?
Because in reports that's what you have to use for line breaks.
We've also seen success using a <br > inside automation steps to prefill tasks with required data on multiple lines.
I think it could potentially have something to do with the specific input field that data is being imported into. I had to add an additional note to the Stock Item's Note field and managed to get the text to be added onto a new line. My mission was to add additional text to any existing text that was already present in the note field but as a new line.
I used the concat & '\r\n' approach.
Import Scenario:
Sample Result:
PS. Tested this on 2019R1 so a fix could have been added as well?