topic Re: Custom code in Workflow to calculate number of emails? in Data Hub

Custom code in Workflow to calculate number of emails?

ABrandt — Wed, 24 Jan 2024 13:57:52 GMT

Hello community,

While HubSpot provides a Number of times contacted field natively, this field is not very granular in that:

It counts all types of activties indiscrimnantly.
The number can only grow as its not calculated for a certain time period.

I am wondering if its possible in using custom code in workflow, to achive a count of related activties with various conditons (activity type) and date (time frame).

Can the code access all the related activity records to perform such a count?

Thank you

Re: Custom code in Workflow to calculate number of emails?

BérangèreL — Thu, 25 Jan 2024 09:27:50 GMT

Hi @ABrandt,

Thank you for reaching out to the Community!

I found for you similar threads that might be of interest:

- The solution from @KimM on this post "Custom Code to Count Activities"
- The post from @Kevin-C on this post "Using Custom Code to get activity dates in contact workflow"
- The solution from @karstenkoehler on this post "Activity type & count by Company over period"

I also wanted to invite a couple of subject matter experts to this conversation: Hi @HFisher7, @louischausse and @ChristinaKay do you have suggestions to help @ABrandt, please?

If anybody else has anything to add and/or share, please feel free to join in the conversation 🙂

Thank you very much ❤️ and have a great day!

Best,
Bérangère

Re: Custom code in Workflow to calculate number of emails?

ABrandt — Thu, 25 Jan 2024 18:26:12 GMT

Hello Bérangère,

Thanks for the reply here and searching for previous solutions.
It looks like the first solution you posted migh be the closest to what is needed.

I did not realize that it is possible to use API calls inside a custom code element within a workflow.
I'll have to try to alter this sample code to what we need and see how it work.

Thank you
Alexandre