Difference between revisions of "Variable List"

From SmartWiki
Jump to: navigation, search
(Parent can be Company, Level 1, Opportunity or Leads)
(28 intermediate revisions by 9 users not shown)
Line 1: Line 1:
 
==System Variables==
 
==System Variables==
 
''This refers to [[System Variables]] defined on the [[Global Settings]] page''
 
''This refers to [[System Variables]] defined on the [[Global Settings]] page''
*'''@system.'''''customfieldname'''''@'''
+
 
 +
* '''@system.'''''customfieldname'''''@'''
  
 
==System Library Variables==
 
==System Library Variables==
 
''This refers to System Library Variables defined on the [[Global Settings]] page''
 
''This refers to System Library Variables defined on the [[Global Settings]] page''
*'''@system.library.'''''variable name'''''@'''
+
 
 +
* '''@system.library.'''''variable name'''''@'''
 +
 
 +
'''Note''': Library variables are available in all instances but can only be created and edited by SmartSimple.
  
 
==System-Wide Variables==
 
==System-Wide Variables==
 +
'''@currentdate@'''
  
'''@currentdate@'''
+
* Inserts the current date and time
  
* Inserts the current date and time
+
* This can be used in most areas where variables are called
  
* This can be used in most areas where variables are called
 
 
 
==Web Page View Variables==
 
==Web Page View Variables==
+
'''@now@'''
'''@now@'''
 
  
* Inserts the current system date
+
* Inserts the current system date
 +
 
 +
==Local Time Variable==
 +
'''@localhour(fullstartdate)@'''
 +
 
 +
* Adding the word local before the variable displays the hour based on the system time zone and not default Eastern time. The same can be used for minutes and for am/pm.
  
 
==Universal Tracking Application Variables==
 
==Universal Tracking Application Variables==
 
 
===Level 1===
 
===Level 1===
 
 
{| class="wikitable"
 
{| class="wikitable"
|+Level 1 Field Name and Variable List
+
|+style="text-align:left"|Level 1 Field Name and Variable List
!Field Name
 
!Variable
 
 
|-
 
|-
|level 1 name field
+
!|Field Name
|@name@
+
!|Variable
 
|-
 
|-
|level 1 type field
+
||level 1 name field
|@type@
+
||@name@
 
|-
 
|-
|level 1 status field
+
||level 1 type field
|@status@
+
||@type@
 
|-
 
|-
|level 1 start date
+
||level 1 status field
|@startdate@
+
||@status@
 
|-
 
|-
|level 1 end date
+
||level 1 start date
|@enddate@
+
||@startdate@
 
|-
 
|-
|level 1 contact
+
||level 1 end date
|@contact@
+
||@enddate@
 
|-
 
|-
|level 1 custom field
+
||level 1 contact
|@customfieldname@
+
||@contact@
 
|-
 
|-
|Accounts
+
||level 1 custom field
|No variables
+
||@customfieldname@
 
|-
 
|-
|Activity List
+
||Accounts
|No variables
+
||No variables
 
|-
 
|-
|Application Name
+
||Activity List
|@name@
+
||No variables
 
|-
 
|-
|Application Template Type
+
||Application Name
|@type@
+
||@name@
 
|-
 
|-
|Application Template Type Caption
+
||Application Template Type
|@typecaption@
+
||@type@
 
|-
 
|-
|Application Template Type Language
+
||Application Template Type Caption
|@type_lang@
+
||@typecaption@
 
|-
 
|-
|Archived
+
||Application Template Type Language
|@archived@
+
||@type_lang@
 
|-
 
|-
|Branch
+
||Archived
|@branch@
+
||@archived@
 
|-
 
|-
|Branch ID
+
||Branch
|@branchid@
+
||@branch@
 
|-
 
|-
|Close Date
+
||Branch ID
|@closedate@
+
||@branchid@
 
|-
 
|-
|Contacts
+
||Close Date
|No variables
+
||@closedate@
 
|-
 
|-
|Currency
+
||Contacts
|@currency@
+
||No variables
 
|-
 
|-
|Exchange Currency
+
||Currency Name
|@excurrency@
+
||@currencyname@
 
|-
 
|-
|Currency Exchange Rate
+
||Currency Code
|@exrate@
+
||@currencycode@
 
|-
 
|-
|Customer
+
||Exchange Currency  Name
|@client@
+
||@excurrencyname@
 
|-
 
|-
|Description
+
||Exchange Currency Code
|@description@
+
||@excurrencycode@
 
|-
 
|-
|End Date
+
||Currency Exchange Rate
|@enddate@
+
||@exrate@
 
|-
 
|-
|End Time
+
||Customer
|@hour(fullenddate)@:@minute(fullenddate)@
+
||@client@
 
|-
 
|-
|Folders
+
||Description
|No variables
+
||@description@
 
|-
 
|-
|Modified By
+
||End Date
|@modifiedby@ (username); @modifiedbyid@ (userid)
+
||@enddate@
 
|-
 
|-
|Modified Date
+
||End Time
|@modifieddate@
+
||@hour(fullenddate)@:@minute(fullenddate)@
 
|-
 
|-
|Owner (full name)
+
||Folders
|@owner@
+
||No variables
 
|-
 
|-
|Owner (userid)
+
||Modified By
|@ownerid@
+
||@modifiedby@ (username); @modifiedbyid@ (userid)
 
|-
 
|-
|Person (full name)
+
||Modified Date
|@person@
+
||@modifieddate@
 
|-
 
|-
|Person (userid)
+
||Owner (full name)
|@person.userid@
+
||@owner@
 
|-
 
|-
|Probability
+
||Owner (full name - Consumer/Provider reference)
|@probability@
+
||@ownername@
 
|-
 
|-
|Requirement
+
||Owner (userid)
|@requirements@
+
||@ownerid@
 
|-
 
|-
|Revenue
+
||Person (full name)
|@revenue@
+
||@person@
 
|-
 
|-
|Revenue
+
||Person (userid)
|@revenue.value@ (unformatted number without comma separators)
+
||@person.userid@
 
|-
 
|-
|Start Date
+
||Probability
|@startdate@
+
||@probability@
 
|-
 
|-
|Start Time
+
||Requirement
|@hour(fullstartdate)@:@minute(fullstartdate)@
+
||@requirements@
 
|-
 
|-
|Status
+
||Revenue
|@status@
+
||@revenue@
 
|-
 
|-
|Status Caption
+
||Revenue
|@statuscaption@
+
||@revenue.value@ (unformatted number without comma separators)
 
|-
 
|-
|Status Language
+
||Start Date
|@status_lang@
+
||@startdate@
 
|-
 
|-
|Workflow
+
||Start Time
|No variables
+
||@hour(fullstartdate)@:@minute(fullstartdate)@
 +
|-
 +
||Status
 +
||@status@
 +
|-
 +
||Status ID
 +
||@statusid@
 +
|-
 +
||Status Caption
 +
||@statuscaption@
 +
|-
 +
||Status Language
 +
||@status_lang@
 +
|-
 +
||Status Name
 +
||@statusname@
 +
|-
 +
||Workflow
 +
||No variables
 
|}
 
|}
  
 
===Level 2===
 
