You need to sign in to do that
Don't have an account?
Sandy Gali
custom button not working - sforce.connection.update
Hi Guys,
I wrote a piece of code which checks few condtions and updates a field in the end but the update is not working.
Below is the code. It goes in to the else block but DevIncidientSubmit__c is not getting updated.
Any help in this regards is appreciated.
{!REQUIRESCRIPT("/soap/ajax/29.0/connection.js")}
{!requireScript("/soap/ajax/29.0/apex.js")}
var SQLu = "Select Id,Drive_Guest_Count__c,Travel_Sector_Count__c,Status__c,DevIncidientSubmit__c from Application__c where id='{!Application__c.Id}'";
var flag = false;
var application = new sforce.SObject("Application__c");
result = sforce.connection.query(SQLu);
records = result.getArray("records");
for(i=0; i < result.getArray("records").length; i++)
{
if (result.getArray("records")[i].Travel_Sector_Count__c <= 0.0 && result.getArray("records")[i].Drive_Guest_Count__c == "true")
{
alert("Please enter at least one travel sector and one drive guest application");
}
else if(result.getArray("records")[i].Drive_Guest_Count__c == "true" )
{
alert("Please enter at least one drive guest application application");
}
else if (result.getArray("records")[i].Travel_Sector_Count__c <= 0.0)
{
alert("Please enter at least one travel sector application");
}
else
{
alert("In final else");
result.getArray("records")[i].DevIncidientSubmit__c = "True";
}
}
sforce.connection.update(result.getArray("records"));
alert("The value of getarray is"+result.getArray("records"));
location.reload();
I wrote a piece of code which checks few condtions and updates a field in the end but the update is not working.
Below is the code. It goes in to the else block but DevIncidientSubmit__c is not getting updated.
Any help in this regards is appreciated.
{!REQUIRESCRIPT("/soap/ajax/29.0/connection.js")}
{!requireScript("/soap/ajax/29.0/apex.js")}
var SQLu = "Select Id,Drive_Guest_Count__c,Travel_Sector_Count__c,Status__c,DevIncidientSubmit__c from Application__c where id='{!Application__c.Id}'";
var flag = false;
var application = new sforce.SObject("Application__c");
result = sforce.connection.query(SQLu);
records = result.getArray("records");
for(i=0; i < result.getArray("records").length; i++)
{
if (result.getArray("records")[i].Travel_Sector_Count__c <= 0.0 && result.getArray("records")[i].Drive_Guest_Count__c == "true")
{
alert("Please enter at least one travel sector and one drive guest application");
}
else if(result.getArray("records")[i].Drive_Guest_Count__c == "true" )
{
alert("Please enter at least one drive guest application application");
}
else if (result.getArray("records")[i].Travel_Sector_Count__c <= 0.0)
{
alert("Please enter at least one travel sector application");
}
else
{
alert("In final else");
result.getArray("records")[i].DevIncidientSubmit__c = "True";
}
}
sforce.connection.update(result.getArray("records"));
alert("The value of getarray is"+result.getArray("records"));
location.reload();