Let’s say you have two databases: one for the products you sell online, and another for your sales CRM. You want to know the total price a customer pays - how do you do it?

You make a connection between these two databases.

The first thing you should do is add a two-way relation between these 2 databases (new property → relation). Then you want to create a rollup that will take the prices of the selected products from the Product database and put them into the sales CRM. Finally, you create a formula that adds this product price to the shipping cost, which depends on the customer's address. It's that simple!

Now you can see what products each customer bought and know how much each order costs them 😎

‍

‍

Pro tip: for your shipping costs, create a select property for the customer’s country. You then create a formula that says something like: if(prop(”Country”)==”UK”, 29, (if(prop(”Country”)==”US”, 19, (if(prop(”Country”)==”Germany”, 25,39))) with the numbers being the shipping costs. This will enable the shipping costs to be updated automatically depending on the customer’s country.