Example with 2 decision rules

Let's say that you are creating a Database -> HubSpot and you have companies store in the following table and want to send this data to HubSpot Companies. Our database store companies with same ID and same name for each subsidiary but with different "City".

IDNameCity

1234

Acme Ltd

Milan

1234

Acme Ltd

Rome

Let's say that on HubSpot we already have the current data:

IDNameCity

1234

Acme Ltd

Milan

We can build our decision rules like this:

IF [ Company Name ] = 0: ADD = 1: NEXT > 1: NEXT

IF [ City ] = 0: ADD = 1: UPDATE > 1: STOP

And choosing as Decision Algorithm the "Funnel" option.

The cases for each of the 2 records on database will be:

  • For the first record: The first IF will trigger the "= 1" rule and the second the "=1" rule and it will result in an UPDATE decision.

  • For the second record: The first IF will trigger the "= 1" as well, but the second will trigger the "= 0" rule and it will result in an ADD decision.

Last updated