Forum Discussion
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
The way we were trying to approach this is to add a new field called Protected Address as a formula text field. Then for the formula, we were trying to use the Part function. For Kirk, the formula is working, where the house # is not included in this new field. But I can't get the formula to work.
Example Address
111 Main Street, Boston MA 12345
Here is the formula that Kirk had:
Part([Address: Street 1], 2, " ") & " " & Part([Address: Street 1], 3, " ") & " " & Part([Address: Street 1], 4, " ") & " " & Part([Address: Street 1], 5, " ")
His result was:
Main Street, Boston, MA 12345
But for me, my result comes back:
Main Street
The hope was that once we got this formula working, then I could configure the map report to display this new "Protected
Address" field rather than the "Address" field.
​
------------------------------
Shuma Chaudhuri
------------------------------
- MarkShnier__You4 years agoQrew ChampionHere is what I suggest. The Maps report required an Address Field type. Unfortunately, there is no such field type as a Formula Address field.
You can use that formula to create street Address 1 without the numeric portion.
'
Then make a new Address field called [Address for Mapping].
Then using a form rule or an Automation or both, populate that [Address for Mapping] field and map that. if you populate all fields including the postal code= there is a good chance that it will map correctly.
Feel free to post back if you have have trouble with the form rule or Automaton. There is also a way to get an Automation to run though all your existing addresses (assuming that you already have a lot of addresses records to populate the [Address for Mapping] field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------