Calculations Overview

SERIES INFORMATION The Calculations series contains the following articles. Calculations overview [this page]  Basic calculations Table calculations Linked calculations History calculations Option calculations Text calculations Time calculations Date calculations  Duration calculations URL generator Embedded event summary calculation OVERVIEW The purpose of the Calculations series is to familiarise you with the use of calculations within Smartabase. In […]

Basic Calculations

Unless a specific type of result is required, such as text, option or duration, a basic calculation is the best calculation type to use when referencing individual fields within the current form. If it is necessary to perform a calculation on a table, one of the table calculation type fields should be used. To reference […]

Table Calculations

Table calculations are used to perform calculations about a table in the form. Table calculations are only used to perform calculations about data within the table and should not be part of the table. The most recent version of Smartabase allows users to create numeric, option, text, date and duration table calculations. Table calculations can […]

Linked Calculations

Fields in event forms can be linked from other event forms (linked calculations). Often, this information is linked from a profile form using a profile linked calculation type. Some examples of fields that are frequently linked from profile forms are name, age, gender, contact information and, in the case of athletes, sport specific information such […]

History Calculations

History calculations allow builders to create calculations based on the previous entries for a specific field in the form. This type of calculation is useful, for example, to track the average or total workload of an athlete over a specific period of time. There are three types of history calculations: History calculations can be used […]

Option Calculations

Option calculations are written in the same way as basic calculations; however, an option calculation returns a result that may be treated as an option for the purposes of visibility, performance standards, status indicators and other functions that work with options such as performance alerts. It is necessary to create a list of options for […]

Text Calculations

Text calculations are written in the same way as basic calculations; however, a text calculation returns a result in text format. EXAMPLE: A NESTED IF STATEMENT USING A TEXT CALCULATION Nested If statements are a commonly used equation, which allows you to check for multiple conditions sequentially and return a value based on one of […]

Time Calculations

Time calculations can be used to return the record’s start or finish time.

Date Calculations

Date calculations can be used to return a date. For example, the date of the record (event form date).

Duration Calculations

Duration calculations can be used to calculate durations using duration questions in the form. For example, the duration calculation field could use a formula that returns the sum in hh:mm:ss format of two duration fields. It is necessary to ensure that the Format property for the calculation is set correctly in relation to the duration […]