Assigning user without duplication.

  • 1
  • Question
  • Updated 3 years ago
  • Answered
I'm trying to create a "team" using several look up fields and I need to create a filter/condition that prevents from the same lead user from being assigned more than once. Any advice on how to achieve this?
Photo of Kyle Mathis

Kyle Mathis

  • 576 Points 500 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
I'm not too clear what you are trying to do.  But if you have fields "LookupA, LookupB, LookupC and LookupD" on your object to make the team, and each of them look up to Lead,  I believe you can make a validation rule in core salesforce that there cannot be duplicates in your lookup fields.  If this is not right - give me some more details about how you are building your team. 
Photo of Kyle Mathis

Kyle Mathis

  • 576 Points 500 badge 2x thumb
Thanks for the reply, we were able to fix this.