Difference between revisions of "Variable List"

From SmartWiki
Jump to: navigation, search
m
(Level 2)
(6 intermediate revisions by 4 users not shown)
Line 26: Line 26:
 
'''@localhour(fullstartdate)@'''
 
'''@localhour(fullstartdate)@'''
  
* Adding the word local before the variable displays the hour based on the system time zone and not default Eastern time. 
+
* 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==
Line 90: Line 90:
 
||No variables
 
||No variables
 
|-
 
|-
||Currency
+
||Currency Name
||@currency@
+
||@currencyname@
 +
|-
 +
||Currency Code
 +
||@currencycode@
 +
|-
 +
||Exchange Currency  Name
 +
||@excurrencyname@
 
|-
 
|-
||Exchange Currency
+
||Exchange Currency Code
||@excurrency@
+
||@excurrencycode@
 
|-
 
|-
 
||Currency Exchange Rate
 
||Currency Exchange Rate
Line 202: Line 208:
 
||'''Contact People'''
 
||'''Contact People'''
 
||@contact@
 
||@contact@
 +
|-
 +
||'''Contact User ID'''
 +
||@contact.userid@ -- Returns one only, even with multiple contacts assigned
 
|-
 
|-
 
||'''Description'''
 
||'''Description'''
Line 250: Line 259:
 
||'''Owner'''
 
||'''Owner'''
 
||@owner@
 
||@owner@
 +
|-
 +
||'''Owner ID'''
 +
||@eownerid@
 
|-
 
|-
 
||'''Parent Name'''
 
||'''Parent Name'''
Line 446: Line 458:
 
==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"
|+style="text-align:left"|Calling L1 and L2 fields from a L2 Workbflow
+
|+style="text-align:left"|Calling L1 and L2 fields from a L2 Workflow
 
|-
 
|-
 
!|Field Name
 
!|Field Name
Line 581: Line 593:
 
||'''Contacts'''
 
||'''Contacts'''
 
||@contact.rolename.field@
 
||@contact.rolename.field@
 +
|-
 +
||'''Created Date'''
 +
||@createddate@
 
|-
 
|-
 
||'''Currency'''
 
||'''Currency'''
Line 860: Line 875:
 
  @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@

Revision as of 17:40, 14 January 2020

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@
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

Company

State|@state@|->

Level 1 Name and Variable List
Name Variable
Primary Contact @primarycontact@
Company Name @name@
Address @address@
Address 2 @address2@
City @city@
Province @province@
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