0

When creating a calculated formula, how do I indent to the next line in the formula?

For example, I have a field that contains: "Choose Populated Email" and once I choose a value, I have trigger after update setup, to where that selected response will populate a field I have named "Subject" and another field named "Body" with the email contents I wish to send out. (I know this does not actually send out the email, it is just so we have record of the sent email). 

 

Anyways, my question is, in the trigger after update, I have the body of the emails value start with "Hello,...." within that trigger after update formula, how do I make it indent to another line?

 

I currently have it just tabbed. Here is the exact formula I have: 

if 'Email Populate' = 1 then
Subject := "Your Order Ready" + (Note := "Great news! Your order is ready for pickup. Please arrange to pick up your product in the next 14 days. Please contact us if you need to make arrangements. We look forward to seeing you. Thank you.")

 

I would like for it to have a new line after great news! in the trigger. How do I do this? 

4 replies

null
    • sjdixey
    • 6 yrs ago
    • Reported - view

    Try adding a carriage return as an additional element in "" e.g.:

    "Hello" + " 

    " + "World!"

    • SMoore
    • 6 yrs ago
    • Reported - view

    Great, thank you!

    • SMoore
    • 4 yrs ago
    • Reported - view

    So "Hello" + "

    " + "World"

    Creates

    Hello

    World

     

    But... How do I create

    Hello

    (empty line between)

    World

     

    Hello

     

    World

     

     

    Thanks

    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    Did you try adding a second return between the quotes?

Content aside

  • 4 yrs agoLast active
  • 4Replies
  • 1975Views