Teilnehmer/-in

## Can I Count number of Value in property?

lösung

I have a contact property named "X" that has value = "a/b/c" for every contact. Many Contacts can have the same email domain property, for example "aloha.com" (which means they have the same company)

my question is: Can I create another property to count the total number of value ="b" in "aloha.com" domain?

Expected outcome: Property "Number of value = "b" = 10 for email domain  "aloha.com"

1 Akzeptierte Lösung
Lösung
Berühmtheit | Partner

## Can I Count number of Value in property?

lösung

Hi @DzungLương,

Thanks for tagging, @kvlschaefer. There might be an easier solution here, using calculation properties.

@DzungLương, you would create this calculation property for the company object. It would look like this:

This company property now counts the number of contacts with value B in this property and stores the number.

Best regards!

 Karsten KöhlerHubSpot Freelancer | RevOps & CRM Consultant | Community Hall of FamerBeratungstermin mit Karsten vereinbaren

 Did my post help answer your query? Help the community by marking it as a solution.
8 Antworten
Lösung
Berühmtheit | Partner

## Can I Count number of Value in property?

lösung

Hi @DzungLương,

Thanks for tagging, @kvlschaefer. There might be an easier solution here, using calculation properties.

@DzungLương, you would create this calculation property for the company object. It would look like this:

This company property now counts the number of contacts with value B in this property and stores the number.

Best regards!

 Karsten KöhlerHubSpot Freelancer | RevOps & CRM Consultant | Community Hall of FamerBeratungstermin mit Karsten vereinbaren

 Did my post help answer your query? Help the community by marking it as a solution.
Teilnehmer/-in

## Can I Count number of Value in property?

lösung

Thank you for your practical support. However, it didn't work in my case because:

• A/B/C is not the number value (it is a word), and I could not find it in the "additional Condition".
• Also, if your suggestion worked, it would only solve 1/2 of my issue. (my issue are counting the number of value B + in 01 particular (@aloha.com) domain)
Berühmtheit | Partner

## Can I Count number of Value in property?

lösung

Hi @DzungLương,

Regarding your first point, you would have to change the property type then. (If HubSpot can't offer a feature in a certain way, you need to adjust to it or accept that it's not possible, unfortunately.)

To your second point, could you please specify? A domain corresponds to a company record, 1:1. So for example, if you have contact records keanu@aloha.com, leilani@aloha.com with value B and kalani@aloha.com with value C, the property (as set up above) would show the number 2 on the company record with the Company domain name aloha.com. This would be calculated for each Company domain name ( = company record).

Best regards

 Karsten KöhlerHubSpot Freelancer | RevOps & CRM Consultant | Community Hall of FamerBeratungstermin mit Karsten vereinbaren

 Did my post help answer your query? Help the community by marking it as a solution.
Teilnehmer/-in

## Can I Count number of Value in property?

lösung

Hi Karsten,

So in my first point, can I workaround by creating a new number property [K], and then create a workflow to set (let's say) If Property [X] had value B -> then properly [K] = 1, otherwise,  properly [K] =0?

"if you have contact records keanu@aloha.com,leilani@aloha.com with value B and kalani@aloha.com with value C, the property (as set up above) would show the number 2 on the company record with the Company domain name aloha.com"

-> that's exactly what I want.

-> My expected outcome is: I can know the company (@aloha) has 2 contacts having value B, company (@ola) has 4 contacts having value B,...

context: If I can have the Property "Number of value = "b" = 10 for email domain "aloha.com" -> I can  set up lead scoring mechanism in Hubspot.

Berühmtheit | Partner

## Can I Count number of Value in property?

lösung

Hi @DzungLương,

@DzungLương wrote:

So in my first point, can I workaround by creating a new number property [K], and then create a workflow to set (let's say) If Property [X] had value B -> then properly [K] = 1, otherwise,  properly [K] =0?

Yes, that should work. I'd recommend creating the property first to see if you can reference it correctly in the calculation property – and then set up the workflow.

@DzungLương wrote:

"if you have contact records keanu@aloha.com,leilani@aloha.com with value B and kalani@aloha.com with value C, the property (as set up above) would show the number 2 on the company record with the Company domain name aloha.com"

-> that's exactly what I want.

-> My expected outcome is: I can know the company (@aloha) has 2 contacts having value B, company (@ola) has 4 contacts having value B,...

context: If I can have the Property "Number of value = "b" = 10 for email domain "aloha.com" -> I can  set up lead scoring mechanism in Hubspot.

In that case, my outlined approach should work perfectly fine. You can find the instructions in my earlier post. Let me know if you're getting stuck at any stage.

Best regards!

 Karsten KöhlerHubSpot Freelancer | RevOps & CRM Consultant | Community Hall of FamerBeratungstermin mit Karsten vereinbaren

 Did my post help answer your query? Help the community by marking it as a solution.
Teilnehmer/-in

## Can I Count number of Value in property?

lösung

Hi Karsten,

It works!. Thank you so much for the support.

My only remaining concern is that:

In the future,  if "keanu@aloha.com,leilani@aloha.com with value B" -> this contact change value from B->C, Can the calculation property update itself or do we have to create a workflow to re-enroll keanu@aloha.com,leilani@aloha.com .

Berühmtheit | Partner

## Can I Count number of Value in property?

lösung

Hi @DzungLương,

Calculation properties update dynamically in close to real-time.

Best regards!

 Karsten KöhlerHubSpot Freelancer | RevOps & CRM Consultant | Community Hall of FamerBeratungstermin mit Karsten vereinbaren

 Did my post help answer your query? Help the community by marking it as a solution.
Community-Manager/-in

## Can I Count number of Value in property?

lösung

Hi @DzungLương,

Thanks for reaching out!

At the moment this isn't possible in HubSpot. I wanted to refer you to this post where @karstenkoehler offers a workaround with a workflow.

Best,

Kristen

 Did you know that the Community is available in other languages?Join regional conversations by changing your language settings !