calculations

Reference Functions

Reference functions are essentially look up operations, meaning that they are used to find values using a certain criterion. They can be used in all calculation types as long as the output is consiste...

Numeric Functions

Numeric functions relate to mathematical operations. Numeric functions work across all calculations (regular, text, option, table, historical) as long as the arguments for the functions are numeric. a...

Calculations Overview

SERIES INFORMATION The Calculations series contains the following articles. Calculations overview [this page]  Basic calculations Table calculations Linked calculations History calculations Option c...

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 i...

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....

Event forms, questions and calculations

Event forms are templates within Smartabase which capture data. An event form records data about an event, hence its name. An event form captures data in the same way that a paper time-sheet records h...

Linked calculations

Linked calculations allow for data collected in one form to be shown and used in another. This allows for quicker, more efficient data entry, because commonly repeated information doesn’t need t...

Manual data entry

There are lots of different ways to enter data into Smartabase. The most common process used by an athlete, soldier, student or other non-professional user is to open a blank form, fill it out with th...

History calculations

History calculations give you the ability 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 o...

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 stan...