Mar 22, 2022 8:02 AM
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"
Solved! Go to Solution.
Mar 22, 2022 4:13 PM
Hi @DzungLương,
Thanks for tagging, @kvonloesecke. 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öhler |
![]() | Did my post help answer your query? Help the community by marking it as a solution. |
Mar 22, 2022 4:13 PM
Hi @DzungLương,
Thanks for tagging, @kvonloesecke. 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öhler |
![]() | Did my post help answer your query? Help the community by marking it as a solution. |
Mar 24, 2022 5:11 AM
Thank you for your practical support. However, it didn't work in my case because:
Mar 24, 2022 5:19 AM - edited Mar 24, 2022 5:22 AM
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öhler |
![]() | Did my post help answer your query? Help the community by marking it as a solution. |
Mar 24, 2022 5:42 AM - edited Mar 24, 2022 5:42 AM
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.
Mar 24, 2022 6:25 AM
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öhler |
![]() | Did my post help answer your query? Help the community by marking it as a solution. |
Mar 25, 2022 3:16 AM
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 .
Mar 25, 2022 3:21 AM
Hi @DzungLương,
Calculation properties update dynamically in close to real-time.
Best regards!
Karsten Köhler |
![]() | Did my post help answer your query? Help the community by marking it as a solution. |
Mar 22, 2022 2:23 PM
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 ! |