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 Age calculations OVERVIEW The purpose of the Calculations series is to familiarise you with the use of calculations within […]
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 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 allow for data collected in one form to be linked to another. The reason that this is done is to facilitate quicker, more efficient workflows; commonly repeated information doesn’t need to be re-entered if it can be drawn from elsewhere in the site. This saves time, but, importantly, also maintains data consistency. Fields […]
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 or total workload of an athlete over a specific period of time. There are three types of history calculations: History calculations can […]
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 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 can be used to return the record’s start or finish time.
Date calculations can be used to return a date. For example, the date of the record (event form date).
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 […]