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
All 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
------------------------------
Thank you Mark! That was the one option I didn't try. I made one change and that was with the field "Assigned To". The &" "& function doesn't work with a user field so I had to adapt for that by creating a different field and using the new field created. All good though!
------------------------------
Amy Gosz
------------------------------
------------------------------
Amy Gosz
------------------------------
- OK great!
you could have used
UserToName([Assigned To])
to convert the user field to a name.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Good to know. I tried the ToText command but it didn't work. I will make note of your suggestion and change it if the users would like it changed.
Thank you again for the quick response on my question!
------------------------------
Amy Gosz
------------------------------
