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 ...
Forum Discussion
If you look at the address field properties, you will see that it is really made up of 6 fields, and each has its own field name and Field ID#, so "yes" is the answer to your question.
Post back if you need help with the actual formula.
Post back if you need help with the actual formula.
Hello, thanks for this article. I am a new user to Quickbase. I would like to leverage what you have mentioned above about how the address is made up of individual subfields.
I will be using the map report functionality to display mapping indicators for each of my client's data submission. In the map view, I do not want the numerical portion of the address to be displayed when hovering over the map indicator. How do I create a formula text field using the subfield? Thank you.
I found a formula for Excel but am having trouble applying it to quickbase. I inserted the field I saw mentioned in part of the discussion about using Address: Street 1.
------------------------------
Shuma Chaudhuri
------------------------------
I will be using the map report functionality to display mapping indicators for each of my client's data submission. In the map view, I do not want the numerical portion of the address to be displayed when hovering over the map indicator. How do I create a formula text field using the subfield? Thank you.
I found a formula for Excel but am having trouble applying it to quickbase. I inserted the field I saw mentioned in part of the discussion about using Address: Street 1.
LEFT([Address: Street 1],1),"",LEFT([Address: Street 1],FIND(" ",[Address: Street 1])-1)
------------------------------
Shuma Chaudhuri
------------------------------
- I can certainly help you with a formula, but I don't think there is a way with either the native Maps or the 3rd Party Add On from Juiced Technologies to not show the full address.
But let us know if you need help with an address based formula with an example of the format if the result. Maybe that would still be useful for you on a regular vanilla table report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
