Glide Library
Searchโ€ฆ
Math Column
Performs instant calculations on your data
The Math Column allows you to perform instant calculations on the data in your table from basic arithmetic functions to more complex ones.
You can then bind the formulas in your column to different components in your app and see the output instantly.

Configuration

Once you've added the Math Column, you need to configure your calculation or formula. As you start typing in the Configuration field, Glide will guess which column you are referring to and add a new replacement field.
This means you don't have to use the full column name in your calculation. For example, instead of using the formula:
(Annual Salary Package)/12
you could just write: AS/12 and then use the replacement fields to tell the Math Column what AS refers to:
You can reassign your replacements to different columns whenever you like:

Supported calculations

The Math Column works with the following calculations:
+ ADDITION - SUBTRACTION * MULTIPLICATION / DIVISION ^ EXPONENTIATION () PARENTHESIS
And the following functions e.g. LOG() or ABS()
LOG ABS MIN MAX FLOOR CEILING ROUND TRUNC ASIN COS ACOS ATAN MOD DAY MONTH YEAR
The Math Column only accepts the above symbols. It will throw an error if you try to use another symbol.
โ€‹
The Math column can also do calculations with Dates & Times. For example;
Subtracting two date/times produces a duration, which is a number and is measured in days, like in Google Sheets. If you want to calculation to output the number of hours, you just need to * by 24.
Adding a duration (number) to a date/time, or subtracting it from a date/time will add/subtract that many days to it and you can also pick โ€œNowโ€ as a substitution for a variable.
Last modified 1mo ago