Announcement

Collapse

Information Needed

See more
See less

Upsert Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Upsert Error

    Hello!

    I received an e-mail with the following error and would appreciate help deciphering it.

    "Upsert failed. First exception on row 1; first error: DUPLICATE_VALUE, duplicate value found: Family_Member_Name_1__c duplicates value on record with id: 006G000000Yzrm1, Family_Member_Name_2__c duplicates value on record with id: 006G000000Yzrm1: []"

    On the checkout page, I have three additional fields for a person to enter the names of their family members if they select a family membership. The additional fields are mapped in Salesforce, and I've had someone select a family membership and include names without an error before. The contact mentioned already has a record, and the transaction was supposed to create a new opportunity linked to said contact. I can't help but feel this is really simple and I'm overthinking it.

    If needed, I granted access to org ID 00DG0000000jW5o.

  • #2
    Good day!

    We reviewed your account and noticed the following: (the error being reported also states this as it is alerting you of duplicate values)

    the fields you have defined are set to be unique (see below).

    Click image for larger version

Name:	Opp_Unique.jpg
Views:	1
Size:	78.8 KB
ID:	15505

    You are then mapping custom questions to these unique fields so if 2 people have the same name it will generate error. The uniqueness is across the entire Salesforce instance so family members that have the same name for different opportunities will generate an error.

    Click image for larger version

Name:	Opp_Mapping.jpg
Views:	1
Size:	71.7 KB
ID:	15506

    I hope you see the issue.

    Please let us know if we can be of any further assistance.
    Regards,
    Click & Pledge Support Department

    On Salesforce? Help us by rating our app: Click & Pledge Donor Management on AppExchange

    Join us @ the educational webinars: https://clickandpledge.com/webinars/
    Live Support available Join between 3:00 - 3:30 p.m. ET Monday - Thursday: https://clickandpledge.com/webinars/
    Are you on Salesforce? Join us at the Power of Us Hub: https://powerofus.force.com/0F980000000CjpC

    Comment


    • #3
      Ah! Seems easy enough to fix. Thanks so much for looking at it, the support you provide is very much appreciated.

      Comment

      Working...
      X