Address Importing Best Practices
Hello, looking to crowd source some best practices for importing and standardizing addresses in Quickbase. I know QB uses MapBox but they have some odd formatting practices. For example, they spell ...
Forum Discussion
Thanks Don, this sounds like good advice I'll have to look into it. How are your users adding individual addresses? Did you ever adopt the QB built-in address field?
I'm researching the Google Address Validation API and seeing if that can be incorporated into QB. It requires learning about QB Code Pages too unfortunately.
For my address duplication check I'm using 2 parts. The first is a formula field that combines all of the necessary elements of the address. The second is then a custom data rule on the table that alerts the user if they are trying to enter a duplicate address.
QB won't run a duplication check on a formula field and my end users won't have the option to bulk import additional addresses. The workflow will only require them to enter a few addresses here and there.
------------------------------
David Semitekol
------------------------------
I'm researching the Google Address Validation API and seeing if that can be incorporated into QB. It requires learning about QB Code Pages too unfortunately.
For my address duplication check I'm using 2 parts. The first is a formula field that combines all of the necessary elements of the address. The second is then a custom data rule on the table that alerts the user if they are trying to enter a duplicate address.
QB won't run a duplication check on a formula field and my end users won't have the option to bulk import additional addresses. The workflow will only require them to enter a few addresses here and there.
------------------------------
David Semitekol
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendDavid,
What do you mean by this?
QB won't run a duplication check on a formula field
You can have a Formula Query look for duplicates and that will happen even before the record is saved.
------------------------------
Mark Shnier (Your Quickbase Coach)
[email protected]
------------------------------