2 Replies Latest reply on Nov 5, 2015 10:01 AM by Mel Dadoly

    Change data value to null

    Eli Haugen

      Our organization just enabled Salesforce state/country picklists. This is causing a problem when a lead comes into Marketo with a state other than null where the country is not United States or Canada (or a handful of others). The lead (or updates) won't sync to Salesforce because they don't have a valid state, which is null in this case. I have a smart campaign to catch these, but when I set the flow to Change Data Value, Attribute is State, and new value is left blank, it doesn't fire when it should. Is there a way to express the null value so that this will work?

        • Re: Change data value to null
          Tim Langlois

          HI Mary,


          I'm not quite following exactly what you're trying to do, but you may just need to type "NULL" into the Change Data Value flow step instead of leaving it blank..


          To prevent this issue altogether, I'd suggest hiding the State field in a Marketo form unless the Country selected is United States or Canada. You can do that via the visibility rules in your form.



          2 of 2 people found this helpful