Using DeleteRecord in a table-level script

This example uses the DeleteRecord() function in a table-level script. The script checks whether there are any outstanding leads associated with a person when a Person record is deleted. If there are any outstanding leads, a message is displayed.

1. Go to <My Profile> | Administration | Customization | Person | TableScripts.
2. Click New, and then create a new table-level script.
   For more information about the options you need to complete, see Creating a script.
   When creating your script, do the following:
   • From Script Type, select Table Level.
   • In Table Script, within the function DeleteRecord section, enter the following script:
   Copy

   function DeleteRecord() 
   { 
       var ThisPersonId = CRM.GetContextInfo('person','pers_personid'); 
       var sCriteria = "lead_primarypersonid="+ThisPersonId+" and lead_deleted is null and lead_status <> 'Opportunity'";
       var LeadRecord = CRM.FindRecord("Lead",sCriteria); 
       if(!LeadRecord.eof) 
       { 
           CheckLocks=false; ErrorStr='There are outstanding leads'; 
           Valid = false; 
       }
   }

3. Click Save.

Open a Person record that has an associated Lead and then delete the Person record. The warning message is displayed.