I was given a broken link to Apsona's alleged macro tool to add mergefields into word documents. And doesn't look like Apsona have this on their website, nor do I feel the need to reach out to them, because it's easy to create the merge fields in Word manually. There's no need for some macro plugin to do this.
Word > Insert > Quick Parts > Fields... > MergeField under Field Names: > type a name for the field on the right of it, done.
DLRS: Declarative Lookup Rollup Summaries is an app/tool that return summary value of a sub-record/object.
For Time Formats in Apsona generated Documents, it can be done in the Word Document by adding a "@" next to the merge field name and follow the time codes for the format:
yyyy | Four digit year, e.g., 2017 |
|---|---|
M | One- or two-digit month, e.g., 1 for January and 10 for October |
MM | Two-digit month with a leading zero if necessary, e.g., 01 for January and 10 for October |
MMM | Three-letter month name, e.g., Feb for February |
MMMM | Full month name, e.g., October |
d | One- or two-digit date |
dd | Two-digit date with a leading zero if necessary |
EE | Full weekday name, e.g., Monday |
E | Three-letter weekday name, e.g., Mon |
HH | Two-digit hour of day, in 24-hour format |
hh | Two-digit hour of day, in 12-hour format, with leading zero if needed |
h | Hour of day in 12-hour format |
mm | Two-digit minute of hour, with leading zero if needed |
ss | Two-digit seconds, with leading zero if needed |
a | AM/PM indicator |
9/18/2024 Users must also be listed in Apsona Settings > Configuration > add object to Profile (default configuration can't be changed, so clone a new one)... or else this would be a common error message when trying to generate a document/report: "Merge failed: Can't find object ... - perhaps you don't have access to it. Please contact your system administrator"
9/19/2024 Apsona's Conditional IF-Then-Else Directives are fun, allowing me to change Word Template data based on Merge Field values.