I have a lookup field in my opportunity object. It is not available in page layout for some user, but they should able to clear this value of this field.
I have created a custom button with javascript, but it not working as expected. Kindly help me. CDH_Account__c - lookup field.
{!REQUIRESCRIPT("/soap/ajax/13.0/connection.js")}
var opptyObj = new sforce.SObject("Opportunity");
opptyObj.Id = '{!Opportunity.Id}';
opptyObj.CDH_Account__c = "";
var result = sforce.connection.update([opptyObj]);
if (result[0].success=='false') {
alert(result[0].errors.message);
} else {
location.reload(true);
}