Most of the time all entrepreneurs take all sorts of calculations. It can be commissions for yourself and your colleagues and other calculations regarding customers, for example, the amount of the transaction, taking into account the discount and the price for all the products requested.

In this article, we will tell you how to free yourself from this routine and rely on automation.

Let's take these two cases above. 


Imagine you are a Real Estate agent. You have a deal and all the related information.

When you fill out all the information you have in respective fields, the "Commission $" field will automatically calculate your commission for a closed deal.

To set up such automation - go to your "Settings" -> "Folder and field management" tab (switch to Fields).

Add next fields: 

Total Price (field name can be changed) with "Number" type and Commission (name can be changed as well) with "Percentage" type. 

After that, add field Formula with "Numeric" type and put there the following:

= field("Total Price $") * field("Commission %")

As you can see, a Formula field takes values from the given fields and converts them in accordance with the given rule. 

NOTE: Formula field requires exact names of the given fields. Otherwise, you will receive an error. 


Now imagine you sell craft mugs. Recently you have sent a promo which states everyone who orders 10 or more of your mugs receives a 20% discount on a bill.

Total price field calculates the sum of the Quantity and Price per unit fields and Total Price (with 20% discount) also adds a 20% discount to it. 

Iterate first step of the previous example - go to your "Settings" and find corresponding folder to add following fields: 

Quantity with "Number" type and Price per unit with "Currency" field type.

After that, add 2 Formula fields with "Numeric" type and put there next:

=field("Price per unit") * field("Quantity")

=(field("Price per unit") * field("Quantity")) * 0.8

NOTE: Formula field requires exact names of the given fields. Otherwise, you will receive an error.

That's it! You've successfully set up the formulas to calculate your values automatically. That way you can save lots of time for yourself and other people. 

Haven’t found the answers you’re looking for? Ask our User Community on Facebook!

Did this answer your question?