Embed merge field into another
I have an excel data source see the crude example below:
Name | performance dropdown box | Date of appraisal
Joe | { MERGEFIELD "Name" } is a good employee |2017/02/10
What I am trying to do is merge data to a template appraisal form and I want to personalize the performance comments by embedding the first name into the list of value chosen. I can't concatenate since the name may be required in different positions in the text. Can this be done somehow?
Thanks
|