Skip to main content
Question

How to make a record unique

  • January 12, 2021
  • 0 replies
  • 38 views

I have a table with multiple columns in it. Each column may have repeated values but each record (a row) must not be repeated. Is there any way to make this possible ?

------------------------------
Aswin Babu
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
np,
just make a formula which will concatenate the fields together and mark it as Unique in field properties.

List("-", [field 1], [Field 2], [field 3])

note that you make not use lookup or summary fields in that formula.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------