Overview

A Big Object is created to store record-level Quote change history, indexed by RecordID__c and LastModifiedDate__c. A #Trigger on Quote (after insert, after update) writes a new history record whenever a Quote is created or modified.

General Use Case

Use a #Trigger to automatically capture and store record snapshots in a Big Object each time a record is saved.

Video Demo

Prerequisites

Required Big Object
QuoteSnapshot__b
Description__cText(255)
Discount__cNumber(3,2)
ExpirationDate__cDateTime
LastModifiedDate__cDateTimeIndex
Status__cText(100)
Tax__cNumber(16, 2)
Email__cEmail(80)
Name__cText(255)
AccountID__cText(18)
ContactID__cText(18)
ContractID__cText(18)
OpportunityID__cText(18)
OwnerID__cText(18)
Pricebook2ID__cText(18)
RecordID__cText(18)Index
LastModifiedBy__cText(255)

Downloadable Executables

DownloadQuote.Snapshot.Insert

Walkthrough

1

Pipeline - Quote.Triggers

pipeline-quote-triggers
2

New Executable - Quote.Snapshot.Insert

new-executable-quote-snapshot-insert
3

Trigger Settings

trigger-settings
4

Mapping

mapping
5

Action

action