Force Unique Address

  • 0
  • 1
  • Question
  • Updated 3 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

  • 680 Points 500 badge 2x thumb

Posted 3 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,436 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

  • 680 Points 500 badge 2x thumb

Okay, thank you.