===Level 2===
 
 
{| class="wikitable"
 
{| class="wikitable"
|+Level 2 Field Names and Variables List
+
|+style="text-align:left"|Level 2 Field Names and Variables List
!Field Name
+
|-
!Variable
+
!|Field Name
 +
!|Variable
 
|-
 
|-
|'''Activity Type'''
+
||'''Activity Type'''
|@type@
+
||@type@
 
|-
 
|-
|'''Activity Type [[Caption]]'''
+
||'''Activity Type [[Caption]]'''
|@typecaption@
+
||@typecaption@
 
|-
 
|-
|'''Activity Type ID'''
+
||'''Activity Type ID'''
|@typeid@
+
||@typeid@
 
|-
 
|-
|'''Amount'''
+
||'''Amount'''
|@eamount@
+
||@eamount@
 
|-
 
|-
|'''Assigned Links'''
+
||'''Assigned Links'''
|''No variables''
+
||''No variables''
 
|-
 
|-
|'''Assigned People'''
+
||'''Assigned People'''
|@assigned@
+
||@assigned@
 
|-
 
|-
|'''Contact Links'''
+
||'''Contact Links'''
|''No variables''
+
||''No variables''
 
|-
 
|-
|'''Contact People'''
+
||'''Contact People'''
|@contact@
+
||@contact@
 
|-
 
|-
|'''Description'''
+
||'''Contact User ID'''
|@description@
+
||@contact.userid@ -- Returns one only, even with multiple contacts assigned
 
|-
 
|-
|'''Duration'''
+
||'''Description'''
|@span@
+
||@description@
 
|-
 
|-
|'''End Date'''
+
||'''Duration'''
|@enddate@
+
||@span@
 
|-
 
|-
|'''End Hour''' (0-23)
+
||'''End Date'''
|@endhour@
+
||@enddate@
 
|-
 
|-
|'''End Hour''' (1-12)
+
||'''End Hour''' (0-23)
|@endh@
+
||@endhour@
 
|-
 
|-
|'''End Hour AM or PM'''
+
||'''End Hour''' (1-12)
|@endampm@
+
||@endh@
 
|-
 
|-
|'''End Minute'''
+
||'''End Hour AM or PM'''
|@endminute@
+
||@endampm@
 
|-
 
|-
|'''End Time'''
+
||'''End Minute'''
|@endhour@:@endminute@  
+
||@endminute@
 
|-
 
|-
|'''Event ID'''
+
||'''End Time'''
|@eventid@
+
||@endhour@:@endminute@
 
|-
 
|-
|'''Follow-up Days'''
+
||'''Event ID'''
|''No variables''
+
||@eventid@
 
|-
 
|-
|'''Follow-up Sent'''
+
||'''Follow-up Days'''
|''No variables''
+
||''No variables''
 
|-
 
|-
|'''Follow-up Type'''
+
||'''Follow-up Sent'''
|''No variables''
+
||''No variables''
 
|-
 
|-
|'''Location'''
+
||'''Follow-up Type'''
|@location@
+
||''No variables''
 
|-
 
|-
|'''Object ID''' (Parent system ID)
+
||'''Location'''
|@objectid@
+
||@location@
 
|-
 
|-
|'''Object Type'''
+
||'''Object ID''' (Parent system ID)
|@objecttype@
+
||@objectid@
 
|-
 
|-
|'''Owner'''
+
||'''Object Type'''
|@owner@
+
||@objecttype@
 
|-
 
|-
|'''Parent Name'''
+
||'''Owner'''
|@parent.name@
+
||@owner@
 
|-
 
|-
|'''Reminder Days'''
+
||'''Owner ID'''
|''No variables''
+
||@eownerid@
 
|-
 
|-
|'''Reminder Sent'''
+
||'''Parent Name'''
|''No variables''
+
||@parent.name@
 
|-
 
|-
|'''Reminder Type'''
+
||'''Reminder Days'''
|''No variables''
+
||''No variables''
 
|-
 
|-
|'''Root Company ID'''
+
||'''Reminder Sent'''
|@rootcompanyid@
+
||''No variables''
 
|-
 
|-
|'''Start Date'''
+
||'''Reminder Type'''
|@startdate@
+
||''No variables''
 
|-
 
|-
|'''Start Hour''' (0-23)
+
||'''Root Company ID'''
|@starthour@
+
||@rootcompanyid@
 
|-
 
|-
|'''Start Hour''' (1-12)
+
||'''Start Date'''
|@starth@
+
||@startdate@
 
|-
 
|-
|'''Start Hour AM or PM'''
+
||'''Start Hour''' (0-23)
|@startampm@
+
||@starthour@
 
|-
 
|-
|'''Start Minute'''
+
||'''Start Hour''' (1-12)
|@startminute@
+
||@starth@
 
|-
 
|-
|'''Start Time'''
+
||'''Start Hour AM or PM'''
|@starthour@:@startminute@
+
||@startampm@
 
|-
 
|-
|'''Status'''
+
||'''Start Minute'''
|@status@
+
||@startminute@
 
|-
 
|-
|'''Status [[Caption]]'''
+
||'''Start Time'''
|@statuscaption@
+
||@starthour@:@startminute@
 
|-
 
|-
|'''Subject'''
+
||'''Status'''
|@subject@
+
||@status@
 
|-
 
|-
|'''Updated By'''
+
||'''Status [[Caption]]'''
|@updatedby@ -- Displays system ID, not name
+
||@statuscaption@
 
|-
 
|-
|'''Updated By Name'''
+
||'''Subject'''
|@updatedbyname@ -- Displays the name
+
||@subject@
 
|-
 
|-
|'''Whole Day Event'''
+
||'''Updated By'''
|@isallday@
+
||@updatedby@ -- Displays system ID, not name
 +
|-
 +
||'''Updated By Name'''
 +
||@updatedbyname@ -- Displays the name
 +
|-
 +
||'''Whole Day Event'''
 +
||@isallday@
 
|}
 
|}
  
 
===Level 3===
 
===Level 3===
 
 
{| class="wikitable"
 
{| class="wikitable"
|+Level 3 Field Names and Variables
+
|+style="text-align:left"|Level 3 Field Names and Variables
!Field Name
+
|-
!Variable
+
!|Field Name
 +
!|Variable
 
|-
 
|-
|'''Associated Parent'''
+
||'''Associated Parent'''
|@linkparent.''fieldname''@
+
||@linkparent.''fieldname''@
 
|-
 
|-
|'''General'''
+
||'''General'''
|Level 3 uses the same variables as Level 2.
+
||Level 3 uses the same variables as Level 2.
 
|}
 
|}
  
 
===Calling a Level 1 Variable at Level 2===
 
===Calling a Level 1 Variable at Level 2===
+
'''@parent.branch@''' or '''@parent.client@''' will be replaced by company name and other fields can be referenced like this:
'''@parent.branch@''' or '''@parent.client@''' will be replaced by company name and other fields can be referenced like this:
+
 
+
* '''@parent.branch.address@'''
* '''@parent.branch.address@'''
 
 
* '''@parent.branch.country@'''
 
* '''@parent.branch.country@'''
* '''@parent.branch.customfield@'''
+
* '''@parent.branch.customfield@'''
* '''@parent.firstname@'''
+
* '''@parent.firstname@'''
* '''@parent.lastname@'''
+
* '''@parent.lastname@'''
* '''@parent.description@'''
+
* '''@parent.description@'''
* '''@parent.status@'''
+
* '''@parent.status@'''
 
* '''@parent.person.fieldname@''' - fieldname will be replaced by the variables listed below for the '''Person''' [[Standard Field]] at Level 1.
 
* '''@parent.person.fieldname@''' - fieldname will be replaced by the variables listed below for the '''Person''' [[Standard Field]] at Level 1.
  
Line 318: Line 344:
  
 
==Contacts/Users==
 
