🎬 Mass Update Operations – Video Tutorial
▶️ Watch on YouTube
Master bulk record updates with formulas, queries, and safe execution practices.
Video Duration: ~18 minutes | Difficulty: Intermediate | Tool: Mass Update
📋 What You’ll Learn
🎯 Core Skills
- Building queries to target specific records
- Writing formulas for field updates
- Using conditional logic (IF/THEN)
- Cross-object data lookups
- Previewing changes before execution
- Monitoring job progress
📊 Real Examples
- Example 1: Update Lead Status based on age
- Example 2: Standardize phone number formats
- Example 3: Extract company domain from emails
- Example 4: Copy Account Industry to Contacts
- Example 5: Set follow-up dates automatically
⏱️ Video Timeline
- 0:00-3:00 – Interface overview & setup
- 3:00-8:00 – Query builder demonstration
- 8:00-14:00 – Formula examples & logic
- 14:00-16:00 – Preview & safety features
- 16:00-18:00 – Execution & monitoring
🎓 Prerequisites
- ✅ Mass Update tool installed & licensed
- ✅ Understanding of Salesforce field types
- ✅ Basic formula knowledge helpful (not required)
- ✅ Edit permissions on target objects
📝 Video Demonstrations Summary
Demo 1: Update Lead Status for Old Leads
Goal: Mark leads over 90 days old as “Stale”
Query: All Leads where CreatedDate < TODAY() – 90 AND Status = “Open”
Update Field: Status
Formula: "Stale"
Records Affected: 3,458 leads
Execution Time: 3 minutes
Demo 2: Standardize Phone Numbers
Goal: Format all phone numbers to (XXX) XXX-XXXX format
Query: All Contacts where Phone != null
Update Field: Phone
Formula: FORMAT_PHONE({Phone})
Records Affected: 12,847 contacts
Execution Time: 6 minutes
Demo 3: Extract Company from Email Domain
Goal: Populate Company field from email domain when blank
Query: All Leads where Company = null AND Email != null
Update Field: Company
Formula: TITLE_CASE(EXTRACT_DOMAIN({Email}))
Example: “john@acme.com” → “Acme.Com”
Records Affected: 5,234 leads
Execution Time: 4 minutes
Demo 4: Cross-Object Update (Advanced)
Goal: Copy Account Industry to all related Contacts
Query: All Contacts where AccountId != null
Update Field: Industry__c (custom field on Contact)
Formula: LOOKUP(Account, Industry, Id={AccountId})
Records Affected: 28,563 contacts
Execution Time: 15 minutes
🛠️ Try It Yourself: Practice Exercise
Exercise: Update Contact Email Format
Challenge: Normalize all contact emails to lowercase
Your Task:
- Open Mass Update tool
- Select “Contacts” object
- Build query: “All Contacts where Email != null”
- Update field: Email
- Formula:
LOWER({Email}) - Preview changes
- Execute on 10-20 test records first
Expected Result: “John.Smith@ACME.COM” → “john.smith@acme.com”
Estimated Time: 5-10 minutes for setup + execution