There are certain fields that you never want to contain duplicate values. This might be a field containing the Employee ID or Invoice Number. You can easily prevent a field from having duplicate values by making it unique. In other words, for each record, the value in the field must be different.
To make a field unique:
In the Basics section, select the Must be unique check box.
Note: You can't make a List - User field unique. The check box does not appear in properties for this type of field.
© 1999-2019 QuickBase, Inc. All rights reserved. Legal Notices.