Changes

*To generate a list of all contacts for a [[Web Page View]] or [[Custom Field Type: Read Only – System Variables|Read Only – System Variables]] custom field (note that the HTML table formatting is included within the '''[#...#]''' syntax)

<table><tr><td>First Name</td><td>Last Name</td><td>E-mail Address</td><td>Cell Phone Number</td></tr>

[#(?object=contact;)<tr><td>~firstname~</td><td>~lastname~</td><td>~email~</td><td>$Cell Phone$</td></tr>#]

* For a list of Level 2 (or Level 3) activities sorted by Start Date in descending order:

<table>[#(?object=activity;orderby=startdate desc)<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table>

</pre>

* For a list of contacts assigned to a Level 1 with the role of "Internal People", sorted by surname:

<table>[#(?object=contact;orderby=lastname;criteria=rolename='Internal People')<tr><td>~firstname~</td><td>~lastname~</td><td>~email~</td></tr>#]</table>

</pre>

* With Multiple Criteria:

[#(?object=contact;criteria=(rolename='External' or rolename='Internal'))<tr><td>~firstname~ ~lastname~</td></tr>#]

</pre>

* To sort descending by a custom field called ''Total Hours'' with a custom field id of ''67292'':

[#(?object=activity;orderby=tbl_67292.valuestr desc)<tr><td>Subject: ~subject~</td><td>Total Hours: $Total Hours$</td><td>Start Date: ~startdate~</td></tr>#]

</pre>

* To list a specific activity type only:

[#(?object=activity;orderby=startdate;criteria=typename='This Activity Type')<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]

</pre>

* To list activities based on the [[Determining the typeid|type ID]] ('''Level 2 and Level 3 only'''):

<table>[#(?object=activity;orderby=startdate;criteria=typeid='24160')<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table>

</pre>

*To include a hyperlink to the object (for Accounts):

<table>

[#(?object=company;criteria=rolename="Cooperating Organization")<tr><td><a target='app_win' href=/s_viewcompany.jsp?companyid=~companyid~>~name~</a></td><td>~role~</td></tr>#]

* To list activities based on status:

<table>[#(?object=activity;orderby=startdate;criteria=statusname='Open')<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table>

</pre>

* To list activities based on the status ID ('''Level 2 and Level 3 only'''):

<table>[#(?object=activity;orderby=startdate;criteria=status.statusid='24160')<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table>

</pre>

* To list UTA Providers:

* To list notes (from the record that contains the notes):

[@(?object=notes;orderby=createddate desc)<tr><td>~notes~</td><td>~createddate~</td><td>~username~</td></tr>@]

</pre>

'''To list level 2 notes for each level 2 record at level 1:

[#(?object=activity;orderby=startdate desc)

<tr><td>~subject~</td><td>~description~</td><td>~startdate~</td>