Calculated Merge Fields

[Digital Life]

I have a layout upon which the user can choose from a number of different paragraphs. Whateve they pick is then in a field called "verbage".

On the layout of the letter I have a merge field so <> and it shows whatever was chosen or edited into the field verbage off to the right of the page. My question is, is it possible to embed a merge field value in the field verbage and have it be treated correctly as a merge field in the letter.

For example the text in verbage might be: The fee is $<>.

I would want this to show as: The fee is $477.00 but instead it shows as The fee is $<>

Is there a way to 'force' or 'coerce' the merge field verbage to display the value in <>?

[Lee Smith]

What isn't working?

You can do this several ways, but what you have describes should work. Are you sure your Fee is a Number Field?

Maybe a sample of your file would help us figure things out.

Lee

[Digital Life]

Well as I said previously, if I type "Your booking is confirmed into the text field 'verbage' then the merge field on the layout <> shows "Your booking is confirmed". But if I type into the text field verbage "Your booking will cost $<>" the merge field shows "Your booking will cost <>" instead of "your booking will cost 477.00" or whatever value the field cFee has in it. I don't even know that this should work. It was just something I tried and was wondering if others had any experience with this.

I've attached a file that may help show the problem.

TestFile.zip

[comment]

I don't even know that this should work

Neither do I. That is, it shouldn't. Follow the links here to see how it can be done:

http://www.fmforums.com/forum/showtopic.php?tid/173749/post/193092/#193092

[Lee Smith]

I made a sample of three ways to do this, HTH

Digital_Life.fp7.zip

[Digital Life]

Lee thank you very much for taking the time to make me a sample file. But the links provided by comment gave me the solution I needed where I could refer to a field in <> and have it evaluated as part of the text.

See this link in particular:

http://fmforums.com/forum/showtopic.php?tid/120434/

Absolutely brilliant Mike Hackett and Bruce Robertson. I've attached one of their files so you don't have to travel too far to find it and I've modified it a bit to show how I display one field <> and it changes every time either of 3 fields are changed ie) Fee, Hours or Original which holds the original text.

Their original solution is preserved on the left side.

My changes are the fields down the right hand side.

Thanks to all very much.

EmbeddedMergeFieldCalc.zip