Formula Rich Text field containing fields
I am trying to create a Rich Text Formula field that will display as fields are completed. It's meant to show the user what a notification will look like when sent. However, the field references in my...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendAll you need to do is to end the quotes when you need to insert a field name, and then use the & character for concatenation.
"<p>Attached is " & [Call Forecasting Description] & " " & [Call Forecasting Purpose] & " and will be distributed by " & [Call Forecasting Distribution]
& "</p>\n\n<p>\n</p>\n\n<p>Please share this information with your teams as appropriate. If you have any questions, please contact " & [Assigned To]
& ".</p>\n\n<p>\n</p>\n\n<p><b>When is the communication going out?</b>\n<br>\n *This will be sent to " & [Call Forecasting LOB] & " " & [Call Forecasting Audience]
& ".\n<br>\n *Exceptions - " & [Call Forecasting Exceptions]
& ".</p>\n\n<p>\n</p>\n\n<p><b>When is the communication going out?</b>\n<br>\n *The estimated mail drop is " & ToText([Desired Due Date]) & ".</p>\n\n<p>\n</p>\n\n<p>Thank you</p>"
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
"<p>Attached is " & [Call Forecasting Description] & " " & [Call Forecasting Purpose] & " and will be distributed by " & [Call Forecasting Distribution]
& "</p>\n\n<p>\n</p>\n\n<p>Please share this information with your teams as appropriate. If you have any questions, please contact " & [Assigned To]
& ".</p>\n\n<p>\n</p>\n\n<p><b>When is the communication going out?</b>\n<br>\n *This will be sent to " & [Call Forecasting LOB] & " " & [Call Forecasting Audience]
& ".\n<br>\n *Exceptions - " & [Call Forecasting Exceptions]
& ".</p>\n\n<p>\n</p>\n\n<p><b>When is the communication going out?</b>\n<br>\n *The estimated mail drop is " & ToText([Desired Due Date]) & ".</p>\n\n<p>\n</p>\n\n<p>Thank you</p>"
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------