Skip to main content
David Lashmanov (Provectus) 님이 #Data Management에 질문했습니다
IF([Opportunity].Lead_Opp_Product__c.Name ="AI Solutions", 01u1i000000sz4S, 

 

IF([Opportunity].Lead_Opp_Product__c.Name ="Data Lake Platform (DLP)", 01u1i000000sz4c, 

 

IF([Opportunity].Lead_Opp_Product__c.Name ="Streaming Data Platform (SDP)", 01u1i000000sz4c,

 

IF([Opportunity].Lead_Opp_Product__c.Name ="Data Analytics Platform on Apache Spark", 01u1i000000sz4h, 

 

IF([Opportunity].Lead_Opp_Product__c.Name ="Machine Learning Infrastructure", 01u1i000000sz4r, 

 

IF([Opportunity].Lead_Opp_Product__c.Name ="ML Model Management platform", 01u1i000000sz4w, 

 

IF([Opportunity].Lead_Opp_Product__c.Name ="PCI DSS / SOC2 / HIPPA compliant cloud (CC)", 01u1i000001eyUh, 

 

IF([Opportunity].Lead_Opp_Product__c.Name ="Microservices Migration", 01u1i000000sz56, 

 

IF([Opportunity].Lead_Opp_Product__c.Name ="CI/CD cloud (CICD)", 01u1i000000sz5B, 

 

IF([Opportunity].Lead_Opp_Product__c.Name ="Cloud Automation (CA)", 01u1i000000sz5C, 

 

IF([Opportunity].Lead_Opp_Product__c.Name ="Monitoring and metrics cloud (MMC)", 01u1i000000sz5H, 

 

IF([Opportunity].Lead_Opp_Product__c.Name ="Log aggregation cloud (LAC)", 01u1i000000sz5D, 

 

IF([Opportunity].Lead_Opp_Product__c.Name ="Cloud Cost optimisation (CCO)", 01u1i000000sz5E, 

 

IF(l[Opportunity].Lead_Opp_Product__c.Name ="Cloud Migration (CM)", 01u1i000001f0Id, 

 

IF([Opportunity].Lead_Opp_Product__c.Name ="Mobile Consulting", 1u1i000001eyV4, 

 

IF([Opportunity].Lead_Opp_Product__c.Name ="Custom Analytics (CA)", 01u1i000000sz5Q, 

 

IF([Opportunity].Lead_Opp_Product__c.Name ="Technology Consulting (TC)", 01u1i000000sz5V, 

 

IF([Opportunity].Lead_Opp_Product__c.Name ="QA Strategy (QAS)",01u1i000000sz4I, 01u1i000000sz3y))))))))))))))))))
답변 4개
  1. 2019년 4월 10일 오전 3:41

    You also need to put the record Id's in quotes (they're Text, not Numbers)  and Process Builder uses the full 18 character ID, not 15

    CASE([Opportunity].Lead_Opp_Product__c.Name,

    "AI Solutions", "01u1i000000sz4S",

    "Data Lake Platform (DLP)", "01u1i000000sz4c",

    "Streaming Data Platform (SDP)", "01u1i000000sz4c",

    "Data Analytics Platform on Apache Spark", "01u1i000000sz4h",

    "Machine Learning Infrastructure", "01u1i000000sz4r",

    "ML Model Management platform", "01u1i000000sz4w",

    "PCI DSS / SOC2 / HIPPA compliant cloud (CC)", "01u1i000001eyUh",

    "Microservices Migration", "01u1i000000sz56",

    "CI/CD cloud (CICD)", "01u1i000000sz5B",

    "Cloud Automation (CA)", "01u1i000000sz5C",

    "Monitoring and metrics cloud (MMC)", "01u1i000000sz5H",

    "Log aggregation cloud (LAC)", "01u1i000000sz5D",

    "Cloud Cost optimisation (CCO)", "01u1i000000sz5E",

    "Cloud Migration (CM)", "01u1i000001f0Id",

    "Mobile Consulting", "1u1i000001eyV4",

    "Custom Analytics (CA)", "01u1i000000sz5Q",

    "Technology Consulting (TC)", "01u1i000000sz5V",

    "QA Strategy (QAS)","01u1i000000sz4I",

    "01u1i000000sz3y")