Including Tables in a Word Merge Document

From SmartWiki
Revision as of 08:13, 26 April 2015 by Chris Kulczyk (talk | contribs) (fixes to links)

Jump to: navigation, search

You can also add data to one or more existing tables in the resultant MS Word document if you have multiple records that you need to include.

  • In the MS Word document you must create a table with the relevant number of columns. The table should only include a single row with the column headings (the heading do not have to match the field names within SmartSimple.)
  • You do not have to create form fields within the table. New rows will be created automatically and populated with data in the order specified in in the MS Word Merge Custom Field Values section.
  • Tables should be included at the very end of the Values section.
  • The table you create in MS Word for the example above would look like this:

WordTable.PNG

Using Object [#...#] syntax

  • Used to pull in list of activities, contacts, users, companies, notes, associations, transactions, level-1, utaproviderL1, utaproviderL2, utaconsumerL1 or utaconsumerL2 into the Word Merge document.
For example: to include all Level 2 Activities related to a Level 1 entity you could use:
table_1=[#(?object=activity)|~description~|~statusname~|~startdate~|~enddate~|$Another Field Name$|#];
  • Be sure there are no spaces between the pipes (|) and variables.
  • In the example below the first table (identified by position and referenced as table_1) is set to the records associated with the entity.

WordMergeTable.PNG

HTML Tables

Instead of creating a table in the MS Word Merge document, you can define HTML on the MS Word Merge field that will be used to create a table in a normal bookmark on the MS Word Merge document.
When defining a HTML table do not use CSS rules as they will not convert. Use the old way HTML 4 table tag syntax formatting.
List of working tags can be find in the link below:

[w3schools: HTML Tag list]
  • Example:
bookmarkname=<html>
<table width="100%" border="1" cellspacing="0" cellpadding="3">
<tr><th>#</th><th>Date</th><th>Details</th></tr>[#(?object=activity)
<tr><td width="10%">~Index~</td><td width="40%"><!--@sscalculation(DATE_FORMAT("~startdate~","%d %M %Y"))-->
</td><td width="10%">$Activity Details$</td></tr>#]
</table>
</html>;

See Also

To set up a Word merge:

Advanced Word Merge Features Include: