Skip to main content
Solved

How to enforce unique field values.

  • November 20, 2023
  • 3 replies
  • 135 views

woodsie
Silver Active Participant
  • Silver Active Participant
  • 3 replies

WE have frequent issue where team members are creating duplicate customers and other objects in our instance and need to enforce unique values on certain fields is there a formula available to do this?

Best answer by Limori

Hi,

With the creation of objects you have the flexibility to create the same objects with the same name… it is only their ID that is unique (for users it is the user name).

To enforce unique values, you will need to create validation / workflow rules or use a custom action on the specific object, e.g. Customer object, to prevent the creation of a customer with the same name of an already existing customer.

I would recommend to speak to your Professional Services Consultant for assistance.

This topic has been closed for replies.

3 replies

Limori
Planview Falcons
Forum|alt.badge.img+4
  • Planview Falcons
  • 75 replies
  • Answer
  • November 20, 2023

Hi,

With the creation of objects you have the flexibility to create the same objects with the same name… it is only their ID that is unique (for users it is the user name).

To enforce unique values, you will need to create validation / workflow rules or use a custom action on the specific object, e.g. Customer object, to prevent the creation of a customer with the same name of an already existing customer.

I would recommend to speak to your Professional Services Consultant for assistance.


edwardlau
  • 1 reply
  • November 21, 2023

@woodsie - I do that very same validation, and have it configured as such:
 

 


woodsie
Silver Active Participant
  • Author
  • Silver Active Participant
  • 3 replies
  • November 21, 2023

@woodsie - I do that very same validation, and have it configured as such:
 

 

Thanks @edwardlau I assumed that this would have been a fairly common problem and someone would have a functional solution such as this.