Need help with one of the function

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have 2 address fields in a table "Source Address" , "Destination Address" and i want to create a text-formula field which actually takes concatenates State(Source Address) - State (Destination Address)

How do i create a formula to concatenate state-state from both the fields

Any thoughts?
Photo of Sneha Wankhede

Sneha Wankhede

  • 244 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
[State A] & " - " & [State B]
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
You can in fact use the Address components in a formula, even though they are not listed in the field list. When you are building your formula they will be offered up as choices.
Photo of Sneha Wankhede

Sneha Wankhede

  • 244 Points 100 badge 2x thumb
Correct and those choices i didnt look up on the master table, so i was little confused how will get state out of address.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
Those address components are also shown on the [Address field] itself when you are in Field Properties.
Photo of Sneha Wankhede

Sneha Wankhede

  • 244 Points 100 badge 2x thumb
Hey Chuck that was easy, actually i was pulling complete address when i was trying to create join with another table, i was thinking i need to extract(state) from address and then need to concatenate :)

Anyways i figured that out
and Thanks for your help.
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,958 Points 1k badge 2x thumb
Oh right sorry I forgot to mention that whenever you natively add an address field, QB creates all the different parts as separate fields. Glad you got it working!