Latest revision as of 10:20, 14 August 2024

The Web Page View Field provides the ability to display a fully formatted document or web page.

In constructing this type of page HTML is used in conjunction with the following variables.

1 Variable List
2 Field List
3 UTA Contact and Account Variables
4 To Display a List of Activities, Notes, Transactions, Contacts, Companies, Consumers, Providers
5 XML Variables
- 5.1 Count how many options were selected
- 5.2 Filtered XML display output
6 Date/Time Variables
7 Miscellaneous Variables
8 Controls
9 Troubleshooting
10 See Also

Variable List

Current User

Note: "me" -- refers to the current user

@me.firstname@ will be replaced by current user's firstname

@me.lastname@

@me.email@

@me.phone@

@me.companyname@

@me.type@ (returns 'User', 'Local User Administrator' or 'Global User Administrator')

UTA Level 1, Sales Opportunity and Job Variables

@name@ - standard field Application Name.

@type@ - standard field Application Template Type.

@status@ - standard field Status

@typecaption@ - standard field Application Template Type Caption.

@statuscaption@ - standard field Status Caption

@type_lang@ - standard field Application Template Type (Based on user language setting).

@status_lang@ - standard field Status (Based on user language setting)

@description@

@requirements@

@currency@

@revenue@

@probability@

@modifiedby@ / @modifiedbyid@

@modifieddate@

@closedate@

@startdate@

@enddate@

@createddate@

@createdby@

@createdbyid@

@jobquestions@ - displays as combo boxes

@jobquestionsr@ - displays question only

@jobskills@

@owner.field@

Example: @owner.fullname@ or @owner.address@

@person.field@

Example: @person.fullname@ or @person.address@

@company.field@

Example: @company.name@ or @company.address@

@company.owner.field@

Example @company.owner.email@

@branch.field@

Example: @branch.name@ or @branch.address@

@apptype@ the Application ID (appid) of the UTA.

UTA Level 2 / Activities Variables

@subject@

@description@

@location@

@startdate@

@enddate@

@isallday@

@modifieddate@ (numeric value including time)

@longmodifieddate@ (text value excluding time)

@starthour@ - (0-23)

@starth@ - (0-12)

@startpmam@ - (PM or AM)

@startminute@

@endhour@ - (0-23)

@endh@ - (0-12)

@endpmam@ - (PM or AM)

@endminute@

@owner@

@eownerid@ - userid of the owner

@contact@

@assigned@

@eventid@

@typename@

@objectid@

@objecttype@

@rootcompanyid@

@rootcompany.name@

@contact.field@ @eamount@

Example: @contact.firstname@ or @contact.email@

@assigned.field@

Example: @assigned.firstname@ or @assigned.email@

@contact.company.field@ (same as assigned)

Example: @contact.company.address@ or @contact.company.city@

Custom Field Variables

@customfield name@ - by name

or

@#customfield id#@ - by id

Example: @more information@ or @#17342#@

See Also: Invoice Module Variables for Variables specific to the Invoicing module.

UTA Level 1 variables called from UTA Level 2

If your Web Page View is at Level 2, you can call Level 1 variables using:

@parent.fieldname@ or @parent.#fieldid#@ (Note: All field names should be entirely lower case.)

Example: @parent.status@ or @parent.startdate@ or @parent.#12345#@

UTA Level 2 variables called from UTA Level 3

When working at Level 3, you can call Level 2 variables using:

@parent.fieldname@ or @parent.#fieldid#@ (Note: All field names should be entirely lower case.)

UTA Level 1 variables called from UTA Level 3

If your Web Page View is at Level 3, you can call Level 1 variables using:

@parent.parent.fieldname@ or @parent.parent.#fieldid#@ (Note: All field names should be entirely lower case.)

Level 3 Associated Parent (Opportunity)

Where Payment Allocation is enabled you have two models to choose from before configuring: usually the Associated Parent is a Funding Stream of Overall Budget (event) and the associated object is the Disbursement (Level 3). In less granular cases the Associated Parent is the opportunity.

Level 3 Associated Parent

If Payment Allocation is enabled, you can pull fields from the Associated Parent using the following variable:

@linkparent.fieldname@

If your associated payment is linked to the event you can pull fields from the opporunity using the following variable:

@linkparent.parent.fieldname@ So @linkparent.parent.branch@ will return: SmartSimple Inc.

On the company/branch:

@linkparent.parent.branch.Transit@ will return: 1950

Field List

People Fields

firstname, lastname, fullname, title, email, phone, company, address, address2, city, province, state, country, postalcode, owner, modifieddate, cost, costunit, type, resourcename, isrecource, uprefix (prefix), usuffix (suffix), uphoneext (Phone Extension)

Company Fields

name, address, address2, city, province, state, country, postalcode, phone, fax, website

Lead Fields

status, description, name, phone, fax, address, address2, city, state, province, country, postalcode, website, firstname, lastname, contactphone, title, email, dat_added

UTA Contact and Account Variables

Owner:

@owner.fieldname@

Person (Level 1 only):

@person.fieldname@

Assigned (Level 2 only):

@assigned.fieldname@

Company (Level 1 only):

@client.fieldname@

Use @client.categoryids@ to return a list of category IDs - comma delimited - note the leading comma - e.g. ",1234,555,666,"

Use @client.categories@ to return a list of category names - comma delimited e.g. "Agency,Marketing,Good client"

Level 1 Contacts/Accounts

Individual

To display information for a single contact/account in the Level 1 contacts/accounts section:

@contact.rolename.fieldname@ or @company.rolename.fieldname@

where:

rolename = the name of the role that has been assigned to the contact/account on the Level One item
fieldname = the name of the field that is located on the contact's record.

Example:

@contact.adjuster.firstname@ or @company.funding agency.address@

Note: if there is more than one contact/account assigned with the rolename specified, only one will be displayed.

List

To display a list of multiple contacts/accounts in the Level 1 contacts/accounts section:

