Skip to main content
Question

Prevent Duplicate Table Records

  • October 12, 2021
  • 0 replies
  • 114 views

Hello Colleagues

How can I prevent duplicate records from entering my table?

I don't see how to do it with automation.

------------------------------
Jaime Fonseca
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • October 12, 2021
The low tech solution is to create a formula text field which defines duplication and mark it as being unique in field properties.

for example List ("-", [first name], [last name], totext([phone]))

ie you need to know what defines unique / duplicate

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------