Forum Discussion

AndreaPahor's avatar
AndreaPahor
Qrew Cadet
7 years ago

Extract part of address from address field

Can I extract data from an address field so that I can format the address when printing it on a letter? Example Address field:  3300 North Brook Place, Boise, ID 83710 United States ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
The field name for that subfield is listed on the field properties of the [Address field].  One of mine looks like this


31 Address: Street 1
32 Address: Street 2
33 Address: City
34 Address: State/Region
35 Address: Postal Code
36 Address: Country


So my formula would just be
[Address: Postal Code]


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
JasonBeaver's avatar
JasonBeaver
Qrew Cadet
5 years ago
thank you

------------------------------
Jason Beaver
------------------------------