Smartstaff
281
edits
Changes
m
'''@now@''' * Inserts the current date and time
* This can be used in most areas where variables are called
'''@now@''' * Inserts the current system date ==Local Time Variable=='''@currentdatelocalhour(fullstartdate)@'''
<u>===Level 3==={| class="wikitable"|+style="text-align:left"|Level 3 Field Names and Variables|-!|Field Name!|Variable|-||'''Associated Parent'''||@linkparent.''Level Onefieldname''@|-||'''General'''</u>||Level 3 uses the same variables as Level 2.|}
* '''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 ===Calling a Level 1 custom field''' - @customfieldname@ * '''Accounts''' - No variables * '''Activity List''' - No variables * '''Application Name''' - @name@ * '''Application Template Type''' - @type@ Variable at Level 2===* '''Branch''' - @parent.branch@ * '''Close Date''' - @closedate@ * '''Contacts''' - No variables * '''Currency''' - @currency@ * '''Customeror ''' - @parent.client@ * '''Description''' - @description@ * '''End Date''' - @enddate@ * '''End Time''' - @hour(fullenddate)@:@minute(fullenddate)@ * '''Folders''' - No variables * '''Modified Date''' - @modifieddate@ * '''Owner''' - @owner@ * '''Probability''' - @probability@ * '''Requirement''' - @requirements@ * '''Revenue''' - @revenue@ * '''Start Date''' - @startdate@ * '''Start Time''' - @hour(fullstartdate)@will be replaced by company name and other fields can be referenced like this:@minute(fullstartdate)@ * '''Status''' - @status@ * '''Workflow''' - No variables
<u>'''Level Two Variables'''</u> * '''Activity Type''' - @type@* '''Amount''' - @eamount@* '''Assigned Links''' - No variables* '''Assigned People''' - @assigned@* '''Contact Links''' - No variables* '''Contact People''' - @contact@* '''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@* '''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@* '''Subject''' - @subject@* '''Updated By''' - @updatedby@ -- Displays system ID, not name* '''Whole Day Event''' - @isallday@ ==Calling a Level One Variable at Level Two== '''@parent.branch@''' or '''@parent.client@''' will be replaced by company name and other fields can be referenced like this: * '''@parent.branch.address@'''
* ==Contacts/Users=={| class="wikitable"|+style="text-align:left"|Contacts/Users Field Names and Variables|-!|Field Name!|Variable|-||'''First name''' - ||@firstname@* |-||'''Last Middle name''' - ||@lastnamemiddlename@* |-||'''Full Last name''' - ||@fullnamelastname@* |-||'''TitleFull name''' - ||@titlefullname@* '''Email address''' |- @email@* ||'''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)||@countrycountrycode@* |-||'''Postal code''' ||@postalcode@|- ||'''Primary Address'''||@primaryaddress@postalcode- 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'''||@modifieddatelastlogin@* |-||'''Cost''' - ||@cost@* |-||'''Cost unit''' - ||@costunit@* |-||'''Type''' ||@type@ (returns 'User', 'Local User Administrator' or 'Global User Administrator')|- ||'''Access Type'''||@typeaccesstype@ (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'''||@suffixlangname@ 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)|}
* '''level ==Parent can be Company, Level 1 name field''' - @parent.name@ * '''level 1 type field''' - @parent.type@ * '''level 1 status''' - @parent.status@* '''level 2 startdate''' - @parent.startdate@ * '''level 2 startdate''' - @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@ , Opportunity or Leads==
<u>'''Company'''</u>
* '''Primary Contact''' - @primarycontact@
* '''Company Name''' - @name@
* '''Address''' - @address@
* '''Address 2''' - @address2@
* '''City''' - @city@
* '''Province''' - @province@
* '''State''' - @state@
* '''Postal code''' - @postalcode@
* '''Country''' - @country@
* '''Phone number''' - @phone@
* '''Fax number''' - @fax@
* '''Owner''' - @owner@
* '''Website''' - @website@
* '''Custom fields''' - @customfields@
* '''NAIC Code 1''' - ?
* '''NAIC Code 2''' - ?
* '''Last updated''' - @modifieddate@
* '''Last updated by''' - ?
* '''Associates''' - ?
* '''Category custom fields *Cannot use underscore!''' - Use the field name in @s
==Leads== <!--* '''Campaign''' - Don’t know--><!--* '''NAIC 1''' - Don’t know
* '''All standard contact fields'''* '''All standard company fields'''* '''@rolename.customfield@'''* '''@randompasswordprimaryroleid@''' - Generates a new password when sending to provides the id for the user* '''@password@''' - Generates a new password when sending to user* '''@username@''' - Sends s primary role. Do not use the username* ''prefix '@userid@me.''' - Sends the user id.
==Contacts== @primaryroleid@
* '''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@ * '''Zip/Postal code of contact or lead''' - @postalcode@ * '''Company name of contact or lead''' - @companyname@ ==Organization Categories==* '''Contact address ? not available for lead''' - @caddresscatlist@ * '''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 lists the sender''' - @senderfirstname@ * '''Last name roleid of each Organization Category 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@(Account/Organization) belongs to.
==Roles== @me.parent.catlist@'''@categories@''' lists the category names of each Organization Category the company (Account/Organization) belongs to.
''' @currentuseridme.parent.categories@'''
* {| class="wikitable"|+style="text-align:left"|Job Fields Variable List|-!|Field Name!|Variable|-||@job.titlename@ - ||'''Job titlename'''.* |-||@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@'''|}
* @hiring manager.firstname@ |- '''First name of the hiring manager'''.* ||@hiring manager.lastnamecity@ - ||'''Last name City of the hiring manager'''.* @hiring manager.title@ |- '''Title of the hiring manager'''.* ||@hiring manager.emailstate@ - ||'''Email address State/Province of the hiring manager'''.* @hiring manager.phone@ |- '''Phone number of the hiring manager'''.* ||@hiring manager.addresscountry@ - ||'''Address Country of the hiring manager'''.* @hiring manager.city@ |- '''City of the hiring manager'''.* ||@hiring manager.statecountrycode@ - ||'''State/Province Country Code (2 letter abbreviation) of the hiring manager'''.* @hiring manager.country@ |- '''Country of the hiring manager'''.* ||@hiring manager.postalcode@ - ||'''Zip/Postal code of the hiring manager'''.|}
* @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'''.
* @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.
For example:* @P1.T1@ <!- Page 1, question 1 text* @P1.Q1@ - Page 1, question 1 response value===Spreadsheet Custom Field===* [@firstname@] - The variable name of the response data stored within a cell or range of cells on a question that asks for first name[[Special - Spreadsheet]] custom fields can be referenced using:
# If you use a response variable name, the variable name must be surrounded by square brackets *Range of Cells::<font size=3>@sps.'''[ ]'fieldname'' .A1:C1@</font># The default variables are case sensitive when used in the workflow:<font size=3>@sps. They must be in '''CAPS'fieldname''.A1:C3@</font>
* @parentlist@ - The full SmartSimple path to role the objectuser is assigned within the group can be accessed using '''~role~''' in the above syntax.
→Organization Categories
==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==
* Inserts Adding the word local before the variable displays the hour based on the current system date time zone and not default Eastern time. The same can be used for minutes and for am/pm.
==Universal Tracking Application Variables==
===Level 1===
{| class="wikitable"
|+style="text-align:left"|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===
{| class="wikitable"
|+style="text-align:left"|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@
|}
* '''@parent.branch.country@'''
* '''@parent.branch.customfield@''' * '''@parent.firstname@''' * '''@parent.lastname@''' * '''@parent.description@''' * '''@parent.status@''' * '''@parent.peopleperson.fieldname@''' - fieldname will be replaced by the variables listed below for Peoplethe '''Person''' [[Standard Field]] at Level 1.
whatever fields available for company object. <u>'''Variables for People'''</u>
==When calling on Level 1 and Level 2 information from a Level 2 Workflow==
{| class="wikitable"
|+style="text-align:left"|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@
|}
{| class="wikitable"|+style=Parent can be "text-align:left"|Level 1 Name and Variable List|-!|Name!|Variable|-||'''Primary Contact'''||@primarycontact@|-||'''Company, Level 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, Opportunity or Leads=='''||@naiccode1@|-||'''NAIC Code 2'''||@naiccode2@|-||'''Last updated'''||@modifieddate@|-||'''Last updated by'''||@updatedbyname@|-||'''Category custom fields'''||@Field Name@|}
==Opportunity, Level 1==
{| class="wikitable"
|+style="text-align:left"|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@
|}
<!--* '''Accounts''' - No variables
* '''Activity List''' - Is not displaying information properly, according to Wiki call guide
* '''Applicants''' - No information on how to call applicants in Wiki -->==Leads=={| class="wikitable"|+style="text-align:left"|Leads Variable List|-!|Field Name!|Variable|-* ||'''BranchStatus''' - ||@branchstatus@ * '''Close Date''' |- @closedate@ * ||'''Company field''' - ||@company.fieldname@ * |-||'''ContactsAddress''' - ||@contact.rolename.fieldaddress@ * |-||'''CurrencyAddress 2''' - ||@currencyaddress2@ * |-||'''CustomerCity''' - ||@clientcity@ * |-||'''DescriptionProvince''' - ||@descriptionprovince@ * |-||'''End DateCountry''' - ||@enddatecountry@ * |-||'''End TimePostal''' - ||@hour(fullenddate)@:@minute(fullenddate)postalcode@ * '''Folders''' |- No variables * ||'''Opportunity SourcePhone''' - ||@leadsourcephone@ * '''List Job Questions (with combo boxes)''' |- @jobquestions@ Only for opportunities that use the recruiting template* ||'''List Job Questions (just questions)Fax''' - ||@jobquestionsrfax@ * '''List Job Skills''' |- @jobskills@ * ||'''Modified DateWeb Site''' - ||@modifieddatewebsite@ * '''Number of filled positions''' |- @candidatefilled@ * ||'''Number of open positionsFirst Name''' - ||@openpositionsfirstname@ * '''Owner''' |- @owner@ * ||'''Opportunity Last Name''' - ||@namelastname@ * |-||'''Opportunity TypePrefix''' - ||@typeprefix@ * |-||'''ProbabilitySuffix''' - ||@probabilitysuffix@ * |-||'''RequirementsTitle''' - ||@requirementstitle@ * |-||'''Revenue(Contact) Phone''' - ||@revenuecontactphone@ * |-||'''Start DateEmail''' - ||@startdateemail@ * |-||'''Start TimeDescription''' - ||@hour(fullstartdate)@:@minute(fullstartdate)description@ * '''Status''' |- @status@ * ||'''Template type numberDate Added''' - ||@templatetypedat_added@ |}
* '''StatusNAIC 2''' - @status@ Don’t know--><!--* '''CampaignExt.''' - Don’t know --><!--* '''CompanyOwner/Owner.field''' - @name@ Don’t know-->==Email Broadcast=={| class="wikitable"|+style="text-align:left"|Email Broadcast Variable List* '''Address''' |- @address@ * '''Address 2''' !|Field Name!|Variable|- @address2@ * '''City||''' - @cityrolename.customfield@ * '''Province''' |||- @province@ * ||'''Country''' - @countryrandompassword@ * '''Postal''' ||Generates a new password when sending to user|- @postalcode@ * ||'''Phone''' - @phonepassword@ * '''Fax''' ||Generates a new password when sending to user|- @fax@ * ||'''Web Site''' - @websiteemail@ * '''NAIC 1''' ||Sends the username/E- Don’t know mail* '''NAIC 2''' |- Don’t know * ||'''First Name''' - @firstnameuserid@ * '''Last Name''' ||Sends the user id|- @lastname@ * '''Prefix||''' - @prefix@ * sender.''fieldname'Suffix''' - @suffix@ * '''Title''' - @title@ * '''(Contact) Phone''' - @contactphone@ ||manner of referencing details of the user who is sending the email|}* : '''Ext.Note:''' - Don’t know :* examples: '''Email''' - @emailsender.company.address@ * ''will return the address of the sender'Description''' - @description@ s company.:* Includes '''Owner/Owner.fieldAll standard contact fields''' - Don’t know :* Includes '''Date AddedAll standard company fields''' - @dat_added@
==Contacts=={| class="wikitable"|+style="text-align:left"|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 Broadcastaddress 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 [[roleid]]s corresponding to the roles the user belongs to. @me.rolelist@
==Custom Fields attached to Roles==
'''@rolename.customfieldname@'''
==[[Using Variables in the Report Builder|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:
<u>'''Job Fields'''</u>
==Applicant Fields==
{| class="wikitable"* |+style="text-align:left"|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==
{| class="wikitable"
|+style="text-align:left"|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'''
==Sender Fields==
{| class="wikitable"
|+style="text-align:left"|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@''' <br />
These variables can be used within [[:Category:Email|Email]] and [[Workflow]] messages.
{| class== Workflow Specific Variables =="wikitable"|-!|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:
{| class="wikitable"|+style=Web Form "text-align:left"|Workflow Specific Variables==List|-!|Field Name!|Variable|-* ||'''@objectname@Pn'''||Name of the object in the workflow.TnThis 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.|-||'''Question text@originatoremail@''' * ||E-mail address of originator.|-||'''@Pnoriginatorphone@'''||Phone number of originator.Qn|} {{Template:Signority Variables}} ==Other Variables=={| class="wikitable"|+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 '''Response valuehttps://''' in front of the reference in the instant message or e-mail template. For example: <nowiki>https://@url@</nowiki>* [|-||'''@variablenameparentlist@] '''||The full SmartSimple path to the object.|- ||'''Response variable name@apptype@'''||Will return the [[Determining the applicationid|application ID]] within the context of a given [[UTA]].|}
'''NoteSyntax:'''*Single Cell::<font size=3>@sps.''fieldname''.B2@</font>
'''Where:'''
* ''fieldname'' is the name of the '''Spreadsheet''' 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:
: <span style="font-size: medium;">'''[#(?object= Other Variables =group::id=@''fieldname''@) ... #]'''</span>'''Where:'''
* @url@ ''fieldname'' is the name of the '''Select One - The URL to the company alias for SmartSimpleUser Group''' field.* Replace ". For example: XXX.smartsimple.com – where XXX is the alias created by that company using " with the Company Setting page. If contact [[variables]] you wish to display the URL as a link you should type: HTTP:// in front of the reference in the instant message or . ''i.e-mail template. For example: HTTP:// @url@~lastname~
==See Also==