How To Create A Rule To Warn A User When Creating/Editing A Record With A Field That Is Not Unique

Hi.

How to create a rule that will prompt a user to continue or cancel when creating a record with an ID Number that is not unique.

Hello! One option is to require that the field have a unique value. This can be done in the Options tab of the field setup.

If the field requires a unique value then users will not be able to submit a record that has a duplicate value for the field. This is particularly useful for custom ID fields, account codes, and similar values.