Hello! I am trying to concat the address fields into a single field (City, State, Country). When I try to add any of the address fields into Use Formula function, I get an error. Any thoughts on if I am able to leverage these fields?
Best answer by Michelle from CopperView original
@Jagatelife, thanks for posting! The address fields start with
address.e.g. the variable for city is
address.city. So give this a try:
This formula will result in this format: ScaramentoCaliforniaUSA.
If you want to add commas for formatting purposes, you can include them in your formulas as such:
This would give you: Sacramento,California,USA
You can also add spaces in addition to the commas:
CONCAT(address.city,”, ”,address.state,”, ”,address.country)
This would give you: Sacramento, California, USA
By the way all the variables are listed on this page for your reference.
Give that formula a try and let me know how it goes!
Thanks! That worked perfectly. In case anyone comes across this, I also added , between value. Here is what I used: CONCAT(address.city,",",address.state,",",address.country)
I’m going to edit my original reply to include those commas and then mark it as Best Response so that others can find it easily.