Merge Letter Templates
by Matthew LeeringVersion: 1.1
Release Date: November 21, 2015
Author: Matthew Leering
In short, this is a module that will allow developers to define merge letter variables which can be inserted into merge letter templates that users are able to create. It uses a single table that serves double duty as both storage for template data, and also for handling the virtual list of merge letter variables. I’ve tried to make this as easy to integrate as possible, so hopefully your experience with this module is a good one.
Version 1.1 Updates Include:
- Updated Readme (Reference to Configuration script was mis-labeled, another step wasn’t verbose enough in its explanation) –> Thanks Mike!
- Fixed bug with Configuration script –> incorrect layout name was hardcoded
- Updated how variables get dynamically created
- Introduced new way of using get variables that evaluate at runtime –> Use {{GetFunctionName}} syntax similar to merge functions used on layouts
- Allowed for the usage of string literals as substitution text –> Can also have system generate these strings onInitializeModule (not necessarily runtime)
- Updated configuration to show examples of all 3 types of substitution values (fields/strings/GetFunctions)
How To Install
- Copy “ModularMergeLetterVariables” Table to your solution
- Reset auto-enter serial to 1
- Recreate Relationship to the “ModularMergeVariables_Self” table
- Copy Scripts To Your Solution
- Copy All Layout Objects From “ModularMergeLetterVariables” Layout Into the “ModularMergeLetterVariables” Layout That Should Have Been Automatically Created In Your System
- Modify “Configuration” script so that it will point to the correct layout
- Make sure the “Initialize Module” script gets called prior to running the “Return Merged Text” script. (I opted to run the “Initialize Module” onFirstWindowOpen for the purpose of this demo)
- *Optional* You Might Want To Create A Value List Like The One That Exists In This Demo File
How To Implement
- Perform Script “Return Merged Text” passing your templateContent as a parameter.
- Bring the user to a layout that displays the results of the “MERGEDTEXT” field in a letter-style layout
This looks very cool! Thank you!
One clarification, in step 6 you cite an “Editable Configuration” script. There is none. This is however a “Configuration script. I assume this is what you are referring to.
Thank you very much!
Thanks for the feedback, Mike.
You’re right, the script that I reference in step 6 is actually now called “Configuration “. Thank you for pointing this out.
I’ve updated the post, and will update the Readme in the module as soon as I get a chance to.
Great job, Matthew! I just posted this on FileMaker Pro Gurus and I’ve added to the Free FileMaker Example File LIst (http://www.filemakerprogurus.com/filemaker-example-files-list/).
Thanks for sharing this.
Don
Thank you Mathew for the file –
This may be a dumb question but how do you add new fields to the merge list in the template layout.
i added a filed called “Bond”, in the config script, which will merge in the Template if I manually insert it
but how do you get it into the available list of merge fields
Cheers
No prob, Rob.
🙂
In theory, all you really need to do is add a new call to
Perform Script [“Add A Merge Variable”] in the configuration script (which it sounds like you’ve already done).
If that’s been done, and everything was setup properly, then simply close/re-open the system, and you should be set!
Hope this helps!
Thank you Mathew.
You’re very welcome!