Why Choose TaxCycle
Unparalleled Support
Integrated Tax Suite
Switching is Easy
File Conversions
Easy Onboarding
Flexible Payment Plans
Satisfaction Guarantee
How to Switch
Download a Trial
Watch an Intro Webinar
Attend a Seminar
Book a Demo
Refer a Colleague
Customer stories
Referral Program
Help Centre
Help Topics
Search all topics
Video Library
Keyboard Shortcuts
Training
TaxCycle Seminars
Upcoming Webinars
Webinar Recordings
Onboarding
Initial Configuration
Onboarding Videos
Preparing Your First Return
TaxFolder Start Guide
Training Workbook
Sale EndsSept 24
Looking for a specific article? Search Topics
Call 1-888-841-3040. We're here to help!
Join Cameron Peters, TaxCycle's CEO & Founder, and the TaxCycle team for a full day of practical training, five CPD credits, and the kind of conversations that only happen in person, in your city.
Get the latest news in your inbox! Newsletter Sign-up
Use these functions in templates and data mining to create conditions and format text.
Use the abs() function to format any number to show the absolute value.
Use abbreviate() to display the two-letter abbreviation of any province.
Use the addmonth() function to add months to a date.
Use the addymd() function to add years, months or days to a date.
How to aggregate amounts from the same field on a multi-copy form.
The anchor() function is used to place an electronic signature request within a template. It is used in conjunction with the Signature ID template property.
The capitalize() function capitalizes the first letter from a field.
The contains() function tests if a text field contains a list of input text values. This function is case-insensitive.
Use the count() function to count items in templates.
The date(YYYY, MM, DD) function is used to insert a specific date.
The first() function looks for the first instance that matches the condition and then stops.
Iterate multi-forms and slips. For each form or slip copy, match this field to a value.
Apply the format() function to a field code to change the display of numbers, dates and other information.
Use the gifibalances() function to iterate the S100 and S125 forms for specific values.
The history() function tests if a client's history contains a particular value. This function is case-insensitive.
Tests whether a field is blank or contains text.
Use the istaskcomplete() and istaskcompleted() functions to test whether the given workflow task is complete or was completed on a specific date.
Join field codes and add a separator using the join() function.
The last() function looks for the last instance that matches the condition and then stops.
This function lets you change text to lowercase when pulled from a field in TaxCycle.
Obscure the output from a field code using the mask() function.
Reverses a statement in a template or data monitor.
The round() function allows you to round a number to the nearest digit.
Use select() to select a specific row of a table based on data in one of the cells.
The selectFirst() function allows you to select the first instance of a specific row of a table based on data in one of the cells.
The today() function inserts the system date for the computer where the file is open.
The function upper() transforms text to uppercase.