This is 100% a hail mary, but I’ll try anything rather than what I’m looking at…
So, we now have Country neatly created as a dropdown field in our records, and we have the same for country code. I’m looking for a way to “pair” these so that when Country is selected, the appropriate Country Code is also selected.
For example:
- Customer is in the United Kingdom? Country code should be GB.
- Customer is in the United States? Country code should be US.
- Customer is in Åland Islands? Country code should be AX.
However, I can find no way to make this easily happen without creating a 249 branch workflow that will pair them up. This is, to put it mildly, infuriating and insanely labour-intensive.
What would be easier is a lookup table, or the like. However, I really struggled to make this work in Zapier even.
Is there an “easy” way that I’ve not stumbled upon yet? I can’t even copy-paste the options in so it’s manualy cloning each branch and then editing the options…249 times. And then doing the same for Orgs.
This is a common and frustrating challenge, yes. Do you happen to have Operations Hub Professional or Enterprise? A lookup table could be easily included in a custom code workflow action (which in turn can be easily generated without coding knowledge using gen AI). Workflows | Custom Code Actions - HubSpot docs
Without Operations Hub and without third-party tools, yes, to my knowledge this would require one workflow branch per country.
Using (nested) if-statements, you could build a mapping. As in: Check if country is United States, if so return US, if not, perform next check. However, there is a limit to how many characters you can fit into a formula and that might be a limiting factor here, with so many pairings.
We do have Operations Hub Professional, and, inspired by your feedback, I gave it a whirl and managed to get this to work! Thank you so much for your help!
