新手技术问询：如何处理Apex表单提交的数据（禁用触发器）

Hey there! No worries at all—every Apex developer starts somewhere, and your question is totally valid. Since you can't use database triggers, we'll focus on handling the data right after form submission in your Apex controller or LWC-backed Apex logic. Let's break this down step by step:

1. 获取表单提交的数据 #

The first step is capturing the data users submit via your form. The approach depends on whether you're using Visualforce or Lightning Web Components (LWC):

Visualforce Controller Scenario #

If your form is built with Visualforce, you'll bind form fields to an sObject in your controller. When the user clicks "Submit", you can access the full record directly in your save method:

public class CustomFormController {
    // Bind this sObject to your Visualforce form fields
    public Custom_Submission__c newSubmission { get; set; }

    public CustomFormController() {
        // Initialize a blank record for the form
        newSubmission = new Custom_Submission__c();
    }

    public PageReference saveSubmission() {
        // At this point, newSubmission contains all user-entered data
        insert newSubmission;

        // Pass the saved record to your report generation logic
        generateTextReport(newSubmission);

        // Redirect to a confirmation page (optional)
        return Page.SubmissionConfirmation;
    }
}

LWC Scenario #

For LWC forms, you'll capture form fields in JavaScript, then pass them to an Apex method for processing:

import { LightningElement, track } from 'lwc';
import saveAndProcessSubmission from '@salesforce/apex/SubmissionHandler.saveAndProcessSubmission';

export default class SubmissionForm extends LightningElement {
    @track reportContent;

    handleSubmit(event) {
        event.preventDefault();
        const formFields = event.detail.fields;

        // Send form data to Apex for processing
        saveAndProcessSubmission({ submission: formFields })
            .then(reportContent => {
                this.reportContent = reportContent;
                // Report will render in the template below
            })
            .catch(error => {
                console.error('Error processing submission:', error);
                // Add user-friendly error display logic here
            });
    }
}

Corresponding Apex method:

public with sharing class SubmissionHandler {
    @AuraEnabled
    public static String saveAndProcessSubmission(Custom_Submission__c submission) {
        // Insert the submission record first
        insert submission;

        // Generate report and return it to the LWC
        return generateTextReport(submission);
    }
}

2. 解析与处理数据 #

Once you have the submitted record, you can extract, validate, and transform the data as needed for your report. Here's an example of parsing fields and applying custom logic:

private static String generateTextReport(Custom_Submission__c submission) {
    // Extract key fields from the submitted record
    String submitterName = submission.Submitter_Name__c;
    Decimal totalAmount = submission.Total_Amount__c;
    Date submissionDate = submission.CreatedDate;
    Boolean isPriority = submission.Priority_Submission__c;

    // Apply custom processing logic (example: calculate a discount for priority submissions)
    Decimal adjustedAmount = totalAmount;
    if (isPriority) {
        adjustedAmount = totalAmount * 0.85; // 15% discount for priority requests
    }

    // Build the text report content
    String report = '=== Submission Report ===\n' +
                    'Submitted By: ' + submitterName + '\n' +
                    'Submission Date: ' + submissionDate.format('MM/dd/yyyy') + '\n' +
                    'Original Amount: $' + String.valueOf(totalAmount) + '\n' +
                    (isPriority ? 'Priority Discount Applied: 15%\n' : '') +
                    'Final Amount: $' + String.valueOf(adjustedAmount) + '\n' +
                    'Status: Successfully Processed';

    return report;
}

3. 返回文本报告给用户 #

You have a few options to deliver the report to the user, depending on your use case:

Option 1: Display Directly in the UI #

• Visualforce: Add a public property to your controller to store the report content, then render it on your confirmation page:

  // Add to CustomFormController
  public String submissionReport { get; set; }
  
  private void generateTextReport(Custom_Submission__c submission) {
      String report = '...'; // Your generated report content
      submissionReport = report;
  }
  

  Then in your Visualforce confirmation page:

  <apex:page controller="CustomFormController">
      <h1>Submission Successful!</h1>
      <pre style="background-color: #f5f5f5; padding: 10px; border-radius: 4px;">{!submissionReport}</pre>
  </apex:page>
  

• LWC: Use the returned report string to render it in your component template:

  <!-- Add to your LWC template -->
  <template if:true={reportContent}>
      <div class="slds-card">
          <h2 class="slds-card__header-title">Your Submission Report</h2>
          <pre class="slds-p-around_medium">{reportContent}</pre>
      </div>
  </template>
  

Option 2: Send via Email #

If you want to send the report to the user's email, use Apex's Messaging class:

private static void sendReportEmail(String reportContent, String recipientEmail) {
    Messaging.SingleEmailMessage email = new Messaging.SingleEmailMessage();
    email.setToAddresses(new List<String>{recipientEmail});
    email.setSubject('Your Submission Confirmation Report');
    email.setPlainTextBody(reportContent);

    // Send the email (handle governor limits if sending in bulk)
    Messaging.sendEmail(new List<Messaging.SingleEmailMessage>{email});
}

额外注意事项 #

• Data Validation: Always validate user input before processing—use field-level validation rules, or add checks in your Apex code to ensure required fields are filled and data is in the correct format.
• Error Handling: Wrap DML operations and report generation in try-catch blocks to catch exceptions, and display user-friendly error messages instead of technical stack traces.
• Governor Limits: Keep an eye on Apex governor limits (e.g., DML rows, SOQL queries) especially if you're processing multiple submissions at once.

内容的提问来源于stack exchange，提问作者Gregory Rosenberg