You need to sign in to do that
Don't have an account?
Date Function on Custom Case Button
Hi, I'm trying to create an escalation button in which a Level 2 analyst will use it to escalate his case to a level 3 analyst.
After doing so some fields should be updated, name, role and the date the escalation was done.
{!requireScript('/soap/ajax/20.0/connection.js')}
try{ var update_Case = new sforce.SObject('Case'); update_Case.Id = '{!Case.Id}'; update_Case.Disable_Change_Owner_Validation__c = new Date(); update_Case.Escalated_By_Name__c = '{!$User.FirstName} {!$User.LastName}'; update_Case.Esclated_By_Role__c ='{!$UserRole.Name}';update_Case.Escalated_on__c ={!DATEVALUE(NOW())};update_Case.OwnerId = "00G00000006pPTc" ;var updateRecords = []; updateRecords.push(update_Case); var resultUpdate = sforce.connection.update(updateRecords); if (resultUpdate[0].getBoolean("success")) { parent.location.href = "/" + '{!Case.Id}'; }else{ alert(resultUpdate[0].errors.message); } }catch(err){ alert(err.description); }
As you can see, I created a javascript button but I'm having problems with the date field. The field is called Case.Escalated_on__c and is a date one. How whould I insert the date of the moment the button was clicked? I tried Now, Today. Nothing worked. I get a weird number 0.11545444666
Can someone help?
Thanks
Tzuvy
Create a hidden formula date field or date-time field on the page that returns Today() or Now() respectively. Then reference this in your button. I believe the reson that this is not working is because Salesforce thinks you are trying to reference a field that is not there. This is just a workaround that I believe will work for you as I do not know much coding.