Aimee_LaBree_H1

Hi Sanford- thank's for replying! I am still getting some strange behavior and I have some complex logic - hoping you can help pick through this with me! If I run cascading Smart campaigns (00 calls 02, 02 calls 03, etc.) I run into picklist values getting put into the string field multiple times. I think I solved partly by NULL-ing the value of the String picklist field first (in 00 campaign) before concatenating, but it's still giving me some flack and I think it's because I'm attempting to update a 2:1 value for the the picklist field using choice steps. I'm working with: --7 Boolean fields : "Opt-in A Boolean field", "Opt-in B Boolean field", etc., etc. --1 String picklist field : "Opt-in Picklist field" with optional values A,X,Y,Z A boolean true= A on picklist B and/or C boolean true = X on picklist D and/or E boolean true = Y on picklist F and/or G boolean true = Z on picklist. -so- Campaign 00) Smart List: a Trigger that looks for all "Opt-in Boolean field" data changes. Flow: --NULL the "Opt-in Picklist field" --Use choice steps: if "Opt-in A Boolean field" = TRUE, change "Opt-in PIcklist field" to A Default - nothing --Request Campaign 2 Campaign 02) Smart List: requested Flow: --Use choice steps: Choice 1: if "Opt-in B Boolean field"=TRUE, change "Opt-in Picklist field" to {{lead.Opt-in Picklist Field}}; X Choice 2: if "Opt-in C Boolean field"=TRUE, change "Opt-in Picklist field" to {{lead.Opt-in Picklist Field}}; X Default - nothing -Request Campaign 3 Campaign 03) Smart List: requested Flow --Use choice steps: Choice 1: if "Opt-in D Boolean field"=TRUE, change "Opt-in Picklist field" to {{lead.Opt-in Picklist Field}}; Y Choice 2: if "Opt-in E Boolean field"=TRUE, change "Opt-in Picklist field" to {{lead.Opt-in Picklist Field}}; Y Default - nothing Campaign 04) Smart List: requested Flow --Use choice steps: Choice 1: if "Opt-in F Boolean field"=TRUE, change "Opt-in Picklist field" to {{lead.Opt-in Picklist Field}}; Z Choice 2: if "Opt-in G Boolean field"=TRUE, change "Opt-in Picklist field" to {{lead.Opt-in Picklist Field}}; Z Default - nothing It holds all previous values in the picklist, but is doubling values even if the person doesn't qualify... Does this flow look correct? I can't see what I might be missing Any help appreciated! ... View more

Hi Lynn! I'm wondering if you might be able to explain a bit more about how you did this with boolean Marketo fields? I can't quite figure out how to update Boolean True/False fields in Marketo to custom picklist field options in a custom Salesforce field ... Any help appreciated. ... View more