Need help with one of the function

Question

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?

chuckgrigsby · Answer

[State A] &amp; " - " &amp; [State B]

quickbasecoachd · Answer

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.

snehawankhede · Answer

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.

snehawankhede · Answer

Correct and those choices i didnt look up on the master table, so i was little confused how will get state out of address.

quickbasecoachd · Answer

Those address components are also shown on the [Address field] itself when you are in Field Properties.

Forum Discussion

Need help with one of the function

Related Content

Nz Function - Formula Help

Jinja Date functions

Mobile App Functionality

Relationships functional question

Do unused tables related to currently used tables cause functionality problems?