How to Create a Custom Math Formula

Create your own custom math formulas inside of Adalo

Skill Level: Intermediate

Before You Begin

Should have knowledge about
Should have knowledge of

Walkthrough

Using Custom Formulas with Magic Text

When adding Magic Text, you’ll notice the option "New Formula..." at the bottom of the menu. Selecting this will insert a "Custom Formula" chip into your text box. Follow these steps to use the formula:

Click on the "Custom Formula" chip to open the formula editor.
In the editor, you can type any number along with the following operators:
- + for addition
- - for subtraction
- / for division
- * or x for multiplication
- ( ) for parentheses to group parts of the formula
Insert Magic Numbers:
- Click the Magic Number icon to insert a number from your database.
- Magic Numbers use Number properties from your data, and you can filter them by etc., of related collections.
Insert Functions:
- The Magic Number icon also allows you to insert functions into your formulas. The following functions are supported:

Supported Functions

Round: Rounds a number to the nearest integer.
```
ROUND(4.32) → 4
ROUND(4.5) → 5
```
Integer (INT): Removes the decimals from a number (rounding down).
```
INT(4.32) → 4
INT(4.999) → 4
```
Absolute Value (ABS): Displays the absolute (positive) value of a number.
```
ABS(-4.32) → 4.32
```
Square Root (SQRT): Displays the square root of a number.
```
SQRT(9) → 3
```
Exponent (EXP): Raises one number to the power of another.
```
EXP(3, 2) → 9 (which is 3²)
```
Random Number (RAND): Generates a random number between two specified values.
```
RAND(0, 1) → A random number between 0 and 1
```
Logarithm (LOG): Displays the base 10 logarithm of a number.
```
LOG(100) → 2
```

Example: Calculating Trip Cost Per Person

Let’s say you want to calculate the cost of a trip per person using a custom math formula.

Insert a text box.
Select the Magic Text button (red accented letter).
Choose "New Formula" from the popup menu.
Click on the pencil icon to open the formula editor.
Click the Magic Number icon and select Trip Cost.
Enter / (to divide).
Click the Magic Number icon again and select Group Size.

Now, your formula will divide the total trip cost by the group size.

Additional Tips

You can combine multiple Magic Numbers, operators, and functions in the same formula to create more complex calculations.
Formulas using Dates will fail if MagicText is Null.

Help

PreviousSums, Counts, Averages, Min and Max NextComplex Calculations

Last updated 3 months ago

Was this helpful?

Walkthrough

Using Custom Formulas with Magic Text

Click on the "Custom Formula" chip to open the formula editor.

In the editor, you can type any number along with the following operators:

+ for addition
- for subtraction
/ for division
* or x for multiplication
( ) for parentheses to group parts of the formula

Insert Magic Numbers:

Click the Magic Number icon to insert a number from your database.
Magic Numbers use Number properties from your data, and you can filter them by etc., of related collections.

Insert Functions:

The Magic Number icon also allows you to insert functions into your formulas. The following functions are supported:

Supported Functions

Round: Rounds a number to the nearest integer.

ROUND(4.32) → 4
ROUND(4.5) → 5

Integer (INT): Removes the decimals from a number (rounding down).

INT(4.32) → 4
INT(4.999) → 4

Absolute Value (ABS): Displays the absolute (positive) value of a number.

ABS(-4.32) → 4.32

Square Root (SQRT): Displays the square root of a number.

SQRT(9) → 3

Exponent (EXP): Raises one number to the power of another.

EXP(3, 2) → 9 (which is 3²)

Random Number (RAND): Generates a random number between two specified values.

RAND(0, 1) → A random number between 0 and 1

Logarithm (LOG): Displays the base 10 logarithm of a number.

LOG(100) → 2

Example: Calculating Trip Cost Per Person

Let’s say you want to calculate the cost of a trip per person using a custom math formula.

Insert a text box.

Select the Magic Text button (red accented letter).

Choose "New Formula" from the popup menu.

Click on the pencil icon to open the formula editor.

Click the Magic Number icon and select Trip Cost.

Enter / (to divide).

Click the Magic Number icon again and select Group Size.

You can alsoas needed.

Now, your formula will divide the total trip cost by the group size.

Additional Tips

You can combine multiple Magic Numbers, operators, and functions in the same formula to create more complex calculations.

Custom formulas are flexible—tailor them to your specific needs by adjusting the numbers or properties from your database. Check out some used by our Adalo Makers .

Formulas using Dates will fail if MagicText is Null.