• moringd
  • NEWBIE
  • 0 Points
  • Member since 2011

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 4
    Questions
  • 0
    Replies

I need a region formula based off states and countries, but for New York and New Jersey it is also based of the account name that starts with #-J and K-Z?  Here is what im working with, but i know its not right.The bold area is what needs to be fixed. Any help would be amazing.

 

IF(LEN(BillingState)=0, "None",
IF(CONTAINS("WA:OR:CA:AZ:NM:TX:HI:AK", BillingState), "West",
IF(CONTAINS("ID:NV:UT:MT:WY:CO:ND:SD:NE:KS:OK:MN:IA:MO:AR", BillingState), "Central",
IF(CONTAINS("LA:TN:MS:AL:FL:GA:SC:NC:VA:WV:DC:MD:DE:PA", BillingState), "Southeast",
IF(CONTAINS("PR", BillingCountry), "Great Lakes",
IF(CONTAINS("WI:IL:MI:IN:KY:OH", BillingState), "Great Lakes",
IF(CONTAINS("NY:NJ", BillingState), "East",
IF( BEGINS(Name, "A, B, C, D, E, F, G, H, I, J"), "East 1",
IF( BEGINS(Name, "K, L, M, N, O, P, Q, R, S, T, U, V, W, X, Y, Z"), "East 2",
IF(CONTAINS("AD:AL:AT:BA:BE:BG:BY:CH:CZ:DE:DK:EE:ES:FI:FO:FR:FX:GB:GI:GR:HR:HU:IE:IS:IT:LI:LT:LU:LV:MC:MD:MK:MT:NL:NO:PL:PT:RO:SE:SI:SJ:SK:SM:UA:VA:CS:UK", BillingCountry), "East",
IF(CONTAINS("CA:JM", BillingCountry), "Central",
IF(CONTAINS("CT:RI:MA:NH:VT:ME", BillingState), "New England", "Other"))))))))))))

is it possible to select multiple campaigns within a web-to-lead form?

 

For example, i would i like to use so that if a prospect want to request multiple webinar replays, they can do it from one form and not have to fill out a form everytime.

Does anyone know if there is a way to have the notification email sent to multiple recipients?  Or can it onle sent to one.

Does anyone know the code or if it is possible to populate a Campaign Member Custom Fields via the web-to-lead form?

 

If so, can someone share some sample code?  I have been tryiing all day and cannot make it work.