You need to sign in to do that
Don't have an account?
Faizan Ali 24
Could anyone help me with my trigger please - System.NullPointerException
I am trying to fire this trigger:
trigger Autofill on Event (before insert, before update) {
for (Event e : Trigger.new)
{
boolean flag = (e.Appointment_with__c==null)?true:false;
if(flag){
String [] str = e.Appointment_with__c.split(' ');
List<Contact> cont = [SELECT Id FROM Contact WHERE FirstName =:str[0] AND LastName =:str[1]];
e.Staff__c = cont[0].Id;
}
}
But I keep getting this error and I don't know how to fix it at all:
Autofill: execution of BeforeInsert caused by: System.NullPointerException: Attempt to de-reference a null object Trigger.Autofill: line 10, column 1
trigger Autofill on Event (before insert, before update) {
for (Event e : Trigger.new)
{
boolean flag = (e.Appointment_with__c==null)?true:false;
if(flag){
String [] str = e.Appointment_with__c.split(' ');
List<Contact> cont = [SELECT Id FROM Contact WHERE FirstName =:str[0] AND LastName =:str[1]];
e.Staff__c = cont[0].Id;
}
}
But I keep getting this error and I don't know how to fix it at all:
Autofill: execution of BeforeInsert caused by: System.NullPointerException: Attempt to de-reference a null object Trigger.Autofill: line 10, column 1
Greetings!
Seeme like the list "cont" is null/doesn't have any records due to which you are getting the error.
I would suggest you to change the code as suggested in the article (https://help.salesforce.com/articleView?id=000327918&type=1&mode=1) to get the user friendly error message.
Kindly mark it as best answer if it helps so that it can help others in the future.
Warm Regards,
Shirisha Pathuri