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 Age calculations Personal details calculations OVERVIEW You can use calculation fields in Smartabase to perform calculations using the data […]

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

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 to be re-entered if it can be drawn from elsewhere in the site. This saves time, but, importantly, also maintains data consistency. Fields can be […]

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 or total workload of an athlete over a specific period of time. There are three types of history calculations: History calculations can […]

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

You can use a time calculation to display the start or end time of a record or to display the answer selected in a time field. In the example here, we’ve used two time calculations to show the start and end time for an event form that displays simple appointment information. The results of the […]

Date Calculations

You can use a date calculation to display a date in an event form. This can be helpful if you want to show the Event date or another date from elsewhere in the record using a different date format.

Duration Calculations

You can use a duration calculation to work with data entered into duration fields in an event form. For duration fields that are part of a table, you should use the table duration calculation instead. In this example, the duration calculation field uses a formula to display the sum of two duration fields. Since the […]