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
-
Try adding a carriage return as an additional element in "" e.g.:
"Hello" + "
" + "World!"
-
Great, thank you!
-
So "Hello" + "
" + "World"
Creates
Hello
World
But... How do I create
Hello
(empty line between)
World
Hello
World
?
Thanks
-
Did you try adding a second return between the quotes?
Content aside
- 4 yrs agoLast active
- 4Replies
- 1975Views