Skip to main content
Topics#CollaborationMichael Dely's Question
Michael Dely asked in #Collaboration
Feb 22, 2019, 2:46 AM

Task with Lookup Field Included (Related to User)

I am looking to add a lookup field to a task record type.  I would like to have the lookup field be related to a User.  Unfortunately I keep receiving a validation error that says, "Lookups on activites must have a unique domain. You can not have multiple relationships to the same object."  My goal is to have an "Approved By" lookup field that will only be viewable by three users.  They would click in the field and locate their name and then click save.  This would then move to the next individual to complete the process since it was approved.  What is the best way for me to get around this?  

 

Thanks, 

 

Michael 
1 answer
  1. John Knight (Recklessly Great, LLC)
    Feb 22, 2019, 4:39 AM
    Hi Michael, this seems to be a set SFDC limitation.  "no two fields can look up to the same type of record"

     

    https://releasenotes.docs.salesforce.com/en-us/winter15/release-notes/rn_sales_activities_activity_custom_lookups.htm

     

    I'm wondering if you can create a new custom object called approval that sits between the task and the user record.

     

    Then you could create a lookup from the task to the approval object and a lookup from the approval to the user.  

     

    I noticed that adding an actual approval process to tasks seems to not be an option either since this idea is still out there: https://success.salesforce.com/ideaView?id=08730000000BrQCAA0
Write an answer...
0/9000