-
Before You Begin!
-
Calculated and Triggered Fields 7 min
-
Knowledge Check 1 min
-
The Formula Builder 4 min
-
Knowledge Check 1 min
-
Using Functions 15 min
-
Knowledge Check 1 min
-
Cross Table Formulas 15 min
-
Knowledge Check 1 min
-
Key Takeaways 4 min
-
Course Feedback 1 min
-
Next Steps
Course 7 - Functions and Formulas
Learn how your can leverage calculated and triggered fields to automatically calculate values on the fly.
Using TrackVia to perform complex calculations is a cornerstone of many applications. This course is designed to break down the functionality of calculated and triggered fields into digestible pieces of information that will help any admin learn how to get started writing their own powerful formulas.
Learning Objectives
- Triggered fields
- Calculated fields
- The formula builder
- Syntax
- Referencing parent fields
- Referencing child fields
- Performing arithmetic
- Common functions
Recommended Prerequisites
Related Knowledge Base Articles
How to use calculated fields and formulas
Formulas don't have to be scary
Complete list of functions
Triggered fields vs calculated fields