Salesforce在自定义按钮中写查询，插入，更新_salesforce 自定义按钮更新数据-优快云博客

这篇博客介绍了如何在Salesforce中利用自定义按钮进行查询操作，当Opportunity的Probability达到90%且无主要联系人时，创建ContractNew__c对象并更新Opportunity的状态。如果转换成功，会弹窗提示并跳转到新创建的记录详情页；反之则显示错误信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

{!REQUIRESCRIPT("/soap/ajax/35.0/connection.js")} 
{!REQUIRESCRIPT("/soap/ajax/35.0/apex.js")}

if('{!Opportunity.GYZ_IsCheck__c}' == false)
{
if({!Opportunity.Probability} >= 90)  
{
   var opp= new sforce.SObject("OpportunityContactRole");
   var sql = "Select id,Name,(Select Id,IsPrimary From OpportunityContactRoles where IsPrimary = true) From Opportunity Where Id = '{!Opportunity.Id}'";
   var record = sforce.connection.query(sql).getArray("records");
   //var query = sforce.connection.query(sql).getArray("records")[0].RecordType.Name;
   if(record[0].OpportunityContactRoles == null)
   {
      alert('没有主要联系人，不能转换');
   }
   else
   {
      if(window.confirm('确定要转换成合同吗？'))
      {
         var con = new sforce.SObject("ContractNew__c");
         con.Account__c = "{!Opportunity.AccountId}";
         con.Project__c = "{!Opportunity.Exhibition_ManagementId__c}";
         con.Opportunity__c = "{!Opportunity.Id}";


         var result = sforce.connection.create([con]);
 
         if(result[0].success == 'true')
         {
            alert('转换成功');
            var o = new sforce.SObject("Opportunity");
            o.Id = '{!Opportunity.Id}';
            o.GYZ_IsCheck__c = true;
            var updateResult = sforce.connection.update([o]);
            if(updateResult[0].getBoolean(“success”))
            {
                   alert('更新成功');
                   window.open('/' + result[0].id);
            }
        }
         else
         {
            alert('转换失败');
         }
      }
   }
}
else
{
   alert('可能性低于百分之九十，不允许转换');
}
}
else
{
   alert('已经转换，请勿再次转换');
}