[#(?object=contact) ~fieldname~ #] or [#(?object=company) ~fieldname~ #]

See below for details on how to filter and sort the list(s).

Note: to display the role that the contact or account is assigned on the Level 1 record use: ~role~
Note: to display the name of the contact's company use: ~companyname~

Level 2 Contacts/Accounts

Individual

To display information for a single contact in the Level 2 contacts section:

@contacts.rolename.fieldname@

where:

rolename = the name of the role that has been assigned to the contact on the Level Two item
fieldname = the name of the field that is located on the contact's record.

Example:

@contacts.adjuster.firstname@

Note: if there is more than one contact assigned with the rolename specified, only one will be displayed.

Contacts

To display a list of the contacts assigned at Level 2:

[#(?object=contact) ~firstname~ ~lastname~ ~email~ #]

To display only contacts assigned at Level 2 with a specific role/roles (only relevant if the Level 2 Multiple Contact List is enabled)

[#(?object=contact::criteria=roleid=12345) ~firstname~ ~lastname~ ~email~ #]

To get the intersection record identifier (equivalent to ~oprid~ at Level 1) (i.e. for use in Pandora functions)

[#(?object=contact) ~lnkid~ #]

To display the contact's profile status:

[#(?object=contact) ~firstname~ ~lastname~ ~ustatusid~ #]

Notes:

Contacts at level 2 cannot be filtered by rolename, only roleid
If the multiple contact list is enabled use ~role~ to display the assigned role.

Accounts

To display information for a single account in the Level 2 accounts section:

@companies.rolename.fieldname@

To display a list of the companies assigned at Level 2:

[#(?object=company::orderby=name)~name~ #]

To get the intersection record identifier (i.e. for use in Pandora functions)

[#(?object=company) ~clnkid~ #]

Notes:

The Account standard field is only available at Level 2 when the Multiple Account list is enabled. See here for details.

To display Level 1 Company Role or Contact Role custom fields

[#(?object=company;)$?opc_customfieldid$#] or [#(?object=contact;)$?opr_customfieldid$#]

where:

customfieldid = the numeric id of the custom field

Note: for level 2 records (when the multiple contact/company list(s) are enabled) use $?opr2_customfieldid$ and $?opc2_customfieldid$

Following the same format above, you can also reference custom fields on the company role using the @#field id#@ syntax.

Contact Detail

~uprefix~ ~firstname~ ~lastname~

~uaddress~ ~uaddress2~

~ucity~, ~ustate~ ~upostalcode~

To display Company Association or Contact Association fields

The syntax for extracting information on the entity to which they are associated is as follows . . .

[#(?object=association)~name~ ~standard field name~ $?afc_custom field id$ $?afc_custom field name$#]

[#(?object=companyassociation)~standard field name~ $custom field id$ $custom field name$#]

where:

standard field name = name of the standard field
custom field id = the numeric id of the custom field
custom field name = the name of the custom field

The syntax for extracting information on fields that are on the intersection, rather than the entity to which they are associated, is as follows . . .

[#(?object=association) ~afcompanyid~ #]

[#(?object=companyassociation)~afroleid~ #]

Other intersection specific variables options include:

~afcid~: association (intersection) record id.
~afcompanyid~: companyid of associated company
~afcontactid~: userid of associated contact
~afroleid~: roleid of association
~afstartdate~: start date of association
~afenddate~: end date of association

Role Based Custom Fields

When you have a Custom Field such as a Web Page View or MS Word Merge that is located on a User Role or Company Role you can access:

UTA Level 1 Information:

@levelone.fieldname@ or @levelone.customfieldid@

Contact Information:

@contact.fieldname@ or @contact.customfieldid@

Company Information:

@company.fieldname@ or @company.customfieldid@

When you want to refer to a User Role based Custom Field from a UTA Level 1 record use the following syntax: Owner:

@owner.fieldname@

Person:

@person.fieldname@

Contact:

@contact.rolename.fieldname@

where rolename is the role they are assigned on the Level 1 record

To Display a List of Activities, Notes, Transactions, Contacts, Companies, Consumers, Providers

Syntax

[#(?object=objectname::{options})~standardfieldname~ $customfieldname$#]

Where:

objectname is the name of the item to be listed.

Either: address, activity, assign, contact, user, group, company, notes, association, companyassociation, transaction, timesheet, level-1, utaproviderL1, utaproviderL2, utaconsumerL1, utaconsumerL2 or linkactivity

standardfieldname is the name of a standard field (between tildes, ~)
customfieldname is the name of a custom field (between dollar signs, $)

Notes:

You can refer to Custom Fields in the list using the Custom Field ID instead of the field name, still between dollar signs ($12345$)
level-1 can only be used as an object when referenced from a contact record. Also level-1 will only list the level 1s that the contact has been added to in the contacts section.
You can include text as well as variables within the [#...#] syntax.
When using this syntax for Web Page Views, Read Only – System Variables etc. you will usually want to include HTML table formatting within the [#...#] syntax (see examples below). For MS Word Merge custom fields the table defined on the MS Word Template document, with the columns delimited by pipes (|) within the [#...#].
~Index~ can be used to number the lines (1, 2, 3...) Note: ~index~ does not work for all lists. For example, it cannot be used when listing contacts associated with a Level 1.
- ~Index~ (upper case 'I') starts numbering at 1, ~index~ (lower case 'i') starts numbering at 0.

~eventid~ will display the id of the level 2.

Options:

Option	Effect
orderby=standardfieldname	Sorts the list in ascending order by the standard field specified
orderby=standardfieldname desc	Sorts the list in descending order by the standard field specified
orderby=tbl_customfieldid.valuestr	Sorts the list in ascending order by the custom field specified
criteria=standardfieldname=value	Filters the list by the standard field and value specified
criteria=tbl_customfieldid.valuestr=value	Filter the list by the custom field and value specified
criteria=(standardfieldname=value or standardfieldname=value)	For multiple criteria when either conditional criteria can apply
criteria=(standardfieldname=value AND standardfieldname=value)	For multiple criteria when both conditional criteria must apply
groupfunction=aggregatefunction	Performs specified aggregate function on the listed fields Ex. sum, count, countdistinct

multiple options (i.e. a criteria and an orderby option) can be included, separated by doubled colons (::)

Important: Any custom fields that you use as criteria or orderby must appear in the display. If you do not wish to display the field you can place it in a comment. (i.e.: ) However, if referencing a field as a property of a table you must show the value.

Examples:

To generate a list of Level 2 activities for a MS Word Merge:

[#(?object=activity)|~statusname~|~typename~|$speciality$|$123456$|#]

See MS Word Merge for further details on including tables on MS Word Merge documents

To reference the Consumer UTA Level 1 owner name and ownerid from a Provider UTA Level 1 Read Only - System Variable custom field

[#(?object=utaconsumer::criteria=statusname IN ('Placed','Resigned/Terminated'))~ownername~,~ownerid~ #]

To Display custom fields via List Syntax for Invoicing (objectname=appliedtoinvoices). Grabbing a custom field value off the invoice (ie. 282588) and into an adjustment.

Example: [#(?object=appliedtoinvoices)$282588$#]

Note: refer to the custom field by the number ONLY, do not use the custom field name.

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

[#(?object=contact) #]

First Name	Last Name	E-mail Address	Cell Phone Number
~firstname~	~lastname~	~email~	$Cell Phone$

Note: The first line creates a header row for the table.

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

[#(?object=activity::orderby=startdate desc)#]

~subject~

~location~

~startdate~

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

[#(?object=contact::orderby=lastname::criteria=rolename='Internal People')#]

~firstname~

~lastname~

~email~

For a list of level 1 records, including owner details, that a Company has been asssigned to:

[#(?(object =level-1) NAME: ~name~ OWNERID: ~ownerid~ OWNERNAME: ~ownername~ #]

To display the level 1 ID of the level 1 records:

[#(?(object =level-1) OPPORTUNITY ID: ~op.opportunityid as oppid~ #]

For a list of all companies that the owner of a UTA record is associated with:

@owner.[#(?object=association)~name~ (Phone ~phone~)#]@

To get a comma-separated list of the companyids of all the companies the current user is associated with with roleid 54545:

@me.[#(?object=association::criteria=roleid=54545)~afcompanyid~,#]@

For a list of all contacts associated to the current user's parent company record (associated to the company with roleid 12345):

@me.parent.[#(?object=association::criteria=roleid='12345')~firstname~ ~lastname~ (Phone ~phone~)#]@

For a list of a company's Active(current date is between start and end date) associations:

[#(?object=association::criteria=(afstartdate is null OR afstartdate<='@date(currentdate)@') AND (afenddate is null OR afenddate>='@date(currentdate)@'))~userid~,#]

For a list of all contacts/users located under a company with a given role

[#(?object=user::criteria=rolelist like '%,12345,%') ~email~ #]

To count the number of contacts assigned with the role of Reviewer:

[#(?object=contact::criteria=rolename="Reviewer"::groupfunction=count)~userid~#]

To include and format a date stored in a custom field (see also sscalculation)

[#(?object=activity)<!--@sscalculation(date_format("$fieldname$","%M %d, %Y"))-->#]

With multiple criteria:

[#(?object=contact::criteria=(rolename='External' or rolename='Internal'))~firstname~ ~lastname~#]

With multiple order criteria:

[#(?object=activity::orderby=tbl_1765133.valuestr::tbl_1765119.valuestr desc)~type~, $1765133$, $1765119$<br />#]

Note: multiple options (i.e. a criteria and an orderby option) can be included, separated by doubled colons (::)

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

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

Note: $Total Hours$ in the list could be listed as $67292$ with the same result.

To sort descending reviews in a specific status by a custom field on a separate UTA Level 1 field called $Staff Final Score$ with a custom field id of 1584168 in numeric order:

[#(?object=utaconsumerL1::orderby=tbl_15868.valuestr*1::criteria=(statusname='Member Review'))

Note: $Staff Final Score$ in the list could be listed as $15868$ with the same result.

To list a specific activity type only:

[#(?object=activity::orderby=startdate::criteria=typename='This Activity Type')~subject~~location~~startdate~#]

To list activities based on the type ID (Level 2 and Level 3 only):

[#(?object=activity::orderby=startdate::criteria=typeid='24160')#]

~subject~

~location~

~startdate~

To include a hyperlink to the object:

To list activities based on status Draft and sort by startdate:

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

To list UTA Providers:

[#(?object=utaproviderL1::criteria=rolename="Panel") ~name~ ~typename~ ~statusname~ ~enddate~ $Panel Review Date$ $Panel ID
<!-- @sscalculation(@xml.XML Field.People.Person[#(?criteria="~type.nodevalue~" == "A") 1+#]@ 0) -->

#]

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

[#(?object=notes::orderby=createddate desc)~notes~~createddate~~username~#]

Note: This syntax is for "Public (Default)" notes only, not custom note types.

To list all companies under a parent company record:

[#(?object=company) ~name~ #]

To list all L3 allocations within a L2 budget record:

[#(?object=linkactivity) ~subject~ #]

To sum or count all the L3 allocations from the budget L2 record:

@linkactivity.sum(...)@ or @linkactivity.count(...)@

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

[#(?object=activity::orderby=startdate desc)~subject~~description~~startdate~

[@(?object=notes::orderby=createddate desc)@]

~notes~

~createddate~

~username~

]

Note: This syntax is for "Public (Default)" notes only, not custom note types.

To do a sum of all the unpaid payment transaction:

Total Paid: [#(?object=transaction::criteria=trstranstype=11 and tbl_1145339.valuestr='Paid'::groupfunction=sum)$1145183$ #] Note: $1145339$ - Status of payment $1145183$ - Payment Amount

Referencing Standard Fields of UTA Providers

Level 1 Field Name and Variable List
Field Name	Variable
Application Name	~name~
Type Name	~typename~
Type ID	~type~
Status Name	~statusname~
Status ID	~statusid~
Start Date	~startdate~
End Date	~enddate~
Close Date	~closedate~
Branch	No variables
Branch ID	~branchid~
Currency	No variables
Exchange Currency	No variables
Currency Exchange Rate	No variables
Customer	~client~
Customer ID	~companyid~
Modified By	No variables
Modified Date	No variables
Owner (full name)	~ownername~
Owner (userid)	~updatedby~
Person (full name)	No variables
Person (userid)	~oppeopleid~
Role Name	~rolename~
Role ID	~conroleid~

Example:

[#(?object=utaproviderL1) ~typename~ | ~statusname~ <br />#]

Level 2 Field Names and Variables List
Field Name	Variable
Activity Type	~typename~
Activity Type ID	~typeid~
Owner	~ownername~
Owner ID	~eownerid~
Assigned People	No variables
Status	~statusname~
Status ID	~statusid~
Subject	~subject~
Description	~description~
Location	~location~
Amount	~eamount~
Start Date	~startdate~
End Date	~enddate~
Opportunity ID	~cevconoppid~
Event ID	~cevprovevtid~
Rolename	~rolename~
Role ID	~cevroleid~

Example:

[#(?object=utaproviderL2) ~typename~ | ~statusname~ <br />#]

If you have multiple different UTAs connected as providers, you can use criteria to filter:

[#(?object=utaproviderL1::criteria=provappid="12345") ~typename~ | ~statusname~ <br />#]

To Format the Start Date or Start Time

~date_format(startdate,'%Y-%m-%d') as startdate~

or

~date_format(startdate,'%h:%i %p') as starttime~

Note:

If you wish to use "orderby=startdate", along with a date format other than yyyy-mm-dd you must use a slightly different syntax.
Using "~date_format(startdate,'%d-%m-%Y') as startdate~" when using "orderby=startdate" will cause the date to be ordered by dd-mm-yyyy (rather than yyyy-mm-dd, which is chronological)
To avoid this, change "date_format(startdate,'%d-%m-%Y') as startdate" to "date_format(startdate,'%d-%m-%Y') as sdate"

Displaying Both Level 2 and Level 3 Activities at Level 1

When displaying a list of Level 2 activities using the [#(?object=activity;)...#] syntax, the corresponding Level 3 activities can be displayed under each of the parent Level 2 activities.

To facilitate this you must create a Read Only - System Variable field at Level 2 that contains the list of Level 3 activities, formatted and filtered as desired.

You can use Visibility Conditions, Role Field Permissions or Status Field Permissions to prevent the field from being displayed on the Level 2 record.

Example:

Create a Level 2 Read Only - System Variable Custom Field called Level 3 Activity List with the following:

[@(?object=activity::orderby=typename)@]

Level 3 Activity: ~typename~

~location~

Then create either a Web Page View or Read Only - System Variable at Level 1:

[#(?object=activity::orderby=startdate) #]

Level 2 Activity: ~subject~	~statusname~	~startdate~	~enddate~
	$Level 3 Activity List$

where "Level 3 Activity List" is the name you gave the Read Only – System Variable field

Level 3s with Less Than 25 Fields

If Level 3 has less than 25 fields it is not necessary to create a Read Only – System Variable Custom Field on the Level 2 that lists the Level 3 activities.

Instead you can use the following syntax within the [#...#] that lists the Level 2 activities:

[@(?object=activity)~standardfieldname~ $customfieldname$@]

Note:

This syntax will only work if there are less than 25 fields at Level 3.

Example:

To display a list of Level 2 activities, including any Level 3 activities under their parent Level 2 activity:

[#(?object=activity::orderby=startdate) #]

Level 2 Activity: ~subject~

~statusname~

~startdate~

~enddate~

[@(?object=activity;orderby=typename)@]

Level 3 Activity: ~typename~

~location~

Displaying a Specific Number of Items in a List

When you want to display only specific number of activities or transactions in a Web Page View use the following syntax.

 [#(?object=object::orderby=field) 
    <!--@sslogic(~index~='num')--> 
       ~standard field~ $custom field$ <br /> 
    <!--@end--> 
  #] <br />

where:

num = number of activities that should be displayed

XML Variables

Count how many options were selected

<!--@sscalculation(@xml.XML Field.People.Person[#(?criteria="~type.nodevalue~" == "A") 1+#]@ 0)-->

Filtered XML display output

@xml.XML Field.People.Person[#(?criteria="~type.nodevalue~" == "A")~FirstName.nodevalue~ ~LastName.nodevalue~<br />#]@

Date/Time Variables

Standard Fields Date/Time

Variable List:

'Start Date'End Date'Close Date
Level 1 onlyModified Date'Display Format@startdate@@enddate@@closedate@@modifieddate@Date formatted according to user preferences (At Level 1 Modified Date also includes the time: 15:40)@longstartdate@@longenddate@@longclosedate@@longmodifieddate@Friday, January 23, 2009@fullstartdate@@fullenddate@@fullclosedate@@fullmodifieddate@2009-01-23 15:40:00@datetime(fullstartdate)@@datetime(fullenddate)@@datetime(fullclosedate)@@datetime(fullmodifieddate)@2009-01-23 15:40:00@date(fullstartdate)@@date(fullenddate)@@date(fullclosedate)@@date(fullmodifieddate)@2009-01-23

Note: Start Time and End Time are stored within the fullstartdate and fullenddate fields respectively. They can be accessed and formatted using the variables elements listed below.

To display specific elements of the Start Date, Start Time, End Date, End Time, Close Date, Modified Date:

@month(fullstartdate)@month number in Start Date@monthname(fullstartdate)@name of month in Start Date@day(fullstartdate)@day in Start Date@dayweek(fullstartdate)@name of day in Start Date@year(fullstartdate)@year in Start Date@hour(fullstartdate)@hour in Start Time using 12 hour clock (0-12)@ampm(fullstartdate)@AM or PM reference for Start Time@hour24(fullstartdate)@hour in Start Time using 24 hour clock (0-24)@minute(fullstartdate)@minute in Start Time

Note: For End Date, Close Date or Modified Date replace fullstartdate with fullenddate, fullclosedate or fullmodifieddate respectively.

(seconds are not available for standard date/time fields)

(Close Date does not have a time associated with it)

Examples:

To display the Start Date in the format February 22, 1985 you would use:

@monthname(fullstartdate)@ @day(fullstartdate)@, @year(fullstartdate)@

To display the End Time in the format 06:45PM you would use:

@hour(fullenddate)@:@minute(fullenddate)@@ampm(fullenddate)@

Current Date/Time

Variable List:

VariableContentDisplayComment@datetime(currentdate)@current date and time as for yyyy-mm-dd HH:mm:ss2013-01-22 17:55:22See also Obtain Server Date and Time@date(currentdate)@current date as for yyyy-mm-dd2013-05-17 @currentdate@current date2009 January 25 @now@current date and time2009 August 25 11:05AMWorkflows only. Not available within UTAsTo display specific elements of the current date or time:

@month(currentdate)@current month number@monthname(currentdate)@name of current month@day(currentdate)@current day@dayweek(currentdate)@name of current day@year(currentdate)@current year@hour(currentdate)@current hour using 12 hour clock (0-12)@ampm(currentdate)@AM or PM reference for current time@hour24(currentdate)@current hour using 24 hour clock (0-24)@minute(currentdate)@current minute

(seconds are not available for the current time)

Examples:

To display the current date/time in the format Friday at 19:55 you would use:

@dayweek(currentdate)@ at @hour24(currentdate)@:@minute(currentdate)@

Custom Fields Date/Time

For a custom field on the same level as the Web Page View Field, you can parse out a particular date/time in a date field

VariableContentDisplay@date(fieldname)@custom field date as for yyyy-mm-dd2013-05-17 @month(fieldname)@month number in fieldname05@monthname(fieldname)@name of month in fieldnameMay@day(fieldname)@day in fieldname17@dayweek(fieldname)@name of day in fieldnameFriday@year(fieldname)@year in fieldname2013@hour(fieldname)@hour in fieldname using 12 hour clock (0-12)12@ampm(fieldname)@AM or PM reference for time in fieldnameAM@hour24(fieldname)@hour in fieldname using 24 hour clock (0-24)00@minute(fieldname)@minute in fieldname00@second(fieldname)@second in fieldname00 Examples:

To display the custom field Date Of Birth in the format 31-01-2001 you would use:

@day(date of birth)@-@month(date of birth)@-@year(date of birth)@ Note: This syntax will not work for custom fields on a different level. You will not be able to reference, for example, @day(parent.fieldname)@. To parse out date/time information from a custom field on a different level, use the sscalculation syntax.

Miscellaneous Variables

Adding an image from Upload fields

Users can return image thumbnails or meta data from multiple file fields using the list syntax below":

Show thumbnail image using thunbnailpath option:

@multi file name.template[# <img src="~thumbnailpath~" alt="" width="240" /> #]@

Show thumbnail image and file name using filepath option:

@multi file name.template[# <img src="~filepath~/thumbnail/?maxwidth=240" alt="" width="240" />~filename~#]@

Show thumbnail image and file name using compressedpath option:

@multi file name.template[# <img src="~compressedpath~/thumbnail/?maxwidth=240" alt="" width="240" />~filename~#]@

Show file name, size and upload date:

@multi file name.template[# ~filename~, ~filesize~, ~uploaddate~#]@

Adding a File Upload button

To display a button to upload to a Single File or Multiple Files custom field:

Single File:

Multiple Files:

where:

customfieldid = the field id of the Single or Multiple file custom field (without cf_)

Example:

<input class="Button" type="button" value="Multiple files..." />

Note: if adding to a Web Page View you will need to add the following to the page:

function include_dom(script_filename) {
    var html_doc = document.getElementsByTagName('head').item(0);
    var js = document.createElement('script');
    js.setAttribute('language', 'javascript');
    js.setAttribute('type', 'text/javascript');
    js.setAttribute('src', script_filename);
    html_doc.appendChild(js);
    return false;
}
function includejsfiles() {
  include_dom("/validate.js");
}

You will also have to call the includejsfiles function in the body onload:

Alternatively:

You may also use @fieldname.uploadlink@ to get the url for the upload page and construct your own function to open the window.

Example:

<input class="Button" type="button" value="Upload" />

function openupload(url)
{ 
    upload_window = window.open(url,'upload_window', 'menubar=yes,scrollbars=yes,width=800,height=600,status=no,resizable=yes,dependent=yes,alwaysRaised=yes');
    upload_window.opener = window;
    upload_window.focus();
}

Note: this method will only open the single file upload page.

Displaying a Dynamic Data Grid field

To show a Dynamic Data – Data Grid field in a webpage view field use the following syntax:

@fieldname.table@

Retrieving History for Fields with Track Changes Enabled

The following syntax is used to retrieve standard or custom field history:

For the Status standard field:

@HistoryOf(status)@

@HistoryOf(statuscaption)@

For a Custom Field:

@HistoryOf(customfieldid)@

OR

@HistoryOf(customfieldname)@

Notes:

HistoryOf is case sensitive.
See the HistoryOf function page for a complete description of this variable and its uses.

For Hybrid Sign-Up Pages

The @user_input_form@ will display the associated user sign up form on a company sign up page if included in the HTML template of the company sign up page.

Currency Format

You can use the following syntax to format a custom field with currency: @format(L2 Subcontract total y1,currency,USD,2)@. The last parameter can be changed from 2 to 0 to display as a whole number.

Session Variables

When using features such as Organization Switching, you may want to pull in specific data based on your current session.

Company Fields: @sessioncompany.fieldname@

Example: @sessioncompany.name@ would return the Company Name of the organization you are currently logged in as.

Controls

Hide a variable if it is missing

Put the following in front of variable name.

Example:

  <!--hideifnotfound-->@parent.contact.adjuster.email@

Note: the  and the variable must be in immediate succession, and not separated by a space.

How to display different content based on a value using SSlogic

To display content based on a value from a variable add  in front of the content and  at the end of the content. If there are 2 different pieces of content to be displayed based on a value and all others add  between the 2 pieces of content.

<!--@sslogic(CONDITION)-->
   The content to be displayed when condition is true.
   This can be more than one line.
<!--@end-->

The content to be displayed (the middle line) can either be in plaintext or in HTML.
Be sure there are single quotes around the variable and value.
SSlogic does not support nested logic statements.

Example:

The following will display a Christmas tree image if the month is December:

<!--@sslogic(month(now())=12)-->
   <img src="images/xmasstree.jpg" alt="" />
<!--@end-->

See SSlogic for more information and further examples.

How to display check boxes in the Web Page View

To display Select Many - Check Box type custom fields as check boxes in a web page view add @checkbox('fieldname/fieldnumber','option name')@ to the check box control.

This syntax works if the check boxes are on the same level.

Example:

<input type="checkbox" />

See Also: Updateable Web Page View Fields if you wish the Web Page View check boxes to have the ability to change the underlying data.

How to display level two check boxes on level one in the Web Page View

@checkboxvalue(id

values to be checked)@

<input name="checkboxb20" type="checkbox" value="Limited community support" />

Use two "|" (pipes) to separate id and value to be checked

where 1199639 is customfield id if it is used on the same level @1199639@ if it is used on the child level $1199639$

This works for level one check boxes on level one web page view AND works for level two check boxes on level one web page view AND works for level three check boxes on level one web page view

How to suppress the Page Footer with Printing the Page

To suppress the footer when printing the page you need to change your browser settings.

Internet Explorer

1. Choose the File Page Setup menu.

2. Delete the Header and Footer text.

3. If required, change the margins.

FireFox

1. Choose the File Page Setup menu.

2. Click the Margins & Header/Footer tab.

3. Set all Header and Footer options to Blank.

3. If required, change the margins.

How to control print behaviour

To define a page break place the following code in the HTML source before the content you deem as the next page:

To change the page orientation to landscape first place the following in the header portion (

) of the HTML:

Then place

in the HTML source around the "page" content. Example:

This is the page content that needs to be in landscape

Please note that the page orientation control only works with Internet Explorer and is not the greatest quality print due to the page being converted to an image then rotated.

How to control print behaviour when saving as a PDF

To define a page break in a PDF add before the content you deem as the next page.

To change the orientation of a page to landscape in a PDF add before the content you deem as the next page.

See PDF Writer Custom Tags for further PDF formatting options

Troubleshooting

Issue: 2 variables run together (thus removing the ending @ and beginning @)
Resolution: Place a non-breaking space tag ( ) between the variables.

Issue: For a list of level 2 activities, the code is showing instead of the field headings and values you've designated.
Resolution: Insert a comment tag before the first cell tag. i.e.

@@ Line 1: / Line 1: @@
 The [[Web Page View Field]] provides the ability to display a fully formatted document or web page.
 In constructing this type of page HTML is used in conjunction with the following variables.
-==Variable List==
-<u>'''User Variables'''</u>
+=Variable List=
+==Current User==
 ''Note: "me" -- refers to the current user''
@@ Line 19: / Line 17: @@
 '''@me.companyname@'''
-<u>'''UTA Level 1, Sales Opportunity and Job Variables'''</u>
+'''@me.type@''' (returns 'User', 'Local User Administrator' or 'Global User Administrator')
+==UTA Level 1, Sales Opportunity and Job Variables==
 '''@name@''' - standard field '''Application Name'''.
@@ Line 27: / Line 26: @@
 '''@status@''' - standard field '''Status'''
-'''@description@'''
+'''@typecaption@''' - standard field '''Application Template Type Caption'''.
+'''@statuscaption@''' - standard field '''Status Caption'''
+'''@type_lang@''' - standard field '''Application Template Type (Based on user language setting)'''.
+'''@status_lang@''' - standard field '''Status (Based on user language setting)'''
+'''@description@'''
 '''@requirements@'''
@@ Line 36: / Line 43: @@
 '''@probability@'''
+'''@modifiedby@''' / '''@modifiedbyid@'''
 '''@modifieddate@'''
@@ Line 44: / Line 53: @@
 '''@enddate@'''
+'''@createddate@'''
+'''@createdby@'''
+'''@createdbyid@'''
 '''@jobquestions@''' - displays as combo boxes
@@ Line 52: / Line 67: @@
 '''@owner.field@'''
 Example: '''@owner.fullname@''' or '''@owner.address@'''
-'''@people.field@'''
+'''@person.field@'''
-Example: '''@people.fullname@''' or '''@people.address@'''
+Example: '''@person.fullname@''' or '''@person.address@'''
 '''@company.field@'''
 Example: '''@company.name@''' or '''@company.address@'''
@@ Line 70: / Line 85: @@
 Example '''@company.owner.email@'''
 '''@branch.field@'''
 Example: '''@branch.name@''' or '''@branch.address@'''
+'''@apptype@''' the Application ID (appid) of the UTA.
-<u>'''UTA Level 2 / Activities Variables'''</u>
+==UTA Level 2 / Activities Variables==
 '''@subject@'''
@@ Line 110: / Line 125: @@
 '''@owner@'''
+'''@eownerid@''' - userid of the owner
 '''@contact@'''
@@ Line 116: / Line 133: @@
 '''@eventid@'''
+'''@typename@'''
 '''@objectid@'''
@@ Line 123: / Line 142: @@
 '''@rootcompanyid@'''
+'''@rootcompany.name@'''
 '''@contact.field@'''
@@ Line 160: / Line 180: @@
-<u>'''UTA Level 2 variables called from UTA Level 3'''</u>
+==UTA Level 2 variables called from UTA Level 3==
+When working at Level 3, you can call Level 2 variables using:
-If your '''Web Page View''' is at Level 3, you can call Level 2 variables using:
 '''@parent.'''''fieldname'''''@''' or '''@parent.#'''''fieldid'''''#@''' (Note: All field names should be entirely lower case.)
@@ Line 169: / Line 188: @@
 <u>'''UTA Level 1 variables called from UTA Level 3'''</u>
-If your '''Web Page View''' is at Level 3, you can call Level ` variables using:
+If your '''Web Page View''' is at Level 3, you can call Level 1 variables using:
 '''@parent.parent.'''''fieldname'''''@''' or '''@parent.parent.#'''''fieldid'''''#@''' (Note: All field names should be entirely lower case.)
-==Field List==
+<u>'''Level 3 Associated Parent (Opportunity) '''</u>
+Where Payment Allocation is enabled you have two models to choose from before configuring: usually the Associated Parent is a Funding Stream of Overall Budget (event) and the associated object is the Disbursement (Level 3). In less granular cases the Associated Parent is the opportunity.
+<u>'''Level 3 Associated Parent'''</u>
+If Payment Allocation is enabled, you can pull fields from the Associated Parent using the following variable:
+'''@linkparent.''fieldname''@'''
+If your associated payment is linked to the event you can pull fields from the opporunity using the following variable:
+'''@linkparent.''parent''.fieldname@''' So '''@linkparent.''parent''.branch@''' will return: '''SmartSimple Inc.'''
+On the company/branch:
+'''@linkparent.parent.branch.''Transit''@''' will return: '''''1950'''''
+=Field List=
 <u>'''People Fields'''</u>
 firstname, lastname, fullname, title, email, phone, company, address, address2, city,
 province, state, country, postalcode, owner, modifieddate, cost, costunit, type,
-resourcename, isrecource, prefix, suffix, uphoneext (Phone Extension)
+resourcename, isrecource, uprefix (prefix), usuffix (suffix), uphoneext (Phone Extension)
 <u>'''Company Fields'''</u>
 name, address, address2, city, province, state, country, postalcode, phone, fax, website
 <u>'''Lead Fields'''</u>
 status, description, name, phone, fax, address, address2, city, state, province, country,
 postalcode, website, firstname, lastname, contactphone, title, email, dat_added
-==How to display contact information for people associated in the Contacts section==
+=UTA Contact and Account Variables=
+Owner:
+: <span style="font-size: medium;">'''@owner.''fieldname''@'''</span>
+Person (Level 1 only):
+: <span style="font-size: medium;">'''@person.''fieldname'''''@</span>
+Assigned (Level 2 only):
+: <span style="font-size: medium;">'''@assigned.''fieldname''@'''</span>
+Company (Level 1 only):
+: <span style="font-size: medium;">'''@client.''fieldname''@'''</span>
+Use @client.categoryids@ to return a list of [[Determining the categoryid|category IDs]] - comma delimited - note the leading comma - e.g. ",1234,555,666,"
+Use @client.categories@ to return a list of category names - comma delimited e.g. "Agency,Marketing,Good client"
+==Level 1 Contacts/Accounts==
+===Individual===
+To display information for a <u>single</u> contact/account in the Level 1 contacts/accounts section:
+: <span style="font-size: medium;">'''@contact.''rolename.fieldname''@''' </span> &nbsp; or &nbsp; <span style="font-size: medium;"> '''@company.''rolename.fieldname''@'''</span>
+'''where:'''
+* ''rolename'' = the name of the role that has been assigned to the contact/account on the Level One item
+* ''fieldname'' = the name of the field that is located on the contact's record.
+Example:
+ @contact.adjuster.firstname@ or @company.funding agency.address@
+Note: if there is more than one contact/account assigned with the rolename specified, only one will be displayed.
+===List===
+To display a list of multiple contacts/accounts in the Level 1 contacts/accounts section:
+: <span style="font-size: medium;">'''[#(?object=contact) ~''fieldname''~ #]''' </span> or <span style="font-size: medium;"> '''[#(?object=company) ~''fieldname''~ #]''' </span>
+See [[#To display a list of Activities (Level 2 or 3), Notes, Contacts or Companies|below]] for details on how to filter and sort the list(s).
+* '''Note''': to display the role that the contact or account is assigned on the Level 1 record use: <span style="font-size: medium;">'''~role~'''</span>
+* '''Note''': to display the name of the contact's company use: <span style="font-size: medium;">'''~companyname~'''</span>
+==Level 2 Contacts/Accounts==
+===Individual===
+To display information for a <u>single</u> contact in the Level 2 contacts section:
+: <span style="font-size: medium;">'''@contacts.''rolename.fieldname''@''' </span>
+'''where:'''
+* ''rolename'' = the name of the role that has been assigned to the contact on the Level Two item
+* ''fieldname'' = the name of the field that is located on the contact's record.
+Example:
+ @contacts.adjuster.firstname@
+Note: if there is more than one contact assigned with the rolename specified, only one will be displayed.
+===Contacts===
+To display a list of the contacts assigned at Level 2:
+: <span style="font-size: medium;">'''[#(?object=contact) ~firstname~ ~lastname~ ~email~ #]'''</span>
+To display only contacts assigned at Level 2 with a specific role/roles (only relevant if the Level 2 Multiple Contact List is enabled)
+: <span style="font-size: medium;">'''[#(?object=contact::criteria=roleid=12345) ~firstname~ ~lastname~ ~email~ #]'''</span>
+To get the intersection record identifier (equivalent to ~oprid~ at Level 1) (i.e. for use in [[Pandora]] functions)
+: <span style="font-size: medium;">'''[#(?object=contact) ~lnkid~ #]'''</span>
+To display the contact's profile status:
+: <span style="font-size: medium;">'''[#(?object=contact) ~firstname~ ~lastname~ ~ustatusid~ #]'''</span>
+'''Notes:'''
+* Contacts at level 2 cannot be filtered by rolename, only roleid
+* If the multiple contact list is enabled use '''~role~''' to display the assigned role.
+===Accounts===
+To display information for a <u>single</u> account in the Level 2 accounts section:
+: <span style="font-size: medium;">'''@companies.''rolename.fieldname''@'''</span>
+To display a list of the companies assigned at Level 2:
+: <span style="font-size: medium;">'''[#(?object=company::orderby=name)~name~ #]'''</span>
+To get the intersection record identifier (i.e. for use in [[Pandora]] functions)
+: <span style="font-size: medium;">'''[#(?object=company) ~clnkid~ #]'''</span>
+'''Notes:'''
+:* The Account standard field is only available at Level 2 when the Multiple Account list is enabled. See [[Relating Contacts and Accounts to the Universal Tracking Application#The Account List Field|here]] for details.
+==To display Level 1 Company Role or Contact Role custom fields==
+<span style="font-size: medium;">'''[#(?object=company;)$?opc_''customfieldid''$#]'''</span> or <span style="font-size: medium;">'''[#(?object=contact;)$?opr_''customfieldid''$#]'''</span>
+'''where:'''
+* customfieldid = the numeric id of the custom field
+'''Note:''' for level 2 records (when the multiple contact/company list(s) are enabled) use $?opr2_''customfieldid''$ and $?opc2_''customfieldid''$
+Following the same format above, you can also reference custom fields on the company role using the @#field id#@ syntax.
+<u>'''Contact Detail'''</u>
-'''Use the variable''':
+~uprefix~ ~firstname~ ~lastname~
-@contact.rolename.field@
+~uaddress~ ~uaddress2~
-'''where'''
+~ucity~, ~ustate~ ~upostalcode~
-'''rolename = the name of the role that has been assigned to the contact on the Level One item'''
+==To display Company Association or Contact Association fields==
+The syntax for extracting information on the entity to which they are associated is as follows . . .
-'''field = the name of the field that is located on the contact's record'''.
+<span style="font-size: medium;">'''[#(?object=association)~name~ ~standard field name~ $?afc_custom field id$ $?afc_custom field name$#]<br />
+<br />'''[#(?object=companyassociation)~standard field name~ $custom field id$ $custom field name$#]'''</span>
+'''where:'''
-Example: @contact.adjuster.firstname@ or @contact.project manager.address@
+* standard field name = name of the standard field
+* custom field id = the numeric id of the custom field
+* custom field name = the name of the custom field
-==How to display contact information for Companies (Accounts) associated in the Contacts section==
-'''Use the variable''':
+The syntax for extracting information on fields that are on the intersection, rather than the entity to which they are associated, is as follows . . .
-@company.rolename.field@
+<span style="font-size: medium;">'''[#(?object=association) ~afcompanyid~ #]<br />
+<br />'''[#(?object=companyassociation)~afroleid~ #]'''</span>
-'''where'''
-'''rolename = the name of the role that has been assigned to the Company on the Level One item'''
+Other '''intersection''' specific variables options include:
-'''field = the name of the field that is located on the Company's record'''.
+* ~afcid~: association (intersection) record id.
+* ~afcompanyid~: [[companyid]] of associated company
+* ~afcontactid~: [[userid]] of associated contact
+* ~afroleid~: [[roleid]] of association
+* ~afstartdate~: start date of association
+* ~afenddate~: end date of association
+==Role Based Custom Fields==
+When you have a [[Custom Field]] such as a [[Web Page View]] or [[MS Word Merge]] that is located <u>'''on'''</u> a User Role or Company Role you can access:
-Example: @company.insurance companies.name@ or @company.consulting firms.address@
+[[UTA]] Level 1 Information:
-==How to display a list of UTA Level 1 Activities, Contacts or Companies==
+: <span style="font-size: medium;">'''@levelone.''fieldname''@'''</span> or <span style="font-size: medium;">'''@levelone.''customfieldid''@'''</span>
+Contact Information:
-'''object= [activity,contact,user,company,association,level-1 (applies to contacts only) or transaction]'''
+: <span style="font-size: medium;">'''@contact.''fieldname''@'''</span> or <span style="font-size: medium;">'''@contact.''customfieldid''@'''</span>
+Company Information:
-<pre><table>[#(?object=object;orderby=field)<tr><td>~field~</td><td>~field~</td><td>~field~</td><td>$customfield id$</td></tr>#]</table></pre>
+: <span style="font-size: medium;">'''@company.''fieldname''@'''</span> or <span style="font-size: medium;">'''@company.''customfieldid''@'''</span>
+When you want to refer to a User Role based [[Custom Field]] '''<u>from</u>''' a [[UTA]] Level 1 record use the following syntax:
+Owner:
-'''Example''':
+: <span style="font-size: medium;">'''@owner.''fieldname''@'''</span>
-<pre>
+Person:
- <table>[#(?object=activity;orderby=startdate)<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table>
- <table>[#(?object=contact;orderby=lastname)<tr><td>~firstname~</td><td>~lastname~</td><td>~email~</td></tr>#]</table>
+: <span style="font-size: medium;">'''@person.''fieldname''@'''</span>
+Contact:
- <table>[#(?object=contact;orderby=lastname;criteria=rolename='Internal People')<tr><td>~firstname~</td><td>~lastname~</td><td>~email~</td></tr>#]</table>
+: <span style="font-size: medium;">'''@contact.''rolename''.''fieldname''@'''</span>
+: ''where rolename is the role they are assigned on the Level 1 record''
+=To Display a List of Activities, Notes, Transactions, Contacts, Companies, Consumers, Providers=
+==Syntax==
+<span style="font-size: medium;">'''[#(?object=''objectname''::{options})~''standardfieldname''~ $''customfieldname''$#]'''</span>
- <table>[#(?object=contact;orderby=lastname;criteria=rolename='Internal People')<tr><td>~firstname~</td><td>~lastname~</td><td>~email~</td><td>~role~</td></tr>#]</table>
+: '''Where:'''
+:* ''objectname'' is the name of the item to be listed.
+:: Either: '''address, activity, assign, contact, user, group, company, notes, association, companyassociation, transaction, timesheet''', '''level-1''', '''utaproviderL1''', '''utaproviderL2''', '''utaconsumerL1''', '''utaconsumerL2''' or '''linkactivity'''
+:
+:* ''standardfieldname'' is the name of a standard field (between tildes, ~)
+:* ''customfieldname'' is the name of a custom field (between dollar signs, $)
-</pre>
+'''Notes:'''
-*Note: Search results normally display in ascending order. You may use '''desc''' option to display results in descending order.
-'''Example''':
-<pre>
- <table>[#(?object=activity;orderby=startdate desc)<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table>
-Results will be sorted on Startdate in Descending order.
+:* You can refer to [[Custom Fields]] in the list using the Custom Field ID instead of the field name, still between dollar signs ('''$12345$''')
-</pre>
+:* '''level-1''' can only be used as an object when referenced from a contact record. Also '''level-1''' will only list the level 1s that the contact has been added to in the contacts section.
+:* You can include text as well as variables within the [#...#] syntax.
+:* When using this syntax for [[Web Page View]]s, [[Custom Field Type: Read Only – System Variables|Read Only – System Variables]] etc. you will usually want to include HTML table formatting within the '''[#...#]''' syntax (see examples below). For [[MS Word Merge]] custom fields the table defined on the MS Word Template document, with the columns delimited by pipes (|) within the '''[#...#]'''.
+:* '''~Index~''' can be used to number the lines (1, 2, 3...) '''Note:''' ~index~ does not work for all lists. For example, it cannot be used when listing contacts associated with a Level 1.
+:** ''~Index~'' (upper case 'I') starts numbering at 1, ''~index~'' (lower case 'i') starts numbering at 0.
+~eventid~ will display the id of the level 2.
-'''To sort on custom field''':
-<pre>
-<table> [#(?object=activity;orderby=tbl_custom field id.valuestr)<tr><td>~location~</td><td>~startdate~</td></tr>#]</table>
-e.g. where custom field id=999999
+'''Options:'''
-</pre>
-'''To list a specific activity type only''':
+{| class="wikitable"
-<pre>
+|-
-<table>[#(?object=activity;orderby=startdate;criteria=typename='')<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table>
+||'''Option'''
+||'''Effect'''
+|-
+||<span style="font-size: medium;">orderby=''standardfieldname''</span>
+||Sorts the list in ascending order by the standard field specified
+|-
+||<span style="font-size: medium;">orderby=''standardfieldname'' desc</span>
+||Sorts the list in descending order by the standard field specified
+|-
+||<span style="font-size: medium;">orderby=tbl_''customfieldid''.valuestr</span>
+||Sorts the list in ascending order by the custom field specified
+|-
+||<span style="font-size: medium;">criteria=''standardfieldname''='''value'''</span>
+||Filters the list by the standard field and value specified
+|-
+||<span style="font-size: medium;">criteria=tbl_''customfieldid''.valuestr='''value'''</span>
+||Filter the list by the custom field and value specified
+|-
+||<span style="font-size: medium;">criteria=(''standardfieldname''='''value''' or ''standardfieldname''='''value''')</span>
+||For multiple criteria when '''either''' conditional criteria can apply
+|-
+||<span style="font-size: medium;">criteria=(''standardfieldname''='''value''' AND ''standardfieldname''='''value''')</span>
+||For multiple criteria when '''both''' conditional criteria must apply
+|-
+||<span style="font-size: medium;">groupfunction=''aggregatefunction''</span>
+||Performs specified aggregate function on the listed fields<br />Ex. sum, count, countdistinct
+|}
-e.g. where typename='activity name'
+* ''multiple options (i.e. a criteria and an orderby option) can be included, separated by doubled colons (::)''
-<table>[#(?object=activity;orderby=startdate;criteria=typeid='')<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table>
+'''Important:''' Any custom fields that you use as criteria or orderby '''must''' appear in the display. If you do not wish to display the field you can place it in a comment. (i.e.: &lt;!--$12343$-->) However, if referencing a field as a property of a table you must show the value.
-e.g. where typeid='141414'</pre>
-'''To list activity based on a specific status name or status id''':
+'''Examples:'''
-<pre>
-<table>[#(?object=activity;orderby=startdate;criteria=statusname='')<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table>
-e.g. where statusname='status name'
+* To generate a list of Level 2 activities for a [[MS Word Merge]]:
-<table>[#(?object=activity;orderby=startdate;criteria=status.id='')<tr><td>~subject~</td><td>~location~</td><td>~startdate~</td></tr>#]</table>
+ [#(?object=activity)|~statusname~|~typename~|$speciality$|$123456$|#]
+''See [[MS Word Merge]] for further details on including tables on MS Word Merge documents''
-e.g. where status.id='1234'</pre>
-'''To format the start date and start time''':
-<pre>
-~date_format(startdate,'%Y-%m-%d') as startdate~</pre>
-'''or'''
+* To reference the Consumer UTA Level 1 owner name and ownerid from a Provider UTA Level 1 Read Only - System Variable custom field
-<pre>
-~date_format(startdate,'%h:%i %p') as starttime~
-</pre>
-*Note: If you wish to use ''"orderby=startdate"'', along with a date format other than yyyy-mm-dd you must use a slightly different syntax.
+ [#(?object=utaconsumer::criteria=statusname IN ('Placed','Resigned/Terminated'))~ownername~,~ownerid~ #]
-*Using ''"~date_format(startdate,'%d-%m-%Y') as startdate~"'' when using ''"orderby=startdate"'' will cause the date to be ordered by dd-mm-yyyy (rather than yyyy-mm-dd, which is chronological)
-*To avoid this, change ''"date_format(startdate,'%d-%m-%Y') as '''startdate'''"'' to ''"date_format(startdate,'%d-%m-%Y') as '''sdate'''"''
+* To Display custom fields via List Syntax for Invoicing (objectname=appliedtoinvoices). Grabbing a custom field value off the invoice (ie. 282588) and into an adjustment.
+<pre style="white-space: -o-pre-wrap; word-wrap: break-word;">Example: [#(?object=appliedtoinvoices)$282588$#]</pre>
+'''Note''': refer to the custom field by the number ONLY, do not use the custom field name.
-'''To list level two entity at level one using level two fieldname instead of customfield ID
-<pre>
-[#(?object=activity;criteria=typeid='19997';)
-<tr><td>~index~</td><td>Folder</td><td>$Field Name$</td><td>$customfieldID$</td><td>$customfieldID$</td></tr>
- #]
-</pre>
-==How to display a UTA contact role or company role record==
- [#(?object=company;orderby=name)<td>~name~</td><td>~customfields~</td>#]
+* 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)
-==How to display Level 1 Company Role or Contact Role custom fields==
+[#(?object=contact) #]
- [#(?object=company;orderby=name)<td>$?opc_fieldid$</td>#]
+{|
+|-
+!|First Name
+!|Last Name
+!|E-mail Address
+!|Cell Phone Number
+|-
+||~firstname~
+||~lastname~
+||~email~
+||$Cell Phone$
+|}
-'''OR'''
+'''Note''': The first line creates a header row for the table.
- [#(?object=contact;orderby=fullname)<td>$?opr_fieldid$</td>#]
+* For a list of Level 2 (or Level 3) activities sorted by Start Date in descending order:
-fieldid = the numeric id of the custom field
+ [#(?object=activity::orderby=startdate desc)#]
+{|
+|-
+||~subject~
+||~location~
+||~startdate~
+|}
-Following the same format above, you can also reference custom fields on the company role using the @#field id#@ syntax.
-<u>'''Contact Detail'''</u>
+* For a list of contacts assigned to a Level 1 with the role of "Internal People", sorted by surname:
-~uprefix~ ~firstname~ ~lastname~
+[#(?object=contact::orderby=lastname::criteria=rolename='Internal People')#]
-~uaddress~ ~uaddress2~
+{|
+|-
+||~firstname~
+||~lastname~
+||~email~
+|}
-~ucity~, ~ustate~ ~upostalcode~
-==How to Display a Date or Time Format==
+* For a list of level 1 records, including owner details, that a Company has been asssigned to:
-'''The following date variables are available for a long date format''':
+[#(?(object =level-1) NAME: ~name~ OWNERID: ~ownerid~ OWNERNAME: ~ownername~ #]
-'''@longclosedate@'''
-'''@longstartdate@'''
-'''@longenddate@'''
+* To display the level 1 ID of the level 1 records:
-'''@fullstartdate@'''
+[#(?(object =level-1) OPPORTUNITY ID: ~op.opportunityid as oppid~ #]
-Example: @longstartdate@ returns "Tuesday, November 15, 2005"
-'''The following date variables are also available''':
-@now@ - full current date and time
+* For a list of all companies that the owner of a [[UTA]] record is associated with:
-@currentdate@ - full current date only
+ @owner.[#(?object=association)~name~ (Phone ~phone~)#]@
-'''To display only specific elements of the current date''':
-@month(currentdate)@ - month number
+* To get a comma-separated list of the companyids of all the companies the current user is associated with with roleid 54545:
-@day(currentdate)@ - day
+ @me.[#(?object=association::criteria=roleid=54545)~afcompanyid~,#]@
-@year(currentdate)@ - year
-@dayweek(currentdate)@ - name of day
+* For a list of all contacts associated to the current user's parent company record (associated to the company with [[roleid]] 12345):
-@monthname(currentdate)@ - name of month
+ @me.parent.[#(?object=association::criteria=roleid='12345')~firstname~ ~lastname~ (Phone ~phone~)#]@
-'''To display only specific elements of the full start date''':
-@month(fullstartdate)@ - month number
+* For a list of a company's Active(current date is between start and end date) associations:
-@day(fullstartdate)@ - day
+ [#(?object=association::criteria=(afstartdate is null OR afstartdate<='@date(currentdate)@') AND (afenddate is null OR afenddate>='@date(currentdate)@'))~userid~,#]
-@year(fullstartdate)@ - year
-@dayweek(fullstartdate)@ - name of day
+* For a list of all contacts/users located under a company with a given role
-@monthname(fullstartdate)@ - name of month
+<pre>[#(?object=user::criteria=rolelist like '%,12345,%') ~email~ #]</pre>
-'''You can also parse out a particular date format in a date field''':
-@year(datefield)@ - returns the year value in datefield
+* To count the number of contacts assigned with the role of Reviewer:
-@month(datefield)@ - returns the month value in datefield
+<pre>[#(?object=contact::criteria=rolename="Reviewer"::groupfunction=count)~userid~#]</pre>
-@day(datefield)@ - returns the day value in datefield
-'''For Time fields:'''
+* To include and format a date stored in a custom field (see also [[sscalculation]])
-@hour(datefield)@ - returns the hour value in datefield (0-12)
+<pre>[#(?object=activity)<!--@sscalculation(date_format("$fieldname$","%M %d, %Y"))-->#]</pre>
-@ampm(datefield)@ to provide a reference for am/pm
-@hour24(datefield)@ - returns the hour value in datefield (0-24)
+* With multiple criteria:
-@minute(datefield)@ - returns the minute value in datefield
+<pre style="white-space: -o-pre-wrap; word-wrap: break-word;">[#(?object=contact::criteria=(rolename='External' or rolename='Internal'))~firstname~ ~lastname~#]
+</pre>
-@second(datefield)@ - returns the second value in datefield
-==How to hide a variable if it is missing==
+* With multiple order criteria:
-<pre>
-Put <!--hideifnotfound--> in front of variable name like this
-Example: <!--hideifnotfound-->@parent.contact.adjuster.email@
+<pre style="white-space: -o-pre-wrap; word-wrap: break-word;">[#(?object=activity::orderby=tbl_1765133.valuestr::tbl_1765119.valuestr desc)~type~, $1765133$, $1765119$<br />#]
 </pre>
+'''Note:''' ''multiple options (i.e. a criteria and an orderby option) can be included, separated by doubled colons (::)''
-==How to display different content based on a value using SSlogic==
-To display content based on a value from a variable add '''&lt;!--@sslogic('@branch.name@'='Internal Staff')--&gt;''' in front of the content and '''&lt;!--@end--&gt;''' at the end of the content. If there are 2 different pieces of content to be displayed based on a value and all others add '''&lt;!--@else--&gt;''' between the 2 pieces of content.
-<pre>
+* To sort descending by a custom field called ''Total Hours'' with a custom field id of ''67292'':
-<!--@sslogic(CONDITION)-->
-   The content to be displayed when condition is true.
+<pre style="white-space: -o-pre-wrap; word-wrap: break-word;">[#(?object=activity::orderby=tbl_67292.valuestr desc)Subject: ~subject~Total Hours: $Total Hours$Start Date: ~startdate~#]
-   This can be more than one line.
-<!--@end-->
 </pre>
+'''Note:''' ''$Total Hours$'' in the list could be listed as ''$67292$'' with the same result.
-* The content to be displayed (the middle line) can either be in plaintext or in HTML.
-* Be sure there are single quotes around the variable and value.
-* SSlogic does not support nested logic statements.
-'''Example:'''
+* To sort descending reviews in a specific status by a custom field on a separate UTA Level 1 field called ''$Staff Final Score$'' with a custom field id of ''1584168'' in numeric order:
-* The following will display a Christmas tree image if the month is December:
-<pre>
+<pre style="white-space: -o-pre-wrap; word-wrap: break-word;">[#(?object=utaconsumerL1::orderby=tbl_15868.valuestr*1::criteria=(statusname='Member Review'))
-<!--@sslogic(month(now())=12)-->
-   <img src='images/xmasstree.jpg'>
-<!--@end-->
 </pre>
+'''Note:''' ''$Staff Final Score$'' in the list could be listed as ''$15868$'' with the same result.
-'''[[SSlogic|See here]] for more information and further examples.'''
+* To list a specific activity type only:
+<pre style="white-space: -o-pre-wrap; word-wrap: break-word;">[#(?object=activity::orderby=startdate::criteria=typename='This Activity Type')~subject~~location~~startdate~#]</pre>
-==How to display check boxes in the Web Page View==
-To display Select Many - Check Box type custom fields as check boxes in a web page view add '''@checkbox('fieldname/fieldnumber','option name')@''' to the check box control.
+* To list activities based on the [[Determining the typeid|type ID]] ('''Level 2 and Level 3 only'''):
+[#(?object=activity::orderby=startdate::criteria=typeid='24160')#]
+{|
+|-
+||~subject~
+||~location~
+||~startdate~
+|}
+* To include a hyperlink to the object:
+[[File:Syntax 1.png|650px]]
+* To list activities based on status '''Draft''' and sort by '''startdate''':
+[[File:Syntax 2.png|650px]]
+* To list activities based on the status ID ('''Level 2 and Level 3 only'''):
+[[File:Syntax 3.png|650px]]
-This syntax works if the check boxes are on the same level. or
+* To list UTA Providers:
-'''Example:'''
+<pre style="white-space: -o-pre-wrap; word-wrap: break-word;">[#(?object=utaproviderL1::criteria=rolename="Panel") ~name~ ~typename~ ~statusname~ ~enddate~ $Panel Review Date$ $Panel ID
-<pre>
+<!-- @sscalculation(@xml.XML Field.People.Person[#(?criteria="~type.nodevalue~" == "A") 1+#]@ 0) -->
-<input type="checkbox" @checkbox('12345','yes')@>
 </pre>
+<pre style="white-space: -o-pre-wrap; word-wrap: break-word;">#]</pre>
+* To list notes (from the record that contains the notes):
-:See Also: [[Updateable Web Page View Fields]] if you wish the Web Page View check boxes to have the ability to change the underlying data.
+<pre style="white-space: -o-pre-wrap; word-wrap: break-word;">[#(?object=notes::orderby=createddate desc)~notes~~createddate~~username~#]</pre>
+'''Note''': This syntax is for "Public (Default)" notes only, not custom note types.
-==How to display level two check boxes on level one in the Web Page View==
-@checkboxvalue(id||values to be checked)@
- <input type="checkbox" name="checkboxb20" value="Limited community support"  @checkboxvalue($1199639$||Limited community support)@>
-* Use two "'''|'''" (pipes) to separate '''id''' and '''value''' to be checked
+* To list all companies under a parent company record:
-where 1199639 is customfield id
-if it is used on the same level '''@1199639@'''
+ [#(?object=company) ~name~ #]
-if it is used on the child level '''$1199639$'''
+* To list all L3 allocations within a L2 budget record:
+ [#(?object=linkactivity) ~subject~ #]
+* To sum or count all the L3 allocations from the budget L2 record:
+ @linkactivity.sum(...)@ or @linkactivity.count(...)@
+* To list level 2 notes for each level 2 record at level 1:
+[#(?object=activity::orderby=startdate desc)~subject~~description~~startdate~
+[@(?object=notes::orderby=createddate desc)@]
+{|
+|-
+||~notes~
+||~createddate~
+||~username~
+|}
+# ]
+'''Note''': This syntax is for "Public (Default)" notes only, not custom note types.
+* To do a sum of all the unpaid payment transaction:
+{|
+|-
+||Total Paid: [#(?object=transaction::criteria=trstranstype=11 and tbl_1145339.valuestr='Paid'::groupfunction=sum)$1145183$ <!--"145339$-->#] Note: $1145339$ - Status of payment $1145183$ - Payment Amount
+|}
+==Referencing Standard Fields of UTA Providers==
+{| class="wikitable"
+|+style="text-align:left"|Level 1 Field Name and Variable List
+|-
+!|Field Name
+!|Variable
+|-
+||Application Name
+||~name~
+|-
+||Type Name
+||~typename~
+|-
+||Type ID
+||~type~
+|-
+||Status Name
+||~statusname~
+|-
+||Status ID
+||~statusid~
+|-
+||Start Date
+||~startdate~
+|-
+||End Date
+||~enddate~
+|-
+||Close Date
+||~closedate~
+|-
+||Branch
+||''No variables''
+|-
+||Branch ID
+||~branchid~
+|-
+||Currency
+||''No variables''
+|-
+||Exchange Currency
+||''No variables''
+|-
+||Currency Exchange Rate
+||''No variables''
+|-
+||Customer
+||~client~
+|-
+||Customer ID
+||~companyid~
+|-
+||Modified By
+||''No variables''
+|-
+||Modified Date
+||''No variables''
+|-
+||Owner (full name)
+||~ownername~
+|-
+||Owner (userid)
+||~updatedby~
+|-
+||Person (full name)
+||''No variables''
+|-
+||Person (userid)
+||~oppeopleid~
+|-
+||Role Name
+||~rolename~
+|-
+||Role ID
+||~conroleid~
+|}
+'''Example:'''
+<pre style="white-space: -o-pre-wrap; word-wrap: break-word;">[#(?object=utaproviderL1) ~typename~ | ~statusname~ <br />#]</pre>
+{| class="wikitable"
+|+style="text-align:left"|Level 2 Field Names and Variables List
+|-
+!|Field Name
+!|Variable
+|-
+||Activity Type
+||~typename~
+|-
+||Activity Type ID
+||~typeid~
+|-
+||Owner
+||~ownername~
+|-
+||Owner ID
+||~eownerid~
+|-
+||Assigned People
+||''No variables''
+|-
+||Status
+||~statusname~
+|-
+||Status ID
+||~statusid~
+|-
+||Subject
+||~subject~
+|-
+||Description
+||~description~
+|-
+||Location
+||~location~
+|-
+||Amount
+||~eamount~
+|-
+||Start Date
+||~startdate~
+|-
+||End Date
+||~enddate~
+|-
+||Opportunity ID
+||~cevconoppid~
+|-
+||Event ID
+||~cevprovevtid~
+|-
+||Rolename
+||~rolename~
+|-
+||Role ID
+||~cevroleid~
+|}
+'''Example:'''
+<pre style="white-space: -o-pre-wrap; word-wrap: break-word;">[#(?object=utaproviderL2) ~typename~ | ~statusname~ <br />#]</pre>
+If you have multiple different UTAs connected as providers, you  can use criteria to filter:
+<pre style="white-space: -o-pre-wrap; word-wrap: break-word;">[#(?object=utaproviderL1::criteria=provappid="12345") ~typename~ | ~statusname~ <br />#]</pre>
+==To Format the Start Date or Start Time==
+::: <span style="font-size: medium;">'''~date_format(startdate,'%Y-%m-%d') as startdate~'''</span>
+:::: or
+::: <span style="font-size: medium;">'''~date_format(startdate,'%h:%i %p') as starttime~'''</span>
+'''Note:'''
+:::* If you wish to use ''"orderby=startdate"'', along with a date format other than yyyy-mm-dd you must use a slightly different syntax.
+:::* Using ''"~date_format(startdate,'%d-%m-%Y') as startdate~"'' when using ''"orderby=startdate"'' will cause the date to be ordered by dd-mm-yyyy (rather than yyyy-mm-dd, which is chronological)
+:::* To avoid this, change ''"date_format(startdate,'%d-%m-%Y') as '''startdate'''"'' to ''"date_format(startdate,'%d-%m-%Y') as '''sdate'''"''
+==Displaying Both Level 2 and Level 3 Activities at Level 1==
+When displaying a list of '''Level 2''' activities using the '''[#(?object=activity;)...#]''' syntax, the corresponding '''Level 3''' activities can be displayed under each of the parent '''Level 2''' activities.
+To facilitate this you must create a [[Custom Field Type: Read Only – System Variables|Read Only - System Variable]] field '''at''' Level 2 that contains the list of Level 3 activities, formatted and filtered as desired.
+:::: ''You can use [[Visibility Condition]]s, [[Role Field Permissions]] or [[Status Field Permissions]] to prevent the field from being displayed on the Level 2 record.
+'''Example:'''
+::* Create a Level 2 [[Custom Field Type: Read Only – System Variables|Read Only - System Variable]] Custom Field called '''Level 3 Activity List''' with the following:
+[@(?object=activity::orderby=typename)@]
+{|
+|-
+||Level 3 Activity: ~typename~
+||~location~
+|}
+Then create either a [[Web Page View]] or [[Custom Field Type: Read Only – System Variables|Read Only - System Variable]] at Level 1:
+[#(?object=activity::orderby=startdate) #]
+{|
+|-
+||Level 2 Activity: ~subject~
+||~statusname~
+||~startdate~
+||~enddate~
+|-
+||
+| colspan="3"|$Level 3 Activity List$
+|}
+:::: '''where''' "Level 3 Activity List" is the name you gave the [[Custom Field Type: Read Only – System Variables|Read Only – System Variable]] field
+===Level 3s with Less Than 25 Fields===
+If Level 3 has less than 25 fields it is not necessary to create a [[Custom Field Type: Read Only – System Variables|Read Only – System Variable]] Custom Field on the Level 2 that lists the Level 3 activities.
+Instead you can use the following syntax '''within''' the '''[#...#]''' that lists the Level 2 activities:
+::: <span style="font-size: medium;">'''[@(?object=activity)~standardfieldname~ $customfieldname$@]'''</span>
+'''Note:'''
+::* This syntax will only work if there are '''less than 25 fields at Level 3.'''
+'''Example:'''
+::* To display a list of Level 2 activities, including any Level 3 activities under their parent Level 2 activity:
-This works for level one check boxes on level one web page view
+[#(?object=activity::orderby=startdate) #]
-AND
-works for level two check boxes on level one web page view
-AND
-works for level three check boxes on level one web page view
-==How to display level three activities at level one in the Web Page View==
+{|
+|-
+||Level 2 Activity: ~subject~
+||~statusname~
+||~startdate~
+||~enddate~
+|-
+||
+| colspan="3"|[@(?object=activity;orderby=typename)@]
+{|
+|-
+||Level 3 Activity: ~typename~
+||~location~
+|}
+|}
-When displaying a list of '''Level 2''' activities using the [ # (?object=object;orderby=field) # ] processor, the corresponding '''Level 3''' activities can now be displayed under each of the parent '''Level 2''' activities by using [ @ (?object=object;orderby=field) @ ].
+==Displaying a Specific Number of Items in a List==
+When you want to display only specific number of activities or transactions in a [[Web Page View]] use the following syntax.
-This new feature allows level one web page fields to display level 3 items.
+<pre style="white-space: -o-pre-wrap; word-wrap: break-word;"> [#(?object=object::orderby=field)
+    <!--@sslogic(~index~='num')-->
-This a type syntax for displaying level 2 items.
+       ~standard field~ $custom field$ <br />
+    <!--@end-->
-<pre>
+  #] <br />
-<table border=1>
-[#(?object=activity;orderby=startdate)
-<tr><td colspan=2>~subject~</td><td>~location~</td><td>~startdate~</td></tr>
-#]
-</table>
 </pre>
+'''where:'''
-This is the syntax showing  level 3 items inside level 2 items.
+::* num = number of activities that should be displayed
+=XML Variables=
+==Count how many options were selected==
 <pre>
-<table border=1>
+<!--@sscalculation(@xml.XML Field.People.Person[#(?criteria="~type.nodevalue~" == "A") 1+#]@ 0)--></pre>
-[#(?object=activity;orderby=startdate)
-<tr><td colspan=2>~subject~</td><td>~location~</td><td>~startdate~</td></tr>
-<tr>
-<td>
-<table bgcolor="00FFFF">
-[@(?object=activity;orderby=startdate)<tr>
-<td>~subject~</td><td>~location~</td><td>~startdate~</td>
-</tr>@]
-</table>
-</td>
-</tr>
-#]
-</table>
-</pre>
-==How to display Level 3 Activities at Level 1 using Read Only-System Variable Field in Web Page View==
+==Filtered XML display output==
+<pre>@xml.XML Field.People.Person[#(?criteria="~type.nodevalue~" == "A")~FirstName.nodevalue~ ~LastName.nodevalue~<br />#]@</pre>
+=Date/Time Variables=
+==Standard Fields Date/Time==
+'''Variable List:'''
+::: {| border="1" cellpadding="5"
+'''Start Date''''''End Date''''''Close Date'''<br />''Level 1 only'''''Modified Date''''''Display Format'''@startdate@@enddate@@closedate@@modifieddate@Date formatted according to user preferences (At Level 1 Modified Date also includes the time: 15:40)@longstartdate@@longenddate@@longclosedate@@longmodifieddate@Friday, January 23, 2009@fullstartdate@@fullenddate@@fullclosedate@@fullmodifieddate@2009-01-23 15:40:00@datetime(fullstartdate)@@datetime(fullenddate)@@datetime(fullclosedate)@@datetime(fullmodifieddate)@2009-01-23 15:40:00@date(fullstartdate)@@date(fullenddate)@@date(fullclosedate)@@date(fullmodifieddate)@2009-01-23
-The '''Read Only'''-System Variable field can now be used in the '''Web Page View''' field.
-This is useful for displaying '''Level 3''' activities at the '''Level 1''' in a '''Web Page View''' field.
+::* '''Note''': ''Start Time'' and ''End Time'' are stored within the ''fullstartdate'' and ''fullenddate'' fields respectively. They can be accessed and formatted using the variables elements listed below.
-Currently we can display '''Level 3''' activities at '''Level 1''' using the following syntax:
+'''To display specific elements of the Start Date, Start Time, End Date, End Time, Close Date, Modified Date''':
-<pre>
+::: {| border="1" cellpadding="5"
-<table border=1>
+@month(fullstartdate)@month number in ''Start Date''@monthname(fullstartdate)@name of month in ''Start Date''@day(fullstartdate)@day in ''Start Date''@dayweek(fullstartdate)@name of day in ''Start Date''@year(fullstartdate)@year in ''Start Date''@hour(fullstartdate)@hour in ''Start Time'' using 12 hour clock (0-12)@ampm(fullstartdate)@AM or PM reference for ''Start Time''@hour24(fullstartdate)@hour in ''Start Time'' using 24 hour clock (0-24)@minute(fullstartdate)@minute in ''Start Time''
-[#(?object=activity;orderby=startdate)
-<tr><td colspan=2>~subject~</td><td>~location~</td><td>~startdate~</td></tr>
-<tr>
-<td>
-<table bgcolor="00FFFF">
-[@(?object=activity;orderby=startdate)<tr>
-<td>~subject~</td><td>~location~</td><td>~startdate~</td>
-</tr>
-@]
-</table>
+::: '''Note:''' For '''End Date''', '''Close Date''' or '''Modified Date''' replace '''fullstartdate''' with '''fullenddate''', '''fullclosedate''' or '''fullmodifieddate''' respectively.'''
-</td>
+::: ''(seconds are not available for standard date/time fields)''
-</tr>
+::: ''('''Close Date''' does not have a time associated with it)
+'''Examples:'''
-#]
+::
-</table>
+::* To display the Start Date in the format '''February 22, 1985''' you would use:
-</pre>
+ @monthname(fullstartdate)@ @day(fullstartdate)@, @year(fullstartdate)@
+::* To display the End Time in the format '''06:45PM''' you would use:
-This method, however, has the limitation that only '''Level 3''' activities with less than 25 fields can be displayed using this technique.
+ @hour(fullenddate)@:@minute(fullenddate)@@ampm(fullenddate)@
-To display '''Level 3''' activities that have more than 25 fields, the following method is now available:
+==Current Date/Time==
+'''Variable List:'''
-. Create a '''Read Only - System Variable''' field at '''Level 2'''.
+::: {| border="1" cellpadding="5"
+VariableContentDisplayComment@datetime(currentdate)@current date and time as for yyyy-mm-dd HH:mm:ss2013-01-22 17:55:22See also [[Obtain Server Date and Time]]@date(currentdate)@current date as for yyyy-mm-dd2013-05-17&nbsp;@currentdate@current date2009 January 25&nbsp;@now@current date and time2009 August 25 11:05AMWorkflows only. Not available within [[UTA]]s
-. Format the field as you would a '''Web Page View''' field. For example:
-<pre>
+'''To display specific elements of the current date or time''':
-<table border=1>
-[#(?object=activity;orderby=startdate)
-<tr><td colspan=2>~subject~</td><td>~location~</td><td>~startdate~</td></tr>
-#]
-</table>
-</pre>
+::: {| border="1" cellpadding="5"
+@month(currentdate)@current month number@monthname(currentdate)@name of current month@day(currentdate)@current day@dayweek(currentdate)@name of current day@year(currentdate)@current year@hour(currentdate)@current hour using 12 hour clock (0-12)@ampm(currentdate)@AM or PM reference for current time@hour24(currentdate)@current hour using 24 hour clock (0-24)@minute(currentdate)@current minute
-. You can now use the field in the Web Page View as you would any other field. For example:
+::: (seconds are not available for the current time)
+'''Examples:'''
-<pre>
+::* To display the current date/time in the format '''Friday at 19:55''' you would use:
-<table border=1>[#(?object=activity;orderby=startdate)<tr><td colspan=2>~subject~</td><td>~location~</td><td>~startdate~</td></tr><tr><td colspan=2>$123456$</td></tr>#]
-</table>
-</pre>
-==How to suppress the Page Footer with Printing the Page==
+ @dayweek(currentdate)@ at @hour24(currentdate)@:@minute(currentdate)@
-To suppress the footer when printing the page you need to change your browser settings.
+==Custom Fields Date/Time==
+'''For a custom field on the same level as the Web Page View Field, you can parse out a particular date/time in a date field'''
-'''Internet Explorer'''
+::: {| border="1" cellpadding="5"
+VariableContentDisplay@date(''fieldname'')@custom field date as for yyyy-mm-dd2013-05-17
-. Choose the '''File Page Setup''' [[Menu|menu]].
-. Delete the '''Header''' and '''Footer''' text.
+@month(''fieldname'')@month number in ''fieldname''05@monthname(''fieldname'')@name of month in ''fieldname''May@day(''fieldname'')@day in ''fieldname''17@dayweek(''fieldname'')@name of day in ''fieldname''Friday@year(''fieldname'')@year in ''fieldname''2013@hour(''fieldname'')@hour in ''fieldname'' using 12 hour clock (0-12)12@ampm(''fieldname'')@AM or PM reference for time in ''fieldname''AM@hour24(''fieldname'')@hour in ''fieldname'' using 24 hour clock (0-24)00@minute(''fieldname'')@minute in ''fieldname''00@second(''fieldname'')@second in ''fieldname''00
-. If required, change the margins.
-'''FireFox'''
+'''Examples:'''
-. Choose the '''File Page Setup''' [[Menu|menu]].
+::* To display the custom field '''Date Of Birth''' in the format '''31-01-2001''' you would use:
-. Click the '''Margins & Header/Footer''' tab.
+ @day(date of birth)@-@month(date of birth)@-@year(date of birth)@
-. Set all '''Header''' and '''Footer''' options to '''Blank'''.
+'''Note:'''
+This syntax will not work for custom fields on a different level. You will not be able to reference, for example, @day(parent.''fieldname'')@. To parse out date/time information from a custom field on a different level, use the [[Sscalculation#Using_sscalculation_to_Change_Date_Formats_of_Data_in_Custom_Fields|sscalculation]] syntax.
-. If required, change the margins.
+=Miscellaneous Variables=
+==Adding an image from Upload fields==
+Users can return image thumbnails or meta data from multiple file fields using the list syntax below":
-==How to control print behavior==
+::* Show thumbnail image using thunbnailpath option:
-'''To define a page break place the following code in the HTML source before the content you deem as the next page''':
+<pre>@multi file name.template[# <img src="~thumbnailpath~" alt="" width="240" /> #]@
-<pre>
-<div style="PAGE-BREAK-AFTER: always"><br style="height:0; line-height:0"></div>
 </pre>
-'''To change the page orientation to landscape first place the following in the header portion (<head></head>) of the HTML''':
-<pre>
+::* Show thumbnail image and file name using filepath option:
-<style type="text/css" media="print">
-div.page  {
+<pre>@multi file name.template[# <img src="~filepath~/thumbnail/?maxwidth=240" alt="" width="240" />~filename~#]@
-writing-mode: tb-rl;
-height: 80%;
-margin: 10% 0%;
-margin-right: 80pt;
-filter: progid:DXImageTransform.Microsoft.BasicImage(Rotation=1);
-}
-</style>
 </pre>
-'''Then place <pre><div class="page"></div> </pre>in the HTML source around the "page" content.'''
-Example: <pre><div class="page">This is the page content that needs to be in landscape</div></pre>
+::* Show thumbnail image and file name using compressedpath option:
-Please note that the page orientation control only works with Internet Explorer and is not the greatest quality print due to the page being converted to an image then rotated.
+<pre>@multi file name.template[# <img src="~compressedpath~/thumbnail/?maxwidth=240" alt="" width="240" />~filename~#]@
+</pre>
+::* Show file name, size and upload date:
-==How to control print behavior when saving as a PDF==
+<pre>@multi file name.template[# ~filename~, ~filesize~, ~uploaddate~#]@
+</pre>
-To define a page break in a PDF add <pd4ml:page.break/> before the content you deem as the next page.
-To change the orientation of a page to landscape in a PDF add <pd4ml:page.break pageFormat="rotate"> before the content you deem as the next page.
+==Adding a File Upload button==
+To display a button to upload to a [[Single File]] or [[Multiple Files]] custom field:
-==How to display a Dynamic Data grid field==
+::* Single File:
+::: <span style="font-size: medium;"><input class="Button" type="button" value="Button Label" /></span>
+::
+::* Multiple Files:
+::: <span style="font-size: medium;"><input class="Button" type="button" value="Button Label." /></span>
+'''where:'''
+::
+::* ''customfieldid'' = the field id of the Single or Multiple file custom field (without '''cf_''')
-To show the data grid field in the webpage view field use the syntax '@fieldname.table@'.
+'''Example:'''
-==How to display the Transaction types==
+ <input class="Button" type="button" value="Multiple files..." />
-In order to display a transaction type and its fields use the following example:
+'''Note:''' if adding to a [[Web Page View]] you will need to add the following to the page:
-Syntax:
+<pre>function include_dom(script_filename) {
-<pre>
+    var html_doc = document.getElementsByTagName('head').item(0);
-[#(?object=transaction;orderby=fieldname;criteria=typename='')<tr><td>$customfieldid$</td><td>$customfieldid$</td></tr>#]
+    var js = document.createElement('script');
+    js.setAttribute('language', 'javascript');
+    js.setAttribute('type', 'text/javascript');
+    js.setAttribute('src', script_filename);
+    html_doc.appendChild(js);
+    return false;
+}
+function includejsfiles() {
+  include_dom("/validate.js");
+}
 </pre>
-Example Code:
+You will also have to call the ''includejsfiles'' function in the body onload:
- [#(?object=transaction;orderby=tbl_1041842.valuestr desc;criteria=typename='Co-Principal Investigor, Co-Applicant, Additional Author')
- <tr><!--~typename~--><td>$1041842$</td><td>$1041843$</td><td>$1041844$</td><td>$1041845$</td></tr>
- #]
-To retrieve all '''Company''' transactions for the company attached to '''Level 1''' (Standard field - Customer):
-<pre>
-@company.[#(?object=transaction)<tr><td>~details~</td><td>~subject~</td><td>~startdate~</td></tr>#]@
+'''Alternatively:'''
+You may also use @fieldname.uploadlink@ to get the url for the upload page and construct your own function to open the window.
+'''Example:'''
+ <input class="Button" type="button" value="Upload" />
+<pre>function openupload(url)
+{
+    upload_window = window.open(url,'upload_window', 'menubar=yes,scrollbars=yes,width=800,height=600,status=no,resizable=yes,dependent=yes,alwaysRaised=yes');
+    upload_window.opener = window;
+    upload_window.focus();
+}
 </pre>
-To retrieve all '''Branch''' transactions for the branch attached to '''Level 1''' (Standard field - Branch):
+'''Note:''' this method will only open the single file upload page.
+==Displaying a Dynamic Data Grid field==
+To show a [[Custom Field Type: Dynamic Data – Data Grid|Dynamic Data – Data Grid]] field in a webpage view field use the following syntax:
+::: <span style="font-size: medium;">'''@fieldname.table'''@</span>
+==Retrieving History for Fields with Track Changes Enabled==
+The following syntax is used to retrieve standard or custom field history:
+For the [[Status]] standard field:
+::: <span style="font-size: medium;">'''@HistoryOf(status)@'''</span>
+::: <span style="font-size: medium;">'''@HistoryOf(statuscaption)@'''</span>
+For a [[Custom Field]]:
+::: <span style="font-size: medium;">'''@HistoryOf(''customfieldid'')@'''</span>
+OR
+::: <span style="font-size: medium;">'''@HistoryOf(''customfieldname'')@'''</span>
+'''Notes:'''
+:::* ''HistoryOf'' is case sensitive.
+:::* See the [[HistoryOf function]] page for a complete description of this variable and its uses.
+<!--:::* You can only obtain the history of the Status field and [[Custom Fields]] in this way.-->
+==For Hybrid Sign-Up Pages==
+::: The @user_input_form@ will display the associated user sign up form on a company sign up page if included in the HTML template of the company sign up page.
-<pre>
+==Currency Format==
-@branch.[#(?object=transaction)<tr><td>~details~</td><td>~subject~</td><td>~startdate~</td></tr>#]@
+::: You can use the following syntax to format a custom field with currency: @format(L2 Subcontract total y1,currency,USD,2)@. The last parameter can be changed from 2 to 0 to display as a whole number.
+==Session Variables==
+When using features such as Organization Switching, you may want to pull in specific data based on your current session.
+:: Company Fields: '''@sessioncompany.fieldname@'''
+Example: @sessioncompany.name@ would return the Company Name of the organization you are currently logged in as.
+=Controls=
+==Hide a variable if it is missing==
+Put the following in front of variable name.
+::: <span style="font-size: medium;">'''&lt;!--hideifnotfound-->'''</span>
+'''Example''':
+<pre>  <!--hideifnotfound-->@parent.contact.adjuster.email@
 </pre>
-To retrieve all '''People''' transactions for the [[User|user]] attached to '''Level 1''' (Standard field - Owner):
+'''Note:''' the &lt;!--hideifnotfound--> and the variable must be in immediate succession, and not separated by a space.
+==How to display different content based on a value using SSlogic==
+To display content based on a value from a variable add '''&lt;!--@sslogic('@branch.name@'='Internal Staff')--&gt;''' in front of the content and '''&lt;!--@end--&gt;''' at the end of the content. If there are 2 different pieces of content to be displayed based on a value and all others add '''&lt;!--@else--&gt;''' between the 2 pieces of content.
 <pre>
-@owner.[#(?object=transaction)<tr><td>~details~</td><td>~subject~</td><td>~startdate~</td></tr>#]@
+<!--@sslogic(CONDITION)-->
+   The content to be displayed when condition is true.
+   This can be more than one line.
+<!--@end-->
 </pre>
-To retrieve the '''Level 1''' transactions at '''Level 2''':
+::* The content to be displayed (the middle line) can either be in plaintext or in HTML.
+::* Be sure there are single quotes around the variable and value.
+::* SSlogic does not support nested logic statements.
+'''Example:'''
+::* The following will display a Christmas tree image if the month is December:
 <pre>
-@parent.[#(?object=transaction)<tr><td>~details~</td><td>~subject~</td><td>~startdate~</td></tr>#]@
+<!--@sslogic(month(now())=12)-->
+   <img src="images/xmasstree.jpg" alt="" />
+<!--@end-->
 </pre>
-To retrieve the '''Level 1''' transactions at '''Level 2''' by transaction type:
+'''See [[SSlogic]] for more information and further examples.'''
-<pre>
+==How to display check boxes in the Web Page View==
-@parent.[#(?object=transaction;criteria=typename='Name of Transaction Type')
+To display Select Many - Check Box type custom fields as check boxes in a web page view add '''@checkbox('fieldname/fieldnumber','option name')@''' to the check box control.
-<tr><td>$fieldid$</td><td>$fieldid$</td><td>$fieldid$</td><td>$fieldid$</td></tr>
-#]@
+This syntax works if the check boxes are on the same level.
+'''Example:'''
+<pre><input type="checkbox" />
 </pre>
-'''Impact''': Transactions on the '''Company''' and [[User]] objects can now be displayed in a [[UTA]] web page view. The transaction does not have to directly associated with the '''Level 1''' item.
+::: See Also: [[Updateable Web Page View Fields]] if you wish the Web Page View check boxes to have the ability to change the underlying data.
+==How to display level two check boxes on level one in the Web Page View==
+@checkboxvalue(id
+values to be checked)@
-'''To get the modified date of a transaction use the following:'''
+ <input name="checkboxb20" type="checkbox" value="Limited community support" />
- ~trsts~ ''or'' ~date_format(trsts,'%Y-%m-%d') as lastmodified~
-==How to display specific number of activities or transactions==
-When you want to display only specific number of activities or transactions from underlying level, use the following syntax.
-<pre>
- [#(?object=object;orderby=field)
-    <!--@sslogic(~index~='num')-->
-       ~standard field~ $custom field$ <br />
-    <!--@end-->
-  #] <br />
-    where, num= number of activities that should be displayed
+::* Use two "'''|'''" (pipes) to separate '''id''' and '''value''' to be checked
-</pre>
+where 1199639 is customfield id
+if it is used on the same level '''@1199639@'''
+if it is used on the child level '''$1199639$'''
+This works for level one check boxes on level one web page view
+AND
+works for level two check boxes on level one web page view
+AND
+works for level three check boxes on level one web page view
+==How to suppress the Page Footer with Printing the Page==
+To suppress the footer when printing the page you need to change your browser settings.
+'''Internet Explorer'''
+. Choose the '''File Page Setup''' [[Menu|menu]].
+. Delete the '''Header''' and '''Footer''' text.
+. If required, change the margins.
+'''FireFox'''
+. Choose the '''File Page Setup''' [[Menu|menu]].
+. Click the '''Margins & Header/Footer''' tab.
+. Set all '''Header''' and '''Footer''' options to '''Blank'''.
-== Role base Web page view field ==
+. If required, change the margins.
-When you have a role base web page view field or company based webpage view field you can access the levelone, contacts, or company information.
+==How to control print behaviour==
+'''To define a page break place the following code in the HTML source before the content you deem as the next page''':
- @levelone.custom field name/custom field id@
- @levelone.standard field name@
- @company.custom field name/custom field id@
+'''To change the page orientation to landscape first place the following in the header portion ('''
- @company.standard field name@
- @contact.custom fieldname/custom field id@
+''') of the HTML''':
- @contact.standard field name@
+'''<strong>Then place'''</strong>
+<pre> </pre>
+'''in the HTML source around the "page" content.'''
+Example:
+<div class="page">This is the page content that needs to be in landscape</div>
+Please note that the page orientation control only works with Internet Explorer and is not the greatest quality print due to the page being converted to an image then rotated.
+==How to control print behaviour when saving as a PDF==
+To define a page break in a PDF add before the content you deem as the next page.
-== Retrieving Custom Field History ==
+To change the orientation of a page to landscape in a PDF add before the content you deem as the next page.
-The following syntax is used to retrieve custom field history:
+::* See [[PDF Writer Custom Tags]] for further [[PDF]] formatting options
-For the [[Status]] field:
+=Troubleshooting=
- @HistoryOf(status)@
+* '''Issue''': 2 variables run together (thus removing the ending @ and beginning @)
+* '''Resolution''': Place a non-breaking space tag (&amp;nbsp;) between the variables.
-For a [[Custom Field]]:
- @HistoryOf(#####)@
-:''where ##### is the Custom Field ID. (The field name is not accepted in this case.)
-==Troubleshooting==
-* In the event of 2 variables running together (removing the ending @ and beginning @) the issue can be resolved by placing a non-breaking space tag (&nbsp;) in between each other.
+* '''Issue''': For a list of level 2 activities, the code is showing instead of the field headings and values you've designated.
-* For your list of level 2 activities, your code is showing instead of the field headings and values you've designated.
+* '''Resolution''': Insert a comment tag before the first cell tag. i.e.
-Try inserting a comment tag before the first cell tag. i.e.<pre><tr><!--~index~--><td></pre>
-==See Also==
+=See Also=
-* [[SSlogic]]
+* [[Root Company Variable]]s
+* [[sslogic]]
+* [[ssattach]]
+* [[sscalculation]]
 * [[Web Page View Field]]
 * [[Attach a PDF to a Web Page View]]
@@ Line 711: / Line 1,236: @@
 * [[Changing the Status from a Web Page View]]
 * [[Custom Field Type: Display Only – Web Page View]]
+* [[:Category:PDF|PDF Category]]
+* [[PDF Writer Custom Tags]]
+* [[Adding JavaScript JS files to Web Page View Pages]]
+* [[Custom Field ID|Determining the Custom Field ID]]
+[[Category:Custom Fields]][[Category:Variables]][[Category:PDF]]
-[[Category:Custom Fields]][[Category:Variables]][[Category:JavaScript Examples]]

Difference between revisions of "Web Page View Field Variables"

Latest revision as of 10:20, 14 August 2024

Contents

Variable List

Current User

UTA Level 1, Sales Opportunity and Job Variables

UTA Level 2 / Activities Variables

UTA Level 2 variables called from UTA Level 3

Field List

UTA Contact and Account Variables

Level 1 Contacts/Accounts

Individual

List

Level 2 Contacts/Accounts

Individual

Contacts

Accounts

To display Level 1 Company Role or Contact Role custom fields

To display Company Association or Contact Association fields

Role Based Custom Fields

To Display a List of Activities, Notes, Transactions, Contacts, Companies, Consumers, Providers

Syntax

Referencing Standard Fields of UTA Providers

To Format the Start Date or Start Time

Displaying Both Level 2 and Level 3 Activities at Level 1

Level 3s with Less Than 25 Fields

Displaying a Specific Number of Items in a List

XML Variables

Count how many options were selected

Filtered XML display output

Date/Time Variables

Standard Fields Date/Time

Current Date/Time

Custom Fields Date/Time

Miscellaneous Variables

Adding an image from Upload fields

Adding a File Upload button

Displaying a Dynamic Data Grid field

Retrieving History for Fields with Track Changes Enabled

For Hybrid Sign-Up Pages

Currency Format

Session Variables

Controls

Hide a variable if it is missing

How to display different content based on a value using SSlogic

How to display check boxes in the Web Page View

How to display level two check boxes on level one in the Web Page View

How to suppress the Page Footer with Printing the Page

How to control print behaviour

How to control print behaviour when saving as a PDF

Troubleshooting

See Also

Navigation menu

Search