==Contacts/Users==
 
 
{| class="wikitable"
 
{| class="wikitable"
|+Contacts/Users Field Names and Variables
+
|+style="text-align:left"|Contacts/Users Field Names and Variables
!Field Name
+
|-
!Variable
+
!|Field Name
 +
!|Variable
 +
|-
 +
||'''First name'''
 +
||@firstname@
 
|-
 
|-
|'''First name'''
+
||'''Middle name'''
|@firstname@
+
||@middlename@
 
|-
 
|-
|'''Middle name'''
+
||'''Last name'''
|@middlename@
+
||@lastname@
 
|-
 
|-
|'''Last name'''
+
||'''Full name'''
|@lastname@
+
||@fullname@
 
|-
 
|-
|'''Full name'''
+
||'''Phone'''
|@fullname@
+
||@phone@
 
|-
 
|-
|'''Phone'''
+
||'''Phone extension'''
|@phone@
+
||@uphoneext@
 
|-
 
|-
|'''Phone extension'''
+
||'''Company name'''
|@uphoneext@
+
||@company@
 
|-
 
|-
|'''Company name'''
+
||'''Address'''
|@company@
+
||@address@
 
|-
 
|-
|'''Address'''
+
||'''Address 2'''
|@address@
+
||@address2@
 
|-
 
|-
|'''Address 2'''
+
||'''City'''
|@address2@
+
||@city@
 
|-
 
|-
|'''City'''
+
||'''Province'''
|@city@
+
||@province@ - If using abbreviated store values use @province.name@ to get the full name
 
|-
 
|-
|'''Province'''
+
||'''State'''
|@province@
+
||@state@
 
|-
 
|-
|'''State'''
+
||'''Country'''
|@state@
+
||@country@
 
|-
 
|-
|'''Country'''
+
||'''Country Code''' (2 letter abbreviation)
|@country@
+
||@countrycode@
 
|-
 
|-
|'''Postal code'''
+
||'''Postal code'''
|@postalcode@
+
||@postalcode@
 
|-
 
|-
|'''Primary Address'''
+
||'''Primary Address'''
|@primaryaddress@ - used with [[Multiple Address Types]]. See [[Address Book Template]]
+
||@primaryaddress@ - used with [[Multiple Address Types]]. See [[Address Book Template]]
 
|-
 
|-
|'''Address Book'''
+
||'''Address Book'''
|@addressbook@ - used with [[Multiple Address Types]]. See [[Address Book Template]]
+
||@addressbook@ - used with [[Multiple Address Types]]. See [[Address Book Template]]
 
|-
 
|-
|'''Owner'''
+
||'''US Region name from an actual address record'''
|@owner@
+
||@address.region.uscounty.name@
 
|-
 
|-
|'''Last updated'''
+
||'''US Region ID from an actual address record'''
|@modifieddate@
+
||@address.region.uscounty.id@
 
|-
 
|-
|'''Last logged in'''
+
||'''Owner'''
|@lastlogin@
+
||@owner@
 
|-
 
|-
|'''Cost'''
+
||'''Last updated'''
|@cost@
+
||@modifieddate@
 
|-
 
|-
|'''Cost unit'''
+
||'''Last logged in'''
|@costunit@
+
||@lastlogin@
 
|-
 
|-
|'''Type'''
+
||'''Cost'''
|@type@ (returns 'User', 'Local User Administrator' or 'Global User Administrator')
+
||@cost@
 
|-
 
|-
|'''Access Type'''
+
||'''Cost unit'''
|@accesstype@ (returns 'Administration or Portal Interface', 'User Centric or Applicant Interface', 'Web Service User' or 'No Access')
+
||@costunit@
 
|-
 
|-
|'''Access Type ID'''
+
||'''Type'''
|@accesstypeid@ ''0=No Access;1=Administration or Portal Interface;3=User Centric or Applicant Interface;5=Web Service User;''
+
||@type@ (returns 'User', 'Local User Administrator' or 'Global User Administrator')
 
|-
 
|-
|'''Resource name'''
+
||'''Access Type'''
|@resourcename@
+
||@accesstype@ (returns 'Administration or Portal Interface', 'User Centric or Applicant Interface', 'Web Service User' or 'No Access')
 
|-
 
|-
|'''Is contact a resource?'''
+
||'''Access Type ID'''
|@isresource@
+
||@accesstypeid@ ''0=No Access;1=Administration or Portal Interface;3=User Centric or Applicant Interface;5=Web Service User;''
 
|-
 
|-
|'''Prefix'''
+
||'''Resource name'''
|@prefix@
+
||@resourcename@
 
|-
 
|-
|'''Suffix'''
+
||'''Is contact a resource?'''
|@suffix@
+
||@isresource@
 
|-
 
|-
|'''Unique Identifier'''
+
||'''Prefix'''
|@uuid@ This is a system-generated code that is unique to each contact. For example: ''6BCC 98SF EFC6 FFFB 270C 606''
+
||@prefix@
 
|-
 
|-
|'''Language'''
+
||'''Suffix'''
|@langname@ The Language name in the [[Personal Settings]] of the contact (i.e.: ''@me.langname@'' or ''@owner.langname@'')
+
||@suffix@
 
|-
 
|-
|'''Language ID Code'''
+
||'''Unique Identifier'''
|@langid@ The Language selected in the [[Personal Settings]] of the contact (i.e.: ''@me.langid@'' or ''@owner.langid@''). See [[Language|here]] for more information
+
||@uuid@ This is a system-generated code that is unique to each contact. For example: ''6BCC 98SF EFC6 FFFB 270C 606''
 
|-
 
|-
|'''User's Time Zone setting'''
+
||'''Language'''
|@sstimezone@ (can be used to calculate user's relative date/time)
+
||@langname@ The Language name in the [[Personal Settings]] of the contact (i.e.: ''@me.langname@'' or ''@owner.langname@'')
 +
|-
 +
||'''Language ID Code'''
 +
||@langid@ The Language selected in the [[Personal Settings]] of the contact (i.e.: ''@me.langid@'' or ''@owner.langid@''). See [[Language|here]] for more information
 +
|-
 +
||'''User's Time Zone setting'''
 +
||@sstimezone@ (can be used to calculate user's relative date/time)
 
|}
 
|}
  
 
==When calling on Level 1 and Level 2 information from a Level 2 Workflow==
 
==When calling on Level 1 and Level 2 information from a Level 2 Workflow==
 
 
{| class="wikitable"
 
{| class="wikitable"
|+Calling L1 and L2 fields from a L2 Workbflow
+
|+style="text-align:left"|Calling L1 and L2 fields from a L2 Workflow
!Field Name
 
!Variable
 
 
|-
 
|-
|'''level 1 name field'''
+
!|Field Name
|@parent.name@
+
!|Variable
 
|-
 
|-
|'''level 1 status'''
+
||'''level 1 name field'''
|@parent.status@
+
||@parent.name@
 
|-
 
|-
|'''level 1 start date'''
+
||'''level 1 status'''
|@parent.startdate@
+
||@parent.status@
 
|-
 
|-
|'''level 1 end date'''
+
||'''level 1 start date'''
|@parent.enddate@
+
||@parent.startdate@
 
|-
 
|-
|'''level 1 contact'''
+
||'''level 1 end date'''
|@parent.contact@
+
||@parent.enddate@
 
|-
 
|-
|'''level 1 custom fields'''
+
||'''level 1 contact'''
|@parent.customfieldname@
+
||@parent.contact@
 
|-
 
|-
|'''level 2 type field'''
+
||'''level 1 custom fields'''
|@type@
+
||@parent.customfieldname@
 
|-
 
|-
|'''level 2 status field'''
+
||'''level 2 type field'''
|@status@
+
||@type@
 
|-
 
|-
|'''level 2 start date'''
+
||'''level 2 status field'''
|@startdate@
+
||@status@
 
|-
 
|-
|'''level 2 end date'''
+
||'''level 2 start date'''
|@enddate@
+
||@startdate@
 
|-
 
|-
|'''level 2 contact'''
+
||'''level 2 end date'''
|@contact@
+
||@enddate@
 
|-
 
|-
|'''level 2 custom field'''
+
||'''level 2 contact'''
|@customfieldname@
+
||@contact@
 +
|-
 +
||'''level 2 custom field'''
 +
||@customfieldname@
 
|}
 
|}
  
 
==Parent can be Company, Level 1, Opportunity or Leads==
 
==Parent can be Company, Level 1, Opportunity or Leads==
 
<u>'''Company'''</u>
 
  
 
{| class="wikitable"
 
{| class="wikitable"
|+Level 1 Name and Variable List
+
|+style="text-align:left"|Level 1 Name and Variable List
!Name
 
!Variable
 
 
|-
 
|-
|'''Primary Contact'''
+
!|Name
|@primarycontact@
+
!|Variable
 
|-
 
|-
|'''Company Name'''
+
||'''Primary Contact'''
|@name@
+
||@primarycontact@
 
|-
 
|-
|'''Address'''
+
||'''Company Name'''
|@address@
+
||@name@
 
|-
 
|-
|'''Address 2'''
+
||'''Address'''
|@address2@
+
||@address@
 
|-
 
|-
|'''City'''
+
||'''Address 2'''
|@city@
+
||@address2@
 
|-
 
|-
|'''Province'''
+
||'''City'''
|@province@
+
||@city@
|-|'''State'''|@state@|-
 
|'''Postal code'''
 
|@postalcode@
 
 
|-
 
|-
|'''Country'''
+
||'''Province'''
|@country@
+
||@province@ - If using abbreviated store values use @province.name@ to get the full name
 
|-
 
|-
|'''Phone number'''
+
||'''Postal code'''
|@phone@  
+
||@postalcode@
 
|-
 
|-
|'''Fax number'''
+
||'''Country'''
|@fax@  
+
||@country@
 
|-
 
|-
|'''Owner'''
+
||'''Country Code''' (2 letter abbreviation)
|@owner@  
+
||@countrycode@
 
|-
 
|-
|'''Website'''
+
||'''Latitude'''
|@website@  
+
||@lat@
 
|-
 
|-
|'''Custom fields'''
+
||'''Longitude'''
|@customfields@
+
||@lng@
 
|-
 
|-
|'''NAIC Code 1'''
+
||'''Phone number'''
|@naiccode1@
+
||@phone@
 
|-
 
|-
|'''NAIC Code 2'''
+
||'''Fax number'''
|@naiccode2@
+
||@fax@
 
|-
 
|-
|'''Last updated'''
+
||'''Owner'''
|@modifieddate@
+
||@owner@
 
|-
 
|-
|'''Last updated by'''
+
||'''Website'''
|@updatedbyname@
+
||@website@
 
|-
 
|-
|'''Category custom fields'''
+
||'''Custom fields'''
|@Field Name@
+
||@customfields@
 +
|-
 +
||'''NAIC Code 1'''
 +
||@naiccode1@
 +
|-
 +
||'''NAIC Code 2'''
 +
||@naiccode2@
 +
|-
 +
||'''Last updated'''
 +
||@modifieddate@
 +
|-
 +
||'''Last updated by'''
 +
||@updatedbyname@
 +
|-
 +
||'''Category custom fields'''
 +
||@Field Name@
 
|}
 
|}
  
 
==Opportunity, Level 1==
 
==Opportunity, Level 1==
 
 
{| class="wikitable"
 
{| class="wikitable"
|+Opportunity & Level 1
+
|+style="text-align:left"|Opportunity & Level 1
!Field Name
+
|-
!Variable
+
!|Field Name
 +
!|Variable
 +
|-
 +
||'''Branch'''
 +
||@branch@
 
|-
 
|-
|'''Branch'''
+
||'''Close Date'''
|@branch@
+
||@closedate@
 
|-
 
|-
|'''Close Date'''
+
||'''Company field'''
|@closedate@
+
||@company.field@
 
|-
 
|-
|'''Company field'''
+
||'''Contacts'''
|@company.field@
+
||@contact.rolename.field@
 
|-
 
|-
|'''Contacts'''
+
||'''Created Date'''
|@contact.rolename.field@
+
||@createddate@
 
|-
 
|-
|'''Currency'''
+
||'''Currency'''
|@currency@
+
||@currency@
 
|-
 
|-
|'''Customer'''
+
||'''Customer'''
|@client@
+
||@client@
 
|-
 
|-
|'''Description'''
+
||'''Description'''
|@description@
+
||@description@
 
|-
 
|-
|'''End Date'''
+
||'''End Date'''
|@enddate@
+
||@enddate@
|-
 
|'''End Time'''
 
|@hour(fullenddate)@:@minute(fullenddate)@
 
 
|-
 
|-
|'''Folders'''
+
||'''End Time'''
|No variables
+
||@hour(fullenddate)@:@minute(fullenddate)@
 
|-
 
|-
|'''Opportunity Source'''
+
||'''Folders'''
|@leadsource@
+
||No variables
 
|-
 
|-
|'''List Job Questions (with combo boxes)'''
+
||'''Opportunity Source'''
|@jobquestions@ ''Only for opportunities that use the recruiting template''
+
||@leadsource@
 
|-
 
|-
|'''List Job Questions (just questions)'''
+
||'''List Job Questions (with combo boxes)'''
|@jobquestionsr@
+
||@jobquestions@ ''Only for opportunities that use the recruiting template''
 
|-
 
|-
|'''List Job Skills'''
+
||'''List Job Questions (just questions)'''
|@jobskills@
+
||@jobquestionsr@
 
|-
 
|-
|'''Modified Date'''
+
||'''List Job Skills'''
|@modifieddate@
+
||@jobskills@
 
|-
 
|-
|'''Number of filled positions'''
+
||'''Modified Date'''
|@candidatefilled@
+
||@modifieddate@
 
|-
 
|-
|'''Number of open positions'''
+
||'''Number of filled positions'''
|@openpositions@
+
||@candidatefilled@
 
|-
 
|-
|'''Owner'''
+
||'''Number of open positions'''
|@owner@
+
||@openpositions@
 
|-
 
|-
|'''Opportunity Name'''
+
||'''Owner'''
|@name@
+
||@owner@
 
|-
 
|-
|'''Opportunity Type'''
+
||'''Opportunity Name'''
|@type@
+
||@name@
 
|-
 
|-
|'''Probability'''
+
||'''Opportunity Type'''
|@probability@
+
||@type@
 
|-
 
|-
|'''Requirements'''
+
||'''Probability'''
|@requirements@
+
||@probability@
 
|-
 
|-
|'''Revenue'''
+
||'''Requirements'''
|@revenue@
+
||@requirements@
 
|-
 
|-
|'''Start Date'''
+
||'''Revenue'''
|@startdate@
+
||@revenue@
 
|-
 
|-
|'''Start Time'''
+
||'''Start Date'''
|@hour(fullstartdate)@:@minute(fullstartdate)@
+
||@startdate@
 
|-
 
|-
|'''Status'''
+
||'''Start Time'''
|@status@
+
||@hour(fullstartdate)@:@minute(fullstartdate)@
 
|-
 
|-
|'''Template type number'''
+
||'''Status'''
|@templatetype@
+
||@status@
 +
|-
 +
||'''Template type number'''
 +
||@templatetype@
 
|}
 
|}
  
Line 621: Line 667:
 
* '''Activity List''' - Is not displaying information properly, according to Wiki call guide
 
* '''Activity List''' - Is not displaying information properly, according to Wiki call guide
 
* '''Applicants''' - No information on how to call applicants in Wiki -->
 
* '''Applicants''' - No information on how to call applicants in Wiki -->
 
+
==Leads==
==Leads==        
 
 
 
 
{| class="wikitable"
 
{| class="wikitable"
|+Level 1 Field Name and Variable List
+
|+style="text-align:left"|Leads Variable List
!Field Name
+
|-
!Variable
+
!|Field Name
 +
!|Variable
 
|-
 
|-
|'''Status'''
+
||'''Status'''
|@status@
+
||@status@
 
|-
 
|-
|'''Company'''
+
||'''Company'''
|@name@
+
||@name@
 
|-
 
|-
|'''Address'''
+
||'''Address'''
|@address@
+
||@address@
 
|-
 
|-
|'''Address 2'''
+
||'''Address 2'''
|@address2@
+
||@address2@
 
|-
 
|-
|'''City'''
+
||'''City'''
|@city@
+
||@city@
 
|-
 
|-
|'''Province'''
+
||'''Province'''
|@province@
+
||@province@
 
|-
 
|-
|'''Country'''
+
||'''Country'''
|@country@
+
||@country@
 
|-
 
|-
|'''Postal'''
+
||'''Postal'''
|@postalcode@
+
||@postalcode@
 
|-
 
|-
|'''Phone'''
+
||'''Phone'''
|@phone@
+
||@phone@
 
|-
 
|-
|'''Fax'''
+
||'''Fax'''
|@fax@
+
||@fax@
 
|-
 
|-
|'''Web Site'''
+
||'''Web Site'''
|@website@
+
||@website@
 
|-
 
|-
|'''First Name'''
+
||'''First Name'''
|@firstname@
+
||@firstname@
 
|-
 
|-
|'''Last Name'''
+
||'''Last Name'''
|@lastname@
+
||@lastname@
 
|-
 
|-
|'''Prefix'''
+
||'''Prefix'''
|@prefix@
+
||@prefix@
 
|-
 
|-
|'''Suffix'''
+
||'''Suffix'''
|@suffix@
+
||@suffix@
 
|-
 
|-
|'''Title'''
+
||'''Title'''
|@title@
+
||@title@
 
|-
 
|-
|'''(Contact) Phone'''
+
||'''(Contact) Phone'''
|@contactphone@
+
||@contactphone@
 
|-
 
|-
|'''Email'''
+
||'''Email'''
|@email@
+
||@email@
 
|-
 
|-
|'''Description'''
+
||'''Description'''
|@description@
+
||@description@
 
|-
 
|-
|'''Date Added'''
+
||'''Date Added'''
|@dat_added@
+
||@dat_added@
 
|}
 
|}
  
Line 696: Line 741:
 
<!--* '''Ext.''' - Don’t know-->
 
<!--* '''Ext.''' - Don’t know-->
 
<!--* '''Owner/Owner.field''' - Don’t know-->
 
<!--* '''Owner/Owner.field''' - Don’t know-->
 
 
==Email Broadcast==
 
==Email Broadcast==
 
 
{| class="wikitable"
 
{| class="wikitable"
|+Email Broadcast Variable List
+
|+style="text-align:left"|Email Broadcast Variable List
!Field Name
+
|-
!Variable
+
!|Field Name
 +
!|Variable
 
|-
 
|-
|'''@rolename.customfield@'''
+
||'''@rolename.customfield@'''
|
+
||
 
|-
 
|-
|'''@randompassword@'''
+
||'''@randompassword@'''
|Generates a new password when sending to user
+
||Generates a new password when sending to user
 
|-
 
|-
|'''@password@'''
+
||'''@password@'''
|Generates a new password when sending to user
+
||Generates a new password when sending to user
 
|-
 
|-
|'''@email@'''
+
||'''@email@'''
|Sends the username/E-mail
+
||Sends the username/E-mail
 
|-
 
|-
|'''@userid@'''
+
||'''@userid@'''
|Sends the user id
+
||Sends the user id
 
|-
 
|-
|'''@sender.''fieldname''@'''
+
||'''@sender.''fieldname''@'''
|manner of referencing details of the user who is sending the email
+
||manner of referencing details of the user who is sending the email
 
|}
 
|}
:'''Note:'''
+
: '''Note:'''
 
:* examples: ''@sender.company.address@'' will return the address of the sender's company.
 
:* examples: ''@sender.company.address@'' will return the address of the sender's company.
 
:* Includes '''All standard contact fields'''
 
:* Includes '''All standard contact fields'''
Line 728: Line 772:
  
 
==Contacts==
 
==Contacts==
 
 
{| class="wikitable"
 
{| class="wikitable"
|+Level 1 Field Name and Variable List
+
|+style="text-align:left"|Level 1 Field Name and Variable List
!Field Name
 
!Variable
 
 
|-
 
|-
|'''First name of contact or lead'''
+
!|Field Name
|@firstname@
+
!|Variable
 
|-
 
|-
|'''Last name of contact or lead'''
+
||'''First name of contact or lead'''
|@lastname@
+
||@firstname@
 
|-
 
|-
|'''Full name of contact or lead'''
+
||'''Last name of contact or lead'''
|@fullname@
+
||@lastname@
 
|-
 
|-
|'''Title of contact or lead'''
+
||'''Full name of contact or lead'''
|@title@
+
||@fullname@
 
|-
 
|-
|'''Email address of contact or lead'''
+
||'''Title of contact or lead'''
|@email@
+
||@title@
 
|-
 
|-
|'''Phone number of contact or lead'''
+
||'''Email address of contact or lead'''
|@phone@
+
||@email@
 
|-
 
|-
|'''Address of contact or lead'''
+
||'''Phone number of contact or lead'''
|@address@
+
||@phone@
 
|-
 
|-
|'''City of contact or lead'''
+
||'''Address of contact or lead'''
|@city@
+
||@address@
 
|-
 
|-
|'''State/Province of contact or lead'''
+
||'''City of contact or lead'''
|@state@
+
||@city@
 
|-
 
|-
|'''Country of contact or lead'''
+
||'''State/Province of contact or lead'''
|@country@
+
||@state@
 
|-
 
|-
|'''Zip/Postal code of contact or lead'''
+
||'''Country of contact or lead'''
|@postalcode@
+
||@country@
 
|-
 
|-
|'''Company name of contact or lead'''
+
||'''Country Code of contact or lead'''
|@companyname@
+
||@countrycode@
 
|-
 
|-
|'''Contact address - not available for lead'''
+
||'''Zip/Postal code of contact or lead'''
|@caddress@
+
||@postalcode@
 
|-
 
|-
|'''Contact city - not available for lead'''
+
||'''Company name of contact or lead'''
|@ccity@
+
||@companyname@
 
|-
 
|-
|'''Contact state/province - not available for lead'''
+
||'''Contact address - not available for lead'''
|@cstate@
+
||@caddress@
 
|-
 
|-
|'''Contact country - not available for lead'''
+
||'''Contact city - not available for lead'''
|@ccountry@
+
||@ccity@
 
|-
 
|-
|'''Contact postal code - not available for lead'''
+
||'''Contact state/province - not available for lead'''
|@cpostalcode@
+
||@cstate@
 
|-
 
|-
|'''Contact fax - not available for lead'''
+
||'''Contact country - not available for lead'''
|@cfax@
+
||@ccountry@
 
|-
 
|-
|'''Web site for lead - not available for contact'''
+
||'''Contact postal code - not available for lead'''
|@cwebsite@
+
||@cpostalcode@
 
|-
 
|-
|'''First name of the sender'''
+
||'''Contact fax - not available for lead'''
|@senderfirstname@
+
||@cfax@
 
|-
 
|-
|'''Last name of the sender'''
+
||'''Web site for lead - not available for contact'''
|@senderlastname@
+
||@cwebsite@
 
|-
 
|-
|'''Name of sender company'''
+
||'''First name of the sender'''
|@sendercompany@
+
||@senderfirstname@
 
|-
 
|-
|'''E-mail of sender'''
+
||'''Last name of the sender'''
|@senderemail@
+
||@senderlastname@
 
|-
 
|-
|'''Phone number of sender'''
+
||'''Name of sender company'''
|@senderphone@
+
||@sendercompany@
 
|-
 
|-
|'''Title of sender'''
+
||'''E-mail of sender'''
|@sendertitle@
+
||@senderemail@
 
|-
 
|-
|'''Current date and time format selected by the user in their personal settings ? long date format'''
+
||'''Phone number of sender'''
|@now@
+
||@senderphone@
 
|-
 
|-
|'''Description field content'''
+
||'''Title of sender'''
|@objectdescription@
+
||@sendertitle@
 +
|-
 +
||'''Current date and time format selected by the user in their personal settings ? long date format'''
 +
||@now@
 +
|-
 +
||'''Description field content'''
 +
||@objectdescription@
 
|}
 
|}
  
 
==Roles==
 
==Roles==
 +
'''@rolelist@''' provides a list of [[roleid]]s corresponding to the roles the user belongs to.
  
'''@rolelist@''' provides a list of [[roleid]]s corresponding to the roles the user belongs to.
 
 
  @me.rolelist@
 
  @me.rolelist@
  
'''@primaryroleid@''' provides the id for the user's primary role. Do not use the prefix '@me.'.  
+
'''@primaryroleid@''' provides the id for the user's primary role. Do not use the prefix '@me.'.
 +
 
 
  @primaryroleid@
 
  @primaryroleid@
  
==Company Categories==
+
==Organization Categories==
'''@catlist@''' lists the roleid of each Company Category the company (Account/Organization) belongs to.
+
'''@catlist@''' lists the roleid of each Organization Category the company (Account/Organization) belongs to.
 +
 
 
  @me.parent.catlist@
 
  @me.parent.catlist@
  
 
==Custom Fields attached to Roles==
 
==Custom Fields attached to Roles==
 
 
'''@rolename.customfieldname@'''
 
'''@rolename.customfieldname@'''
  
 
==[[Using Variables in the Report Builder|Variables available for Report criteria]]==
 
==[[Using Variables in the Report Builder|Variables available for Report criteria]]==
 
 
* '''@userid@'''
 
* '''@userid@'''
* '''@companyid@'''  
+
* '''@companyid@'''
 
* '''@objectid@'''
 
* '''@objectid@'''
  
Line 842: Line 889:
  
 
==Using Variables in the Report Template Header==
 
==Using Variables in the Report Template Header==
 
 
* '''@args[1]@, @args[2]@''' - used within Report Template Header to obtain the criteria entered by users.
 
* '''@args[1]@, @args[2]@''' - used within Report Template Header to obtain the criteria entered by users.
 
* '''@runtime@''' - used within Report Template Header to obtain date/time report was run.
 
* '''@runtime@''' - used within Report Template Header to obtain date/time report was run.
  
 
==Applicant Tracking Email Template Variables==
 
==Applicant Tracking Email Template Variables==
 
 
The following variables are used to create email templates:
 
The following variables are used to create email templates:
  
Line 853: Line 898:
  
 
{| class="wikitable"
 
{| class="wikitable"
|+Job Fields Variable List
+
|+style="text-align:left"|Job Fields Variable List
!Field Name
 
!Variable
 
 
|-
 
|-
|@job.name@
+
!|Field Name
|'''Job name'''
+
!|Variable
 
|-
 
|-
|@job.client@  
+
||@job.name@
|'''Associated name of the client'''
+
||'''Job name'''
 
|-
 
|-
|@job.stage@
+
||@job.client@
|'''Status of the job'''
+
||'''Associated name of the client'''
 
|-
 
|-
|@job.closedate@
+
||@job.stage@
|'''Hiring close date of the job'''
+
||'''Status of the job'''
 
|-
 
|-
|@job.manager@
+
||@job.closedate@
|'''Hiring Manger – set on the job page'''
+
||'''Hiring close date of the job'''
 
|-
 
|-
|@job.description@
+
||@job.manager@
|'''Job description'''
+
||'''Hiring Manger – set on the job page'''
 
|-
 
|-
|@job.type@
+
||@job.description@
|'''Template name for this job'''
+
||'''Job description'''
 
|-
 
|-
|@job.startdate@
+
||@job.type@
|'''Job start date'''
+
||'''Template name for this job'''
 
|-
 
|-
|@job.enddate@
+
||@job.startdate@
|'''Job end date – contract only'''
+
||'''Job start date'''
 
|-
 
|-
|@job.requirements@
+
||@job.enddate@
|'''Job requirements'''
+
||'''Job end date – contract only'''
 
|-
 
|-
|@job.openpositions@
+
||@job.requirements@
|'''Number of open positions'''
+
||'''Job requirements'''
 
|-
 
|-
|@job.applicantfilled@
+
||@job.openpositions@
|'''Number of hired applicants'''
+
||'''Number of open positions'''
 
|-
 
|-
|@job.branch@
+
||@job.applicantfilled@
|'''Internal branch name associated with this job'''
+
||'''Number of hired applicants'''
 
|-
 
|-
|@job.branch.address@
+
||@job.branch@
|'''Internal branch address 1'''
+
||'''Internal branch name associated with this job'''
 
|-
 
|-
|@job.branch.address2@
+
||@job.branch.address@
|'''Internal branch address 2'''
+
||'''Internal branch address 1'''
 
|-
 
|-
|@job.branch.city@
+
||@job.branch.address2@
|'''Internal branch city'''
+
||'''Internal branch address 2'''
 
|-
 
|-
|@job.branch.state@
+
||@job.branch.city@
|'''Internal branch state/province'''
+
||'''Internal branch city'''
 
|-
 
|-
|@job.branch.phone@
+
||@job.branch.state@
|'''Internal branch phone number'''
+
||'''Internal branch state/province'''
 
|-
 
|-
|@job.branch.country@
+
||@job.branch.phone@
|'''Internal branch country'''
+
||'''Internal branch phone number'''
 
|-
 
|-
|@job.branch.postalcode@
+
||@job.branch.country@
|'''Internal branch zip/postal code'''
+
||'''Internal branch country'''
 
|-
 
|-
|@job.branch.website@
+
||@job.branch.postalcode@
|'''Internal branch web site address'''
+
||'''Internal branch zip/postal code'''
 
|-
 
|-
|@job.client@
+
||@job.branch.website@
|'''Client name'''
+
||'''Internal branch web site address'''
 
|-
 
|-
|@job.client.address@
+
||@job.client@
|'''Client address one'''
+
||'''Client name'''
 
|-
 
|-
|@job.client.address2@
+
||@job.client.address@
|'''Client address two'''
+
||'''Client address one'''
 
|-
 
|-
|@job.client.city@  
+
||@job.client.address2@
|'''Client city'''
+
||'''Client address two'''
 
|-
 
|-
|@job.client.state@
+
||@job.client.city@
|'''Client state/province'''
+
||'''Client city'''
 
|-
 
|-
|@job.client.phone@
+
||@job.client.state@
|'''Client phone number'''
+
||'''Client state/province'''
 
|-
 
|-
|@job.client.country@
+
||@job.client.phone@
|'''Client country'''
+
||'''Client phone number'''
 
|-
 
|-
|@job.client.postalcode@
+
||@job.client.country@
|'''Client zip/postal code'''
+
||'''Client country'''
 
|-
 
|-
|@job.client.website@
+
||@job.client.postalcode@
|'''Client web site'''
+
||'''Client zip/postal code'''
 
|-
 
|-
|@job.custom@
+
||@job.client.website@
|'''Custom field associated with the job template. For example @job.additionalinfo@'''
+
||'''Client web site'''
 +
|-
 +
||@job.custom@
 +
||'''Custom field associated with the job template. For example @job.additionalinfo@'''
 
|}
 
|}
  
 
==Applicant Fields==
 
==Applicant Fields==
 
 
{| class="wikitable"
 
{| class="wikitable"
|+Applicant Fields Variable List
+
|+style="text-align:left"|Applicant Fields Variable List
!Field Name
+
|-
!Variable
+
!|Field Name
 +
!|Variable
 
|-
 
|-
|@applicant.firstname@
+
||@applicant.firstname@
|'''First name of the applicant'''
+
||'''First name of the applicant'''
 
|-
 
|-
|@applicant.lastname@
+
||@applicant.lastname@
|'''Last name of applicant'''
+
||'''Last name of applicant'''
 
|-
 
|-
|@applicant.title@
+
||@applicant.title@
|'''Title of applicant'''
+
||'''Title of applicant'''
 
|-
 
|-
|@applicant.email@
+
||@applicant.email@
|'''Email address of applicant'''
+
||'''Email address of applicant'''
 
|-
 
|-
|@applicant.phone@
+
||@applicant.phone@
|'''Phone number of applicant'''
+
||'''Phone number of applicant'''
 
|-
 
|-
|@applicant.address@
+
||@applicant.address@
|'''Address of applicant'''
+
||'''Address of applicant'''
 
|-
 
|-
|@applicant.city@
+
||@applicant.city@
|'''City of applicant'''
+
||'''City of applicant'''
 
|-
 
|-
|@applicant.state@
+
||@applicant.state@
|'''State/Province of applicant'''
+
||'''State/Province of applicant'''
 
|-
 
|-
|@applicant.country@
+
||@applicant.country@
|'''Country of applicant'''
+
||'''Country of applicant'''
 
|-
 
|-
|@applicant.postalcode@
+
||@applicant.countrycode@
|'''Zip/Postal applicant'''
+
||'''Country code (2 letter abbreviation) of applicant'''
 +
|-
 +
||@applicant.postalcode@
 +
||'''Zip/Postal applicant'''
 
|}
 
|}
  
 
==Hiring Manager Fields==
 
==Hiring Manager Fields==
 
 
{| class="wikitable"
 
{| class="wikitable"
|+Level 1 Field Name and Variable List
+
|+style="text-align:left"|Level 1 Field Name and Variable List
!Field Name
 
!Variable
 
 
|-
 
|-
|@hiring manager.firstname@
+
!|Field Name
|'''First name of the hiring manager'''
+
!|Variable
 
|-
 
|-
|@hiring manager.lastname@
+
||@hiring manager.firstname@
|'''Last name of the hiring manager'''
+
||'''First name of the hiring manager'''
 
|-
 
|-
|@hiring manager.title@
+
||@hiring manager.lastname@
|'''Title of the hiring manager'''
+
||'''Last name of the hiring manager'''
 
|-
 
|-
|@hiring manager.email@
+
||@hiring manager.title@
|'''Email address of the hiring manager'''
+
||'''Title of the hiring manager'''
 
|-
 
|-
|@hiring manager.phone@
+
||@hiring manager.email@
|'''Phone number of the hiring manager'''
+
||'''Email address of the hiring manager'''
 
|-
 
|-
|@hiring manager.address@
+
||@hiring manager.phone@
|'''Address of the hiring manager'''
+
||'''Phone number of the hiring manager'''
 +
|-
 +
||@hiring manager.address@
 +
||'''Address of the hiring manager'''
  
 
|-
 
|-
|@hiring manager.city@
+
||@hiring manager.city@
|'''City of the hiring manager'''
+
||'''City of the hiring manager'''
 +
|-
 +
||@hiring manager.state@
 +
||'''State/Province of the hiring manager'''
 
|-
 
|-
|@hiring manager.state@
+
||@hiring manager.country@
|'''State/Province of the hiring manager'''
+
||'''Country of the hiring manager'''
 
|-
 
|-
|@hiring manager.country@
+
||@hiring manager.countrycode@
|'''Country of the hiring manager'''
+
||'''Country Code (2 letter abbreviation) of the hiring manager'''
 
|-
 
|-
|@hiring manager.postalcode@
+
||@hiring manager.postalcode@
|'''Zip/Postal code of the hiring manager'''
+
||'''Zip/Postal code of the hiring manager'''
 
|}
 
|}
  
 
==Sender Fields==
 
==Sender Fields==
 
 
{| class="wikitable"
 
{| class="wikitable"
|+Sender Fields Variable List
+
|+style="text-align:left"|Sender Fields Variable List
!Field Name
 
!Variable
 
 
|-
 
|-
|@senderfirstname@
+
!|Field Name
|'''First name of the sender'''
+
!|Variable
 
|-
 
|-
|@senderlastname@
+
||@senderfirstname@
|'''Last name of the sender'''
+
||'''First name of the sender'''
 
|-
 
|-
|@sendercompany@
+
||@senderlastname@
|'''Name of sender company'''
+
||'''Last name of the sender'''
 
|-
 
|-
|@senderemail@
+
||@sendercompany@
|'''Email address of sender'''
+
||'''Name of sender company'''
 
|-
 
|-
|@senderphone@
+
||@senderemail@
|'''Phone number of sender'''
+
||'''Email address of sender'''
 
|-
 
|-
|@sendertitle@
+
||@senderphone@
|'''Title of sender'''
+
||'''Phone number of sender'''
 
|-
 
|-
|@now@
+
||@sendertitle@
|'''Current date and time format selected by the user in their personal settings - long date format'''.
+
||'''Title of sender'''
 +
|-
 +
||@now@
 +
||'''Current date and time format selected by the user in their personal settings - long date format'''.
 
|}
 
|}
  
 +
In addition you can also refer to fields from the sender such as custom fields and company details by using '''@sender.xxxx@''' <br />
 +
These variables can be used within [[:Category:Email|Email]] and [[Workflow]] messages.
  
In addition you can also refer to fields from the sender such as custom fields and company details by using '''@sender.xxxx@''' <br>
 
These variables can be used within [[:Category:Email|Email]] and [[Workflow]] messages.
 
  
  
 
{| class="wikitable"
 
{| class="wikitable"
!Field Name
 
!Variable
 
 
|-
 
|-
|@sender.address@
+
!|Field Name
|'''Address of the sender'''
+
!|Variable
 
|-
 
|-
|@sender.company.name@
+
||@sender.address@
|'''Name of the company the sender is associated with'''
+
||'''Address of the sender'''
 
|-
 
|-
|@sender.(custom field name)@
+
||@sender.company.name@
|'''Refers to a custom field from the sender's profile'''
+
||'''Name of the company the sender is associated with'''
 +
|-
 +
||@sender.(custom field name)@
 +
||'''Refers to a custom field from the sender's profile'''
 
|}
 
|}
  
== Workflow Specific Variables ==
+
==Workflow Specific Variables==
 
 
 
The following variables can only be used in messages associated with workflows:
 
The following variables can only be used in messages associated with workflows:
* @objectname@ - Name of the object in the workflow.  This could be a file name, user name, company name, or an application name.
 
* @originatorname@ - The name of the person that originated the workflow. For example, this value could be the person that added a file to a workflow-enabled SmartFolder, or the name of a person that created a new person record.
 
* @originatoremail@ - E-mail address of originator.
 
* @originatorphone@ - Phone number of originator.
 
  
== Other Variables ==
+
{| class="wikitable"
 +
|+style="text-align:left"|Workflow Specific Variables List
 +
|-
 +
!|Field Name
 +
!|Variable
 +
|-
 +
||'''@objectname@'''
 +
||Name of the object in the workflow. This could be a file name, user name, company name, or an application name.
 +
|-
 +
||'''@originatorname@'''
 +
||The name of the person that originated the workflow. For example, this value could be the person that added a file to a workflow-enabled SmartFolder, or the name of a person that created a new person record.
 +
|-
 +
||'''@originatoremail@'''
 +
||E-mail address of originator.
 +
|-
 +
||'''@originatorphone@'''
 +
||Phone number of originator.
 +
|}
  
* @url@ - The URL to the company alias for SmartSimple.  For example: XXX.smartsimple.com – where XXX is the alias created by that company using the Company Setting page. If you wish to display the URL as a link you should type either: '''http://''' or '''https://''' in front of the reference in the instant message or e-mail template.  For example: <nowiki>https://@url@</nowiki>
+
{{Template:Signority Variables}}
  
* @parentlist@ - The full SmartSimple path to the object.
+
==Other Variables==
 
+
{| class="wikitable"
* @apptype@ - Will return the [[Determining the applicationid|application ID]] within the context of a given [[UTA]].
+
|+style="text-align:left"|Level 1 Field Name and Variable List
 +
|-
 +
!|Field Name
 +
!|Variable
 +
|-
 +
||'''@url@'''
 +
||The URL to the company alias for SmartSimple. For example: XXX.smartsimple.com – where XXX is the alias created by that company using the Company Setting page. If you wish to display the URL as a link you should type either: '''http://''' or '''https://''' in front of the reference in the instant message or e-mail template. For example: <nowiki>https://@url@</nowiki>
 +
|-
 +
||'''@parentlist@'''
 +
||The full SmartSimple path to the object.
 +
|-
 +
||'''@apptype@'''
 +
||Will return the [[Determining the applicationid|application ID]] within the context of a given [[UTA]].
 +
|}
  
 
<!--===Spreadsheet Custom Field===
 
<!--===Spreadsheet Custom Field===
Line 1,108: Line 1,186:
 
===Select One - User Group Custom Field===
 
===Select One - User Group Custom Field===
 
The details of the members of a group stored within a [[Select One - User Group]] custom field can be referenced using the following syntax:
 
The details of the members of a group stored within a [[Select One - User Group]] custom field can be referenced using the following syntax:
:<font size="3">'''[#(?object=group::id=@''fieldname''@) ... #]'''</font>
 
  
 +
: <span style="font-size: medium;">'''[#(?object=group::id=@''fieldname''@) ... #]'''</span>
 
'''Where:'''
 
'''Where:'''
 +
 
* ''fieldname'' is the name of the '''Select One - User Group''' field.
 
* ''fieldname'' is the name of the '''Select One - User Group''' field.
 
* Replace "..." with the contact [[variables]] you wish to display. ''i.e. ~lastname~
 
* Replace "..." with the contact [[variables]] you wish to display. ''i.e. ~lastname~

Revision as of 10:21, 17 March 2023

System Variables

This refers to System Variables defined on the Global Settings page

  • @system.customfieldname@

System Library Variables

This refers to System Library Variables defined on the Global Settings page

  • @system.library.variable name@

Note: Library variables are available in all instances but can only be created and edited by SmartSimple.

System-Wide Variables

@currentdate@

  • Inserts the current date and time
  • This can be used in most areas where variables are called

Web Page View Variables

@now@

  • Inserts the current system date

Local Time Variable

@localhour(fullstartdate)@

  • Adding the word local before the variable displays the hour based on the system time zone and not default Eastern time. The same can be used for minutes and for am/pm.

Universal Tracking Application Variables

Level 1

Level 1 Field Name and Variable List
Field Name Variable
level 1 name field @name@
level 1 type field @type@
level 1 status field @status@
level 1 start date @startdate@
level 1 end date @enddate@
level 1 contact @contact@
level 1 custom field @customfieldname@
Accounts No variables
Activity List No variables
Application Name @name@
Application Template Type @type@
Application Template Type Caption @typecaption@
Application Template Type Language @type_lang@
Archived @archived@
Branch @branch@
Branch ID @branchid@
Close Date @closedate@
Contacts No variables
Currency Name @currencyname@
Currency Code @currencycode@
Exchange Currency  Name @excurrencyname@
Exchange Currency Code @excurrencycode@
Currency Exchange Rate @exrate@
Customer @client@
Description @description@
End Date @enddate@
End Time @hour(fullenddate)@:@minute(fullenddate)@
Folders No variables
Modified By @modifiedby@ (username); @modifiedbyid@ (userid)
Modified Date @modifieddate@
Owner (full name) @owner@
Owner (full name - Consumer/Provider reference) @ownername@
Owner (userid) @ownerid@
Person (full name) @person@
Person (userid) @person.userid@
Probability @probability@
Requirement @requirements@
Revenue @revenue@
Revenue @revenue.value@ (unformatted number without comma separators)
Start Date @startdate@
Start Time @hour(fullstartdate)@:@minute(fullstartdate)@
Status @status@
Status ID @statusid@
Status Caption @statuscaption@
Status Language @status_lang@
Status Name @statusname@
Workflow No variables

Level 2

Level 2 Field Names and Variables List
Field Name Variable
Activity Type @type@
Activity Type Caption @typecaption@
Activity Type ID @typeid@
Amount @eamount@
Assigned Links No variables
Assigned People @assigned@
Contact Links No variables
Contact People @contact@
Contact User ID @contact.userid@ -- Returns one only, even with multiple contacts assigned
Description @description@
Duration @span@
End Date @enddate@
End Hour (0-23) @endhour@
End Hour (1-12) @endh@
End Hour AM or PM @endampm@
End Minute @endminute@
End Time @endhour@:@endminute@
Event ID @eventid@
Follow-up Days No variables
Follow-up Sent No variables
Follow-up Type No variables
Location @location@
Object ID (Parent system ID) @objectid@
Object Type @objecttype@
Owner @owner@
Owner ID @eownerid@
Parent Name @parent.name@
Reminder Days No variables
Reminder Sent No variables
Reminder Type No variables
Root Company ID @rootcompanyid@
Start Date @startdate@
Start Hour (0-23) @starthour@
Start Hour (1-12) @starth@
Start Hour AM or PM @startampm@
Start Minute @startminute@
Start Time @starthour@:@startminute@
Status @status@
Status Caption @statuscaption@
Subject @subject@
Updated By @updatedby@ -- Displays system ID, not name
Updated By Name @updatedbyname@ -- Displays the name
Whole Day Event @isallday@

Level 3

Level 3 Field Names and Variables
Field Name Variable
Associated Parent @linkparent.fieldname@
General Level 3 uses the same variables as Level 2.

Calling a Level 1 Variable at Level 2

@parent.branch@ or @parent.client@ will be replaced by company name and other fields can be referenced like this:

  • @parent.branch.address@
  • @parent.branch.country@
  • @parent.branch.customfield@
  • @parent.firstname@
  • @parent.lastname@
  • @parent.description@
  • @parent.status@
  • @parent.person.fieldname@ - fieldname will be replaced by the variables listed below for the Person Standard Field at Level 1.

whatever fields available for company object.

Contacts/Users

Contacts/Users Field Names and Variables
Field Name Variable
First name @firstname@
Middle name @middlename@
Last name @lastname@
Full name @fullname@
Phone @phone@
Phone extension @uphoneext@
Company name @company@
Address @address@
Address 2 @address2@
City @city@
Province @province@ - If using abbreviated store values use @province.name@ to get the full name
State @state@
Country @country@
Country Code (2 letter abbreviation) @countrycode@
Postal code @postalcode@
Primary Address @primaryaddress@ - used with Multiple Address Types. See Address Book Template
Address Book @addressbook@ - used with Multiple Address Types. See Address Book Template
US Region name from an actual address record @address.region.uscounty.name@
US Region ID from an actual address record @address.region.uscounty.id@
Owner @owner@
Last updated @modifieddate@
Last logged in @lastlogin@
Cost @cost@
Cost unit @costunit@
Type @type@ (returns 'User', 'Local User Administrator' or 'Global User Administrator')
Access Type @accesstype@ (returns 'Administration or Portal Interface', 'User Centric or Applicant Interface', 'Web Service User' or 'No Access')
Access Type ID @accesstypeid@ 0=No Access;1=Administration or Portal Interface;3=User Centric or Applicant Interface;5=Web Service User;
Resource name @resourcename@
Is contact a resource? @isresource@
Prefix @prefix@
Suffix @suffix@
Unique Identifier @uuid@ This is a system-generated code that is unique to each contact. For example: 6BCC 98SF EFC6 FFFB 270C 606
Language @langname@ The Language name in the Personal Settings of the contact (i.e.: @me.langname@ or @owner.langname@)
Language ID Code @langid@ The Language selected in the Personal Settings of the contact (i.e.: @me.langid@ or @owner.langid@). See here for more information
User's Time Zone setting @sstimezone@ (can be used to calculate user's relative date/time)

When calling on Level 1 and Level 2 information from a Level 2 Workflow

Calling L1 and L2 fields from a L2 Workflow
Field Name Variable
level 1 name field @parent.name@
level 1 status @parent.status@
level 1 start date @parent.startdate@
level 1 end date @parent.enddate@
level 1 contact @parent.contact@
level 1 custom fields @parent.customfieldname@
level 2 type field @type@
level 2 status field @status@
level 2 start date @startdate@
level 2 end date @enddate@
level 2 contact @contact@
level 2 custom field @customfieldname@

Parent can be Company, Level 1, Opportunity or Leads

Level 1 Name and Variable List
Name Variable
Primary Contact @primarycontact@
Company Name @name@
Address @address@
Address 2 @address2@
City @city@
Province @province@ - If using abbreviated store values use @province.name@ to get the full name
Postal code @postalcode@
Country @country@
Country Code (2 letter abbreviation) @countrycode@
Latitude @lat@
Longitude @lng@
Phone number @phone@
Fax number @fax@
Owner @owner@
Website @website@
Custom fields @customfields@
NAIC Code 1 @naiccode1@
NAIC Code 2 @naiccode2@
Last updated @modifieddate@
Last updated by @updatedbyname@
Category custom fields @Field Name@

Opportunity, Level 1

Opportunity & Level 1
Field Name Variable
Branch @branch@
Close Date @closedate@
Company field @company.field@
Contacts @contact.rolename.field@
Created Date @createddate@
Currency @currency@
Customer @client@
Description @description@
End Date @enddate@
End Time @hour(fullenddate)@:@minute(fullenddate)@
Folders No variables
Opportunity Source @leadsource@
List Job Questions (with combo boxes) @jobquestions@ Only for opportunities that use the recruiting template
List Job Questions (just questions) @jobquestionsr@
List Job Skills @jobskills@
Modified Date @modifieddate@
Number of filled positions @candidatefilled@
Number of open positions @openpositions@
Owner @owner@
Opportunity Name @name@
Opportunity Type @type@
Probability @probability@
Requirements @requirements@
Revenue @revenue@
Start Date @startdate@
Start Time @hour(fullstartdate)@:@minute(fullstartdate)@
Status @status@
Template type number @templatetype@

Leads

Leads Variable List
Field Name Variable
Status @status@
Company @name@
Address @address@
Address 2 @address2@
City @city@
Province @province@
Country @country@
Postal @postalcode@
Phone @phone@
Fax @fax@
Web Site @website@
First Name @firstname@
Last Name @lastname@
Prefix @prefix@
Suffix @suffix@
Title @title@
(Contact) Phone @contactphone@
Email @email@
Description @description@
Date Added @dat_added@

Email Broadcast

Email Broadcast Variable List
Field Name Variable
@rolename.customfield@
@randompassword@ Generates a new password when sending to user
@password@ Generates a new password when sending to user
@email@ Sends the username/E-mail
@userid@ Sends the user id
@sender.fieldname@ manner of referencing details of the user who is sending the email
Note:
  • examples: @sender.company.address@ will return the address of the sender's company.
  • Includes All standard contact fields
  • Includes All standard company fields

Contacts

Level 1 Field Name and Variable List
Field Name Variable
First name of contact or lead @firstname@
Last name of contact or lead @lastname@
Full name of contact or lead @fullname@
Title of contact or lead @title@
Email address of contact or lead @email@
Phone number of contact or lead @phone@
Address of contact or lead @address@
City of contact or lead @city@
State/Province of contact or lead @state@
Country of contact or lead @country@
Country Code of contact or lead @countrycode@
Zip/Postal code of contact or lead @postalcode@
Company name of contact or lead @companyname@
Contact address - not available for lead @caddress@
Contact city - not available for lead @ccity@
Contact state/province - not available for lead @cstate@
Contact country - not available for lead @ccountry@
Contact postal code - not available for lead @cpostalcode@
Contact fax - not available for lead @cfax@
Web site for lead - not available for contact @cwebsite@
First name of the sender @senderfirstname@
Last name of the sender @senderlastname@
Name of sender company @sendercompany@
E-mail of sender @senderemail@
Phone number of sender @senderphone@
Title of sender @sendertitle@
Current date and time format selected by the user in their personal settings ? long date format @now@
Description field content @objectdescription@

Roles

@rolelist@ provides a list of roleids corresponding to the roles the user belongs to.

@me.rolelist@

@primaryroleid@ provides the id for the user's primary role. Do not use the prefix '@me.'.

@primaryroleid@

Organization Categories

@catlist@ lists the roleid of each Organization Category the company (Account/Organization) belongs to.

@me.parent.catlist@

Custom Fields attached to Roles

@rolename.customfieldname@

Variables available for Report criteria

  • @userid@
  • @companyid@
  • @objectid@

The following variable is used to report on data that is on records in a sub-company @company.childid(x)@ where x is index of children ordered by name (1,2,3,4,5,6....n)

Using Variables in the Report Template Header

  • @args[1]@, @args[2]@ - used within Report Template Header to obtain the criteria entered by users.
  • @runtime@ - used within Report Template Header to obtain date/time report was run.

Applicant Tracking Email Template Variables

The following variables are used to create email templates:

Job Fields

Job Fields Variable List
Field Name Variable
@job.name@ Job name
@job.client@ Associated name of the client
@job.stage@ Status of the job
@job.closedate@ Hiring close date of the job
@job.manager@ Hiring Manger – set on the job page
@job.description@ Job description
@job.type@ Template name for this job
@job.startdate@ Job start date
@job.enddate@ Job end date – contract only
@job.requirements@ Job requirements
@job.openpositions@ Number of open positions
@job.applicantfilled@ Number of hired applicants
@job.branch@ Internal branch name associated with this job
@job.branch.address@ Internal branch address 1
@job.branch.address2@ Internal branch address 2
@job.branch.city@ Internal branch city
@job.branch.state@ Internal branch state/province
@job.branch.phone@ Internal branch phone number
@job.branch.country@ Internal branch country
@job.branch.postalcode@ Internal branch zip/postal code
@job.branch.website@ Internal branch web site address
@job.client@ Client name
@job.client.address@ Client address one
@job.client.address2@ Client address two
@job.client.city@ Client city
@job.client.state@ Client state/province
@job.client.phone@ Client phone number
@job.client.country@ Client country
@job.client.postalcode@ Client zip/postal code
@job.client.website@ Client web site
@job.custom@ Custom field associated with the job template. For example @job.additionalinfo@

Applicant Fields

Applicant Fields Variable List
Field Name Variable
@applicant.firstname@ First name of the applicant
@applicant.lastname@ Last name of applicant
@applicant.title@ Title of applicant
@applicant.email@ Email address of applicant
@applicant.phone@ Phone number of applicant
@applicant.address@ Address of applicant
@applicant.city@ City of applicant
@applicant.state@ State/Province of applicant
@applicant.country@ Country of applicant
@applicant.countrycode@ Country code (2 letter abbreviation) of applicant
@applicant.postalcode@ Zip/Postal applicant

Hiring Manager Fields

Level 1 Field Name and Variable List
Field Name Variable
@hiring manager.firstname@ First name of the hiring manager
@hiring manager.lastname@ Last name of the hiring manager
@hiring manager.title@ Title of the hiring manager
@hiring manager.email@ Email address of the hiring manager
@hiring manager.phone@ Phone number of the hiring manager
@hiring manager.address@ Address of the hiring manager
@hiring manager.city@ City of the hiring manager
@hiring manager.state@ State/Province of the hiring manager
@hiring manager.country@ Country of the hiring manager
@hiring manager.countrycode@ Country Code (2 letter abbreviation) of the hiring manager
@hiring manager.postalcode@ Zip/Postal code of the hiring manager

Sender Fields

Sender Fields Variable List
Field Name Variable
@senderfirstname@ First name of the sender
@senderlastname@ Last name of the sender
@sendercompany@ Name of sender company
@senderemail@ Email address of sender
@senderphone@ Phone number of sender
@sendertitle@ Title of sender
@now@ Current date and time format selected by the user in their personal settings - long date format.

In addition you can also refer to fields from the sender such as custom fields and company details by using @sender.xxxx@
These variables can be used within Email and Workflow messages.


Field Name Variable
@sender.address@ Address of the sender
@sender.company.name@ Name of the company the sender is associated with
@sender.(custom field name)@ Refers to a custom field from the sender's profile

Workflow Specific Variables

The following variables can only be used in messages associated with workflows:

Workflow Specific Variables List
Field Name Variable
@objectname@ Name of the object in the workflow. This could be a file name, user name, company name, or an application name.
@originatorname@ The name of the person that originated the workflow. For example, this value could be the person that added a file to a workflow-enabled SmartFolder, or the name of a person that created a new person record.
@originatoremail@ E-mail address of originator.
@originatorphone@ Phone number of originator.

Signority Variables

SmartSimple's Online Document Signing functionality allows users to manage the entire signing process.

Users can also access details on how the e-signature submission is progressing using the variables below

@HistoryOf(CFNAME,1)@ - will show only the top section of the history i.e. section that displays the overall status of the e-signature submission

@HistoryOf(CFNAME,0)@ - will show only the bottom section of the history i.e. section that displays the progress of the individual signees

@HistoryOf(CFNAME)@ - will display both top and bottom section by default

Other Variables

Level 1 Field Name and Variable List
Field Name Variable
@url@ The URL to the company alias for SmartSimple. For example: XXX.smartsimple.com – where XXX is the alias created by that company using the Company Setting page. If you wish to display the URL as a link you should type either: http:// or https:// in front of the reference in the instant message or e-mail template. For example: https://@url@
@parentlist@ The full SmartSimple path to the object.
@apptype@ Will return the application ID within the context of a given UTA.

Select One - User Group Custom Field

The details of the members of a group stored within a Select One - User Group custom field can be referenced using the following syntax:

[#(?object=group::id=@fieldname@) ... #]

Where:

  • fieldname is the name of the Select One - User Group field.
  • Replace "..." with the contact variables you wish to display. i.e. ~lastname~

The role the user is assigned within the group can be accessed using ~role~ in the above syntax.

See Also