Embed value in Rich Text field?
Can you embed a field's value in a Rich Text field?
Forum Discussion
I suppose that you could have a set of std words and then allow the user to have override words and have a formula resolve which one to use.
So there would be an override field and then a field to contain the calculated words for the first phase up to the [Billing Month].
if(trim([override words] <>"", [override words], "blah blah blah std words")
Then they may need to be able to override the phase after the [Billing month].
But if you are going to so that, I would take the [Billing Month] out of the middle of the phrasing and below the text I would say
[Std Words or override words]
Billing Month: [Billing Month]
So then the user can free form their override words and not have to contrive the words to fit with the [Billing Month] being in the middle of their paragraph.
So there would be an override field and then a field to contain the calculated words for the first phase up to the [Billing Month].
if(trim([override words] <>"", [override words], "blah blah blah std words")
Then they may need to be able to override the phase after the [Billing month].
But if you are going to so that, I would take the [Billing Month] out of the middle of the phrasing and below the text I would say
[Std Words or override words]
Billing Month: [Billing Month]
So then the user can free form their override words and not have to contrive the words to fit with the [Billing Month] being in the middle of their paragraph.