Skip to main content

Hi All,

 

We are using survey monkey to capture Prospect  based on survey . Once they completed the survey the Prospects along with survey responses will capture in sales cloud.

we will like to import only  if the question answer is yes then corresponding prospects will  transferred to CRM.

 

Is there any possibility or workaround to achieve this?.

 

Regards,

Siva Ragula.

3 件のコメント
  1. 2019年8月6日 11:44

    Hello everyone,

    Somehow i have tried with this code and i tired also using bulk upload and its is working without any error.

    Can someone let me know if i need to modify anything ?.

    trigger deletesurvey1 on Survey_response__c (After insert) {

    if(Trigger.isAfter){

    //if (Trigger.isDelete){

    Survey_response__c[] AllChildRecords = [Select id, Lead__c From Survey_response__c Where Survey_Question__c=:Label.Question and Response__c=:Label.Response];

    List<id>leadlist= New List<id>();

    if(AllChildRecords.size()>0){

    for(Survey_response__c rec : AllChildRecords){

    leadlist.add(rec.Lead__c);

    }

    }

    List<Survey_response__c>surveyres= New List<Survey_response__c>();

    for(Survey_response__c rec1 : [select id from Survey_response__c where Lead__c IN:leadlist]){

    surveyres.add(rec1);

    }

    delete surveyres;

    delete [select id from Lead where id IN :leadlist]

0/9000