Solved

Workflow formula - Unsupported Variable

  • 26 September 2022
  • 3 replies
  • 27 views

Userlevel 1

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?

icon

Best answer by Michelle from Copper 26 September 2022, 16:48

View original

3 replies

Userlevel 6
Badge +5

Hi @Jagatelife, thanks for posting! The address fields start with address. e.g. the variable for city is address.city. So give this a try:

 

CONCAT(address.city,address.state,address.country)

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:

CONCAT(address.city,”,”,address.state,”,”,address.country)

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!

Userlevel 1

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)

Userlevel 6
Badge +5

@Jagatelife fantastic! Good call adding the commas in there - otherwise it would be formatted as ScaramentoCaliforniaUSA.

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.

Reply