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
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)
mark.shnier@gmail.com
------------------------------
Hi Mark, I'm referring to the "Must be unique" checkbox in the field settings. Here is my formula:
When I did some research, I came across this post in the community:
Enforcing Uniqueness on a Formula Field
------------------------------
David Semitekol
------------------------------
List(ToText([Number Start]),ToText([Number End]),[Address Number],[Predirectional],[Street Name],[Suffix],[Post Directional])
When I tried to save the field, I got this error:
When I did some research, I came across this post in the community:
Enforcing Uniqueness on a Formula Field
------------------------------
David Semitekol
------------------------------