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. 

COMMISSION CALCULATION

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. 

DISCOUNT CALCULATION

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")

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

GENERATING A CLICKABLE URL

For URLs that are composed of the domain and the ID you can create a clickable URL field in NetHunt.

To do so, set up the separate fields for the web site and the ID and a text statistical field to combine the two.

When you put in the values for your two text fields (Amazon and ASIN in our example) your formula field will generate a clickable URL.

You can click on it and open in the new or current tab. The URL of the page is correct and we're looking at the valid product from Amazon. This feature can work for multiple web sites and IDs !

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.

Did this answer your question?