The Math Column
allows you to perform instant calculations on the data in your table. You can then bind it to a component in your app and see the output instantly.
Once you've added the Math Column
, you need to configure your calculation. 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:
(Item Price+(Item Price * Tax)) * Number of items
you could just write: (i+(i*t))*n
and then use the replacement fields to tell the Math Column what i
t
and n
refer to.
You can reassign your replacements to different columns whenever you like:
The Math Column works with the following symbols:
+
ADDITION
-
SUBTRACTION
*
MULTIPLICATION
/
DIVISION
^
EXPONENTIATION
()
PARENTHESIS
log()
LOG
The Math Column only accepts the above symbols. It will throw an error if you try to use another symbol.