Exception: Request failed for https://docs.google.com returned code 400. Truncated server response: <!DOCTYPE html><html lang="en" class="m2"><head><link rel="shortcut icon" sizes="16x16" href="https://ssl.gstatic.com/docs/spreadsheets/forms/favic...

287 views

Skip to first unread message

Kamal Kant

unread,

Jun 23, 2020, 5:00:26 AM6/23/20

to Clio Developers

function BajajBMT() {

var wrkBK = SpreadsheetApp.getActiveSpreadsheet();
var wrkSht = wrkBK.getSheetByName("Client New");

var formURL = "";
var formData = "";

var empname = "";
var bcode = "";
var ucode = "";
var medate = "";
var natureOactivity = "";
var custname = "";
var custmo = "";
var custage = "";
var pincode = "";
var nanalysis = "";
var product = "";
var premium = "";
var statusofclosure = "";
var objectionbyprospect = "";
var nextmeeting = "";
var meetingwith = "";

var noOfrow = 10;
for (i=2;i<=noOfrow;i++)
    {
      empname = wrkSht.getRange("A" + i).getDisplayValue();
      bcode = wrkSht.getRange("B" + i).getDisplayValue();
      ucode = wrkSht.getRange("C" + i).getDisplayValue();
      medate = wrkSht.getRange("D" + i).getDisplayValue();
      natureOactivity = wrkSht.getRange("E" + i).getDisplayValue();
      custname = wrkSht.getRange("F" + i).getDisplayValue();
      custmo = wrkSht.getRange("G" + i).getDisplayValue();
      custage = wrkSht.getRange("H" + i).getDisplayValue();
      pincode = wrkSht.getRange("I" + i).getDisplayValue();
      nanalysis = wrkSht.getRange("J" + i).getDisplayValue();
      product = wrkSht.getRange("K" + i).getDisplayValue();
      premium = wrkSht.getRange("L" + i).getDisplayValue();
      statusofclosure = wrkSht.getRange("M" + i).getDisplayValue();
      objectionbyprospect = wrkSht.getRange("N" + i).getDisplayValue();
      nextmeeting = wrkSht.getRange("O" + i).getDisplayValue();
      meetingwith = wrkSht.getRange("P" + i).getDisplayValue();

      formURL = "https://docs.google.com/forms/d/e/1FAIpQLSeBBwNEH_KYkuK9g1j-nOWlHe2rPiDCxtkqywNynn7Fi7tdLA/formResponse?&pageHistory=0,1,2,3"
      formData = "&entry.307673190="+ empname + "&entry.1375157305="+ bcode + "&entry.1739932131="+ ucode + "&entry.213536528="+ medate + "&entry.1461161469="+ natureOactivity + "&entry.878934813="+ custname + "&entry.1214135722="+ custmo + "&entry.719267355="+ custage + "&entry.1614088616="+ pincode + "&entry.1143326720="+ nanalysis + "&entry.725369531="+ product + "&entry.878934813="+ premium + "&entry.1996896680="+ statusofclosure + "&entry.215379408="+ objectionbyprospect + "&entry.930385811="+ nextmeeting + "&entry.956130139="+ meetingwith


      var finalURL = formURL + formData ;
      var option = {
                    "method" : "post"
                   };

      UrlFetchApp.fetch(finalURL, option);

     };

}

Reply all

Reply to author

Forward

0 new messages