Apex Code Development You need to sign in to do that
Don't have an account?
matthew.field Need help with determining if an attachment is null
I am working on a project to create a VF page where the user can add multiple attachments when creating a record. I found some code online that allows me to do this, but it will return the following error "System.DmlException: Insert failed. First exception on row 1; first error: REQUIRED_FIELD_MISSING, Required fields are missing: [File Name, Body]: [File Name, Body]" if a file isn't chosen for all 3 attachment selections. Users may only need to attach 1 or 2 files to a record. I need to find a way to determine if any of the selections are null and if they are to tell the system not to expect to see anything there. My class and VF page are listed below:
APEX CLASS
VF Page
Thanks,
Matt
APEX CLASS
public class AddMultipleAttachments {
public Incident_Reports__c objIncidentReport { get; set; }
public Attachment attachment1 { get; set; }
public Attachment attachment2 { get; set; }
public Attachment attachment3 { get; set; }
public AddMultipleAttachments (ApexPages.StandardController stdController)
{
// Record and Attachments to be inserted
objIncidentReport = new Incident_Reports__c();
attachment1 = new Attachment();
attachment2 = new Attachment();
attachment3 = new Attachment();
}
public PageReference createRecordAndAttachments()
{
// Insert the record
insert objIncidentReport;
// Insert Attachments;
attachment1.ParentId = objIncidentReport.Id;
attachment2.ParentId = objIncidentReport.Id;
attachment3.ParentId = objIncidentReport.Id;
insert new List<Attachment> { attachment1, attachment2, attachment3 };
// View the record
PageReference page = ApexPages.currentPage();
page.setRedirect(true);
return page;
}
}
VF Page
<apex:page standardController="Incident_Reports__c" extensions="AddMultipleAttachments">
<apex:sectionHeader title="Property Incident Reports Edit" subtitle="{!Incident_Reports__c.Name}"/>
<apex:form >
<apex:commandButton value="Save" action="{!save}"/>
<apex:commandButton value="Save with Attachments" action="{!createRecordAndAttachments}"/>
<apex:commandButton value="Cancel" action="{!cancel}"/>
<apex:pageBlock title="Property Incident Reports Edit" mode="edit" id="thePageBlock">
<apex:pagemessages />
<apex:pageBlockSection columns="1">
<apex:outputText value="ATTENTION: Attorney work product/privileged document (for internal use only). NOT for Associate Injuries, use Worker's Comp Incident Report." style="font-weight:800"/>
<apex:outputText value="RED LINES REPRESENT REQUIRED FIELDS" style="color:red" />
</apex:pageBlockSection>
<apex:pageBlockSection title="Property Information" columns="2">
<apex:inputField value="{!Incident_Reports__c.Property__c}" required="true"/>
</apex:pageBlockSection>
<apex:pageBlockSection title="Claimant Information" columns="2">
<apex:inputField value="{!Incident_Reports__c.Claimant_s_Name__c}" required="false"/>
<apex:inputField value="{!Incident_Reports__c.Claimant_s_Gender__c}" required="false"/>
<apex:inputField value="{!Incident_Reports__c.Claimant_s_Address__c}" required="false"/>
<apex:inputField value="{!Incident_Reports__c.Claimant_s_Age__c}" required="false"/>
<apex:inputField value="{!Incident_Reports__c.Claimant_s_Date_of_Birth__c}" required="false"/>
<apex:inputField value="{!Incident_Reports__c.Claimant_s_Phone_Number__c}" required="false"/>
<apex:inputField value="{!Incident_Reports__c.Claimant_s_Phone_Number_Other__c}" required="false"/>
<apex:inputField value="{!Incident_Reports__c.Claimant_s_Occupation__c}" required="false"/>
<apex:inputField value="{!Incident_Reports__c.Alliance_Associate__c}" required="false"/>
</apex:pageBlockSection>
</apex:pageBlock>
<apex:pageBlock title="Incident Information" mode="edit" id="Incident">
<apex:actionRegion >
<apex:pageBlockSection title="Incident Type" columns="1">
<apex:pageBlockSectionItem >
<apex:outputLabel value="Type of Incident"/>
<apex:outputPanel >
<apex:inputField value="{!Incident_Reports__c.Type_of_Incident__c}" required="TRUE">
<apex:actionSupport event="onchange" rerender="Incident" status="IncidentType"/>
</apex:inputField>
<apex:actionStatus startText="applying value..." id="IncidentType"/>
</apex:outputPanel>
</apex:pageBlockSectionItem>
</apex:pageBlockSection>
</apex:actionRegion>
<apex:actionRegion >
<apex:pageBlockSection title="Incident Information" columns="2">
<apex:inputField value="{!Incident_Reports__c.Date_Time_of_Incident__c}" required="false"/>
<apex:inputField value="{!Incident_Reports__c.Date_Time_Incident_Reported__c}" required="false"/>
<apex:inputField value="{!Incident_Reports__c.Pictures_Attached__c}" required="false"/>
<apex:inputField value="{!Incident_Reports__c.Property_Owner_Notified__c}" required="false"/>
<apex:pageBlockSectionItem helpText="Check this box if Police, Fire or Ambulance were dispatched to the property.">
<apex:outputLabel value="Emergency Services Called"/>
<apex:outputPanel >
<apex:inputField value="{!Incident_Reports__c.Emergency_Services_Required__c}" label="Check if Police, Fire or Ambulance were dispatched to the property.">
<apex:actionSupport event="onclick" rerender="Incident" status="status"/>
</apex:inputField>
<apex:actionStatus startText="applying value..." id="status"/>
</apex:outputPanel>
</apex:pageBlockSectionItem>
</apex:pageBlockSection>
</apex:actionRegion>
<apex:actionRegion >
<apex:pageBlockSection title="Responding Agencies" id="agencies" columns="2" rendered="{!Incident_Reports__c.Emergency_Services_Required__c == TRUE}">
<apex:pageBlockSectionItem >
<apex:outputLabel value="Police Department"/>
<apex:outputPanel >
<apex:inputField value="{!Incident_Reports__c.Police_Responded__c}">
<apex:actionSupport event="onclick" rerender="Incident" status="status1"/>
</apex:inputField>
<apex:actionStatus startText="adding Police Department block..." id="status1"/>
</apex:outputPanel>
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem >
<apex:outputLabel value="Fire Department"/>
<apex:outputPanel >
<apex:inputField value="{!Incident_Reports__c.Fire_Department_Responded__c}">
<apex:actionSupport event="onclick" rerender="Incident" status="status2"/>
</apex:inputField>
<apex:actionStatus startText="adding Fire Department block..." id="status2"/>
</apex:outputPanel>
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem >
<apex:outputLabel value="Ambulance Service"/>
<apex:outputPanel >
<apex:inputField value="{!Incident_Reports__c.Ambulance_Company_Responded__c}">
<apex:actionSupport event="onclick" rerender="Incident" status="status3"/>
</apex:inputField>
<apex:actionStatus startText="adding Ambulance Service block..." id="status3"/>
</apex:outputPanel>
</apex:pageBlockSectionItem>
<apex:pageBlockSectionItem >
<apex:outputLabel value="Other Emergency Service"/>
<apex:outputPanel >
<apex:inputField value="{!Incident_Reports__c.Other_Department_Responded__c}">
<apex:actionSupport event="onclick" rerender="Incident" status="status4"/>
</apex:inputField>
<apex:actionStatus startText="adding Other Emergency Service block..." id="status4"/>
</apex:outputPanel>
</apex:pageBlockSectionItem>
</apex:pageBlockSection>
</apex:actionRegion>
<apex:pageBlockSection title="Police Department Information" id="police" columns="2" rendered="{!Incident_Reports__c.Police_Responded__c == TRUE}">
<apex:inputField value="{!Incident_Reports__c.Police_Department_Name__c}" label="Police Department Name"/>
<apex:inputField value="{!Incident_Reports__c.Police_Report_Number__c}" label="Police Report Number"/>
</apex:pageBlockSection>
<apex:pageBlockSection title="Fire Department Information" columns="2" rendered="{!Incident_Reports__c.Fire_Department_Responded__c == TRUE}">
<apex:inputField value="{!Incident_Reports__c.Fire_Department_Name__c}" label="Fire Department Name"/>
<apex:inputField value="{!Incident_Reports__c.Fire_Dept_Report_Number__c}" label="Fire Dept. Report Number"/>
</apex:pageBlockSection>
<apex:pageBlockSection title="Ambulance Information" columns="2" rendered="{!Incident_Reports__c.Ambulance_Company_Responded__c == TRUE}">
<apex:inputField value="{!Incident_Reports__c.Ambulance_Company_Name__c}" label="Ambulance Company Name"/>
<apex:inputField value="{!Incident_Reports__c.Ambulance_Company_Report_Number__c}" label="Ambulance Co. Report Number"/>
<apex:inputField value="{!Incident_Reports__c.Hospital_Name__c}" label="Hospital Taken To (if applicable)"/>
</apex:pageBlockSection>
<apex:pageBlockSection title="Other Emergency Services" columns="2" rendered="{!Incident_Reports__c.Other_Department_Responded__c == TRUE}">
<apex:inputField value="{!Incident_Reports__c.Other_Respondant__c}" label="Other Department Name"/>
<apex:inputField value="{!Incident_Reports__c.Other_Report_Number__c}" label="Other Department Report Number"/>
</apex:pageBlockSection>
<apex:pageBlockSection title="Moisture / Flooding" columns="3" rendered="{!Incident_Reports__c.Type_of_Incident__c == 'Flood/Moisture'}" id="FloodingSection">
<apex:inputTextarea value="{!Incident_Reports__c.Affected_Area__c}" label="Describe Affected Area" cols="40" rows="8"/>
<apex:inputTextarea value="{!Incident_Reports__c.Source_Cause_of_Moisture__c}" label="Describe Cause of Moisture" cols="40" rows="8"/>
<apex:inputTextarea value="{!Incident_Reports__c.Personal_Property_Damage__c}" label="Detail Damage to Personal Property" cols="40" rows="8"/>
<apex:inputField value="{!Incident_Reports__c.Date_Notification_Letter_Sent__c}" label="Date Notification Letter Sent"/>
<apex:inputField value="{!Incident_Reports__c.Date_Option_Letter_Given__c}" label="Date Option Letter Given"/>
<apex:inputField value="{!Incident_Reports__c.Date_Option_Letter_Received__c}" label="Date Option Letter Received"/>
<apex:inputField value="{!Incident_Reports__c.Follow_Up_Call_Completed__c}" label="Date Follow-up Call Completed"/>
<apex:inputField value="{!Incident_Reports__c.Follow_Up_Call_Associate__c}" label="Name of Associate Conducting Call"/>
<apex:inputTextarea value="{!Incident_Reports__c.Result_of_Conversation__c}" label="Result of Conversation" cols="40" rows="8"/>
</apex:pageBlockSection>
</apex:pageBlock>
<apex:pageBlock title="Add Attachments">
<apex:pageBlockSection title="Attachment 1" >
<apex:inputFile value="{!attachment1.body}" fileName="{!attachment1.name}"/>
</apex:pageBlockSection>
<apex:pageBlockSection title="Attachment 2" >
<apex:inputFile value="{!attachment2.body}" fileName="{!attachment2.name}"/>
</apex:pageBlockSection>
<apex:pageBlockSection title="Attachment 3" >
<apex:inputFile value="{!attachment3.body}" fileName="{!attachment3.name}"/>
</apex:pageBlockSection>
</apex:pageBlock>
</apex:form>
</apex:page>
Any help will be greatly appreciated.Thanks,
Matt
I made some changes to your code. It will check to make sure that the attachment was entered before it tries to create it, therefore, if an attachment is not specified on the page, no errors will be thrown.
Also, I added some code to prevent half-saves. By half-save I mean that if the attachment insert fails for any reason, but the incident report did not fail, it will rollback all changes; the incident report will not save unless attachments save as well. This will prevent bad data in the system.
Here is the new controller code:
public class AddMultipleAttachments { public Task objIncidentReport { get; set; } public Attachment attachment1 { get; set; } public Attachment attachment2 { get; set; } public Attachment attachment3 { get; set; } public AddMultipleAttachments (ApexPages.StandardController stdController) { // Record and Attachments to be inserted objIncidentReport = new Task(); attachment1 = new Attachment(); attachment2 = new Attachment(); attachment3 = new Attachment(); } public PageReference createRecordAndAttachments() { Savepoint sp = Database.setSavepoint(); try { // Insert the record insert objIncidentReport; // Insert Attachments; List<Attachment> toInsert = new List<Attachment>(); if(attachment1.Name != null) { attachment1.ParentId = objIncidentReport.Id; toInsert.add(attachment1); } if(attachment2.Name != null) { attachment2.ParentId = objIncidentReport.Id; toInsert.add(attachment2); } if(attachment3.Name != null) { attachment3.ParentId = objIncidentReport.Id; toInsert.add(attachment3); } if(toInsert.size() > 0) insert toInsert; } catch(Exception ex) { Database.rollback(sp); ApexPages.Message msg = new ApexPages.Message(ApexPages.Severity.ERROR, ex.getMessage()); ApexPages.addMessage(msg); } // View the record PageReference page = ApexPages.currentPage(); page.setRedirect(true); return page; } }Good luck!
Thanks for the help!! I was able to save the new code in my sandbox, but for some reason, while the attachments are working as they should (not erroring out if there aren't three), the record is not being saved in the Incident_Reports__c object. Do you have any idea as to why this might be happening?
Thanks again,
Matt