Announcement

Collapse

Information Needed

See more
See less

Issue mapping blank value to a checkbox

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

  • Issue mapping blank value to a checkbox

    I have set up the following mapping, but incoming transactions are not processing successfully and I'm getting the following error: "Update failed. First exception on row 0 with id 0031U00001wtFCgQAM; first error: INVALID_TYPE_ON_FIELD_IN_RECORD, Conservation Only: value not of required type: : [Conservation_Only__c]--null--3721--(CnP_PaaS)--System.DmlException"

    Click image for larger version

Name:	custom mapping - blank to a checkbox.png
Views:	19
Size:	7.8 KB
ID:	61694

    Is it not possible to uncheck a checkbox (set it to false) using the C&P custom mapping tool?
    Please note- I have deleted the above mapping for now since it was causing issues with incoming transactions.

    Order Number: 61431-2111161649525643858

    Org ID: 00D1U000000EMG8

  • #2
    Kai Addae ,

    Yes, it is possible to uncheck a checkbox with custom mapping. You simply set the condition that would set the field to be blank so that the answer is FALSE.

    I see that you have the Custom Mapping set to either answer 'Yes' or 'No', which may work, I know checkboxes can usually accept TRUE/FALSE, or 1/0 - not sure about Yes/No.
    I typically use TRUE/FALSE.

    The Contact related to the Order has the "I would like to receive updates about the A.T. and the ATC." marked as Yes, and the transaction has processed now. I suspect either someone on our team has corrected this for you, and hasn't responded just yet, or you figured it out already.

    Let us know if this is still not what you expected.

    ~ Amanda
    C&P Customer Advocate
    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
      Hi Amanda,

      The field that was mapped and SHOULD have updated to 'false' is the "Conservation Only" checkbox, which you'll see was not updated.
      I want to map the answer of 'Yes' on a custom question to uncheck the Conservation Only checkbox in Salesforce, so I can't set those values to FALSE/TRUE or it won't make sense for the user.

      Comment


      • #4
        My apologies, you're right. I was thinking of the way it worked in an older release.

        I'm testing again.

        ~ Amanda
        C&P Customer Advocate
        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


        • #5
          I will bring this up with our Development team and give you a status by tomorrow morning. (I removed the rule I created for testing)

          ~ Amanda
          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


          • #6
            Good day @Kai Addae

            I see that the following option is causing an issue "Replace answer with blank" check box in mapping. I have forwarded it to our developers to see what is going on.

            However, you can use "Replace text with**" option to uncheck the Conservation Only field as shown below:

            Click image for larger version

Name:	CustomQ1.jpg
Views:	8
Size:	71.8 KB
ID:	61713


            In order to check the Conservation Only field, you can set the "Replace text with**" checked as shown below:

            Click image for larger version

Name:	CustomQ2.jpg
Views:	6
Size:	75.9 KB
ID:	61714

            Please test it and let us know if you find any issues.
            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


            • #7
              Good day @Kai Addae

              We have identified the issue. It is only with the Contact object. Account and Opportunity object mapping has no issues with "Replace answer with blank".

              We will address the issue in the next release.

              Sorry for the inconvenience.
              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

              Working...
              X