topic Can I increase property value of a deal triggered by changes to an associated ticket? in Data Hub

Can I increase property value of a deal triggered by changes to an associated ticket?

DZiv — Wed, 03 Nov 2021 17:24:03 GMT

Hi everyone!

We want to increase the property value in one of the fields in our deals based on what shows up in an associated ticket. Is there a way to make ticket-based workflows increase the property value in a field in a deal?

I managed to do something like this with a deal-based workflow, but couldn't turn on re-enrollment, so it only worked with the first associated ticket, and we need this to work with every new associated ticket.

Thanks, everyone! Any advice would be highly appreciated.

Re: Can I increase property value of a deal triggered by changes to an associated ticket?

karstenkoehler — Thu, 04 Nov 2021 06:15:37 GMT

Hi @DZiv,

Could you specify what this means exactly?

@DZiv wrote:

based on what shows up in an associated ticket. Is there a way to make ticket-based workflows increase the property value in a field in a deal?

If you could describe which criteria a new ticket has to meet for the deal property to be increased, that would help with the solution.

Best regards!

Re: Can I increase property value of a deal triggered by changes to an associated ticket?

DZiv — Thu, 04 Nov 2021 07:30:21 GMT

Thanks Karsten!

Yes, we created a field called "Hours completed", which we input every time we create a new ticket. I'm trying to create a workflow that is triggered every time a new ticket is associated with a deal, in which this (ticket) field is known, and if this field meets a specific amount, we would like to increase the value of another field that we created in our deals (also a numerical field).

I hope this helps, is this the additional information you were looking for?

Thanks!

Re: Can I increase property value of a deal triggered by changes to an associated ticket?

karstenkoehler — Thu, 04 Nov 2021 07:52:04 GMT

Hi @DZiv,

This would be my approach here: In a ticket-based workflow, enroll (and re-enroll) tickets when "Hours completed (ticket) is known" (HubSpot interprets "known" as "is available" or (!) as "has changed"). The only step of that workflow would be to copy this value into a similarly named new custom property on the associated deal record, let's call it Hours completed (deal). This field would be overwritten again and again but that doesn't matter.

Because now, in a deal-based workflow, we'll (re-)enroll deals when Hours completed (deal) is known. In this deal-based workflow you can now increase the value of the property your numerical field.

Hope this helps!

Re: Can I increase property value of a deal triggered by changes to an associated ticket?

DZiv — Thu, 04 Nov 2021 08:33:10 GMT

Hi Karsten,

Thanks for your answer! Is there a way to make this work with multiple tickets? We would like the value to increase in the deal field every time we associate a new ticket.

Thanks!

Re: Can I increase property value of a deal triggered by changes to an associated ticket?

karstenkoehler — Thu, 04 Nov 2021 08:36:02 GMT

Hi @DZiv,

The ticket workflow would enroll any ticket that fits the criteria ("Hours completed is known"), so yes, that would work for multiple tickets.

Still, disclaimer, I haven't tested this (I'm confident it should work), so I recommend you do this for a few test records before unleashing it to your whole database.

Best regards!

Re: Can I increase property value of a deal triggered by changes to an associated ticket?

DZiv — Thu, 04 Nov 2021 15:38:23 GMT

Thanks for your help! I've tried this with a few test tickets and here's what I found out:

This all works, but I run into a problem when two consecutive tickets have the same number in ticket - hours completed. The first workflow still works, but the second workflow doesn't seem to recognize this as a change, so is never triggered. There is no issue with re-enrollment, this works perfectly when the last ticket was a different number of hours.

Any ideas on how this can be fixed?

Thanks!

Re: Can I increase property value of a deal triggered by changes to an associated ticket?

karstenkoehler — Thu, 04 Nov 2021 15:48:55 GMT

Could you share a screenshot of the second workflow, @DZiv?

Re: Can I increase property value of a deal triggered by changes to an associated ticket?

DZiv — Thu, 04 Nov 2021 16:28:48 GMT

Yes, it's very long though, basically, it's if "hours completed in last session" (the new field I created) equals something, increase "Total hours completed" by the same amount. I'm attaching a screenshot from the top where you can see the trigger, and one from the bottom where you can see what it's actually doing, since it's very stretched out on top and hard to get it all in one screenshot:

Re: Can I increase property value of a deal triggered by changes to an associated ticket?

karstenkoehler — Thu, 04 Nov 2021 17:15:36 GMT

Hi @DZiv,

I think I found the issue. In this workflow that I was suggesting...

"Because now, in a deal-based workflow, we'll (re-)enroll deals when Hours completed (deal) is known. In this deal-based workflow you can now increase the value of the property your numerical field."

... there needs to be a final step that clears the property value for Hours completed (deal). Otherwise to subsequent same values would not trigger re-enrollment.

Let me know if that makes sense!

Re: Can I increase property value of a deal triggered by changes to an associated ticket?

DZiv — Sat, 06 Nov 2021 15:10:37 GMT

Yeah, that makes sense! The first workflow looks like this now, do you think this will be enough? I'll have some time to test it tomorrow and will update:

Re: Can I increase property value of a deal triggered by changes to an associated ticket?

karstenkoehler — Mon, 08 Nov 2021 05:56:15 GMT

Hi @DZiv, exactly, fingers crossed!

Re: Can I increase property value of a deal triggered by changes to an associated ticket?

DZiv — Mon, 08 Nov 2021 12:33:48 GMT

It worked perfectly! Thanks for your help!

Re: Can I increase property value of a deal triggered by changes to an associated ticket?

karstenkoehler — Mon, 08 Nov 2021 13:04:37 GMT

Sweet! Glad to hear.

Re: Can I increase property value of a deal triggered by changes to an associated ticket?

AdamSand — Thu, 24 Feb 2022 01:17:11 GMT

Are you doing this to create an accumulation of hours?

We did something like this in job costing that we built. We are SOOO close on our next step which is adding accumulated costs so I am hoping to figure this out too!

https://share.vidyard.com/watch/jQJL31JPbmeX46A4H3SFUN?

Re: Can I increase property value of a deal triggered by changes to an associated ticket?

AdamSand — Thu, 24 Feb 2022 01:24:26 GMT

How would you do this if the number on the property was different every time.

For example

Amount (HS Deal Property)
$12000
Cost 1 (Custom Deal Property)
$5000
Adjustment (Custom Deal Property fed from Ticket)
$0

Profit (Custom Deal Property)
$7000

But if a ticket closes with a Adjustment Cost of "$500"
Add $500 to the Deal Property "Adjustment"

We can do that part, we figured that out.
So then the Profit would go down to $6500

But now a SECOND ticket associated to the deal is closed with an "Adjustment" of $500
We need it to ADD to the original deals adjustment value $500

So now there is a total adjustments of $1000 and a profit recalculated at $6000

We are trying to do this as a job costing feature.

https://share.vidyard.com/watch/jQJL31JPbmeX46A4H3SFUN?