My Current Workflow Record type = Issue, Parameter Field>Notes is currently defined as ' NAME: '||({custrecord_360_taxrate_taxid})||' TAX ID: '||({custrecord163})||' EFFECTIVE DATE: '||({custrecord_360_taxrate_effdt})||' Res Rate: '||({custrecord_360_taxrate_rate})||' Non-Res Rate: '||({custrecord_360_taxrate_nonres})||' NOTES: '||({custrecord_360_taxrate_notes_ext})
The result is:
NAME: Columbiana City Tax TAX ID: 39-000-1060989-CITY-000 EFFECTIVE DATE: 22-JAN-14 Res Rate: 1 Non-Res Rate: 1 NOTES: The tax rate is 1%, the credit factor (credit limit) is 100%, and the credit rate (credit limit) is 0.50% per RITA's website below as of April 2020:
https://www.ritaohio.com/Municipalities/Home/MemberPage?id=211
I would like my result to look like this:
NAME: Columbiana City Tax
TAX ID: 39-000-1060989-CITY-000
EFFECTIVE DATE: 1/1/2014
Res Rate: 1
Non-Res Rate: 1
NOTES: What's changed: The credit and the credit limit in the STE database need to be fixed. The credit is currently 50% and should be 100% and the credit limit is currently 50% and it should be 0.50%. Resource: https://www.ritaohio.com/Municipalities/Home/MemberPage?id=211
I have tried variations of {"\r"} in different places but ERROR: Invalid Expression is returned.
Can someone suggest how I can inset carriage returns into my Formula?
Thanks