field update, getting BR() (blank spaces) at end of text to stay put!

i'm trying to do a somewhat lame workaround for our quote templates where we need page breaks.

To accomplish this, i wanted to let the user tell the system how many blank lines they need to insert into a section on the quote template.

So I have 2 fields: Page_Blank_Size__c (user fills out)

and Page_Blank_Spaces__c.

If the user fills out 10, I want to use CASE function to insert BR() & BR() & BR()... etc...

Problem is, if there is no text surrounding the BR()'s, salesforce trims it.

Any way to get salesforce to leave my blank spaces alone?!

3 answers

Jeremy Bardet
Oct 1, 2013, 9:35 PM
and to be clear, the formula is being applied using a workflow field update.

Add a comment

0/9000

Data Management