Force Unique Address

  • 39
  • 1
  • Question
  • Updated 5 months ago
  • Answered
I'm wondering how to force a database to only allow unique addresses?  I have a database and when addresses are added, I want to make sure that the addresses isn't already in the database and if it is, I want that one picked.  How can I do this?

Thanks,
Photo of cowannbell

cowannbell

  • 1,070 Points 1k badge 2x thumb

Posted 5 months ago

  • 39
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 57,308 Points 50k badge 2x thumb
For some reason, an address field type does not have the attribute to enforce unique.

But i think that you can make a text string that looks like an address and force it to be unique

List("\n",
[Address: Street 1],
[Address: Street 2],
List("  ", List(", ",[Address: City],[Address: State/Region]), [Address: Postal Code]))
Photo of cowannbell

cowannbell

  • 1,070 Points 1k badge 2x thumb

Okay, thank you.