La fonction de suggestion automatique permet d'affiner rapidement votre recherche en suggérant des correspondances possibles au fur et à mesure de la frappe.
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"
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)
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 HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
mars 24, 20225:42 AM - modifié mars 24, 20225:42 AM
Participant
Can I Count number of Value in property?
Résolue
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.
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.
"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 HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer