You need to sign in to do that
Don't have an account?
Nertin Hoxha
Help Bulkifying this before-Trigger with error-message.
trigger DuplicateService on Site__c (before insert) { for(Site__c B : Trigger.New) { try { Integer i = [SELECT count() FROM Site WHERE Account__c = :B.Account__c AND RecordTypeId = :B.RecordTypeId]; if (i > 0) { String RT = [SELECT Name FROM RecordType WHERE Id = :B.RecordTypeId].Name; String TS = [SELECT Name FROM Site__c WHERE Account__c = :B.Account__c AND RecordTypeId = :B.RecordTypeId].Name; B.addError('Already existing ' + RT + ': <<<' + TS + '>>>, !!'); } } catch (DmlException e) { System.debug('Trigger DuplicateService: ' + e.getMessage()); } } }
Best Answer chosen by Nertin Hoxha
Amit Chaudhary 8
Try to update your code like below
Let us know if this will help you