1300 045 422
support@performzone.com
Facebook
LinkedIn
PERFORM ZONE
  • Employers
    • Post-a-job
      • About
      • Pricing
    • Accounts Login
    • Workshops
      • All Workshops
      • Blogs
    • Recruitment Software
      • Take a Tour
      • Book a Demo
      • User Manual
      • Login
      • Accounts
    • Vender Manager
  • Job Seekers
    • Search Jobs
    • Workshops
      • All Workshops
      • Blogs
    • Job Trends
  • Recruiters
    • Recruitment Software
      • Take a Tour
      • Book a Demo
      • User Manual
      • Login
      • Accounts
    • Workshops
    • Become a supplier
    • Open tenders
  • Login
    • Recruitment Software
    • Seeking Employment

Merge Field Functions

Merge fields, User ManualMarch 31, 2017pzlogin

Merge Field Functions

A range of functions are available; functions are like mathematical functions in Microsoft Excel – they take various arguments and produce an output. For example the ‘date’ function allows formatting of dates and formatting and display of the current date.

Examples;

{date(“d/m/Y”)}     produces the current date formatted as displayed – if the date was the 3rd of February 2008, this would show; 03/02/2008.

{date(“d/m/Y”, available)}  would show the date referred to as ‘available’ (whatever that merge field evaluates to), in the above format.

Function reference;

max

Description: Returns the maximum of a list of numbers.

Options:

Takes a list of numbers or merge field data, e.g.;

Max(5,6,rating)

min

Description: Returns the minimum from a list of numbers.

Options:

Takes a list of numbers or merge field data, e.g.

Min(5,6,rating)

abs

Description: Return the absolute value of a number.

 

Options:

Takes a simple number, e.g.

Abs(-5)

date

Description: Returns the formatted version of a date.

Options:

  1. Format string
  2. date value (optional – assumes current date)

Format of the options is compatible with PHP’s date function details of which can be found here; http://au2.php.net/date

E.g.;

Date(“Y-m-d”)

Date(“Y-m-d”, available)

Functions: minutes, hours, days, months, years

Description:

Returns a number for each of these components of the date.

Options:

Takes the date, e.g.

Days(available)

Minutes(available)

Dates are presented in the internal database format, but can be reformatted any way you like.

So these 4 lines:

{added}

{date(“d/m/Y”, added)}

{date(“d/m/Y H:m”, added)}

{date(“D/M/Y”, added)}

Will produce these 4 outputs:

2009-10-01 13:53:43

01/10/2009

01/10/2009 13:10

Thu/Oct/2009

Note: the editor may change the quotes “to html special encodings which trips up the data merge system. If you have problems with these, edit the HTML directly and put your quotes in there, removing the code (which will look something like ‘&quot’).

translate

Description: Translates a number into a piece of text.

Options:

  1. a number or merge field representing which of the next arguments should be displayed.
  2. or more arguments with what will be displayed.

E.g.

Translate(rating, “1 star”, “2 stars”, “3 stars”)

 

time function

Description: The UNIX timestamp of a date.

Options:

The date, optional – current date is assumed, e.g.;

Time(available)

 

lowercase

Description: Changes text to lower case.

Options:

The text to change, e.g.;

Lowercase(“HELLO”);

 

uppercase

Description: Changes text to upper case.

Options:

The text to change, e.g.

uppercase(“hello”);

 

substring

Description: Cuts out a section of the string.

Options:

  1. The string.
  2. start character zero based.
  3. length of characters to grab.

E.g.;

Substring(firstname, 0, 1)   – this will return the first letter of the first name.

 

Length

Description: Returns the length of the string.

Options:

The string, e.g.;

Length(firstname)

Download User Manual

Current Hits

  • Is there is a way we can identify if a candidate is contracted?
  • How do I import tasks?
  • About the Referees tab
  • What can Perform Zone do with SendGrid?
  • How do I sync with SendGrid?

Archives

  • February 2020
  • December 2019
  • May 2019
  • February 2019
  • November 2017
  • October 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017

Topics

  • Adverts (26)
  • Applicants (67)
  • Basics (16)
  • Candidates (19)
  • Career Centre (10)
  • Coaching (1)
  • Contacts (4)
  • Dashboard graphs (6)
  • Data (10)
  • Email (13)
  • Employers (9)
  • FAQ (16)
  • Hiring (5)
  • Job alerts (2)
  • Job ready pool (6)
  • Jobs (53)
  • Konektiva API (3)
  • Marketing (8)
  • Merge fields (10)
  • Placed (6)
  • Reports (8)
  • Resumes (11)
  • Reverse marketing (7)
  • Settings (35)
  • SFIA (2)
  • SMS (4)
  • Tasks (9)
  • Templates (4)
  • Tests (4)
  • Uncategorised (5)
  • User Manual (365)

Tags

Adverts Applicants Basics Blogs Candidates Career Centre Coaching Contacts Dashboard graphs Data Email Employers FAQ Hiring Job alerts Job ready pool Jobs Konektiva API Marketing Merge fields Placed Reports Resumes Reverse marketing Settings SFIA SMS Tasks Templates Tests Uncategorised User Manual

Search over 913 Aussie Jobs using our mobile job seeker app

android-download android-download

Perform Zone logo  PERFORM ZONE    TAKE CONTROL

Founded in 1997, Perform Zone’s cloud-based recruitment software solutions are used around the globe to help businesses be efficient and profitable.
Company
About
Terms of Service
Privacy Policy
Press Release

Job Seekers
Search Jobs
Market Trends
Tests
Mobile APP
Software
Take a tour
Book a demo
User Manual
Login

Workshops
Evening sessions
Blogs
Post a Job
Start posting
Pricing
Login

Vendor Management
For Employers
New Suppliers
Login

+61 (0)3 9573 1554

Email
Facebook
LinkedIn
© 2004 - 2022 Perform Zone. All rights reserved.