Introduction
Here's what usually happens with Salesforce customizations:
User: "Can we make the related list show different fields for sales vs. service teams?" Admin: "Let me call a developer." Developer: "Sure, that'll be 40 hours and a deployment window." Budget: nervous sweating
Here's what happens with Advanced Data Table:
User: "Can we make the related list show different fields for sales vs. service teams?" Admin: "Done. Check your page." User: "Wait, that's it?" Admin: "That's it." Budget: sighs with relief
The Configuration Philosophy
The Old World: Every Change Needs Code
Want different views? Custom development. Want different colors? Custom development. Want different button labels? Custom development. Want to change your mind? More custom development.
Result: You're hostage to developer availability and budget cycles.
The New World: Configure Once, Use Everywhere
Advanced Data Table has 30+ settings you can adjust with simple point-and-click configuration. No code. No deployments. No $200/hour developer rates.
Same component, but it can be:
- A simple contact list
- A complex financial dashboard
- A customer support queue
- A pipeline analysis tool
- An inventory tracker
- Literally anything
The Power of Fieldsets (For Non-Technical Folks)
What's a Fieldset?
Think of it like a custom view of your fields. Instead of hardcoding "show these exact columns," you create a fieldset that says "show whatever columns I put in this list."
The Magic:
- Need different columns for executives? Different fieldset.
- Need different columns for sales vs. service? Different fieldsets.
- Need to add a column next week? Just update the fieldset.
- No code. No deployment. No developer.
Real Example: Opportunities Three Ways
Executive Dashboard (fieldset: "Executive_View")
- Shows only: Name, Amount, Stage, Close Date
- Simple, high-level view
- 4 columns
Sales Rep View (fieldset: "Sales_Detail")
- Shows: Name, Account, Amount, Stage, Close Date, Next Steps, Probability, Owner, Competitor, etc.
- Comprehensive, action-oriented
- 12+ columns
Finance View (fieldset: "Finance_Analysis")
- Shows: Name, Amount, Stage, Close Date, Product, Margin, Revenue, Cost, Expected Revenue
- Numbers-focused, analytical
- 9 columns
Same object. Same component. Three completely different experiences.
All you did? Create three fieldsets and set one property. Your developer? On vacation (where they belong).
Configuration Superpowers (No Cape Required)
1. Show Only What Matters
Filter Before They Even See It
Want to show only active customers?
additionalFilters = "Status = 'Active'"
Want to show only this year's opportunities?
additionalFilters = "CloseDate = THIS_YEAR"
Want to show high-priority, unassigned cases?
additionalFilters = "Priority = 'High' AND Owner = null"
Set it once in the configuration. Users never see the irrelevant records. They focus on what matters.
2. Control the Buttons Users See
The New Button
- Show it? Yes or No
- What should it say? "New," "Add Record," "Create Opportunity," "Add Patient"—your choice
- What should it do? Default = standard Salesforce modal. Or trigger your custom action.
The Edit Button
- Show it? Yes or No
- Where? On every row (for frequent editing) or hidden in a menu (for occasional editing)
The Export Button
- Show it? Yes or No
- (Hint: Finance will love you if you say Yes)
The Refresh Button
- Always available—users love being able to reload data
Real Example:
Executive Dashboard:
- New Button: OFF (they don't create records)
- Edit Button: OFF (read-only view)
- Export Button: ON (they analyze in Excel)
Sales Rep View:
- New Button: ON, labeled "New Opportunity"
- Edit Button: ON, on every row
- Export Button: ON
Support Queue:
- New Button: ON, labeled "New Case"
- Edit Button: ON, in menu
- Export Button: OFF (security policy)
3. Pagination That Fits Your Data
Got 500 records? Pagination makes sense. Got 15 records? Why paginate?
You choose:
- Turn pagination ON or OFF
- Set the default page size (10, 25, 50, 100)
- Let users pick their preference
Examples:
High-Volume Case Queue:
Pagination: ON
Default: 50 records per page
Options: 25, 50, 100, 200
Users see lots of cases, can adjust to their preference.
Executive Top 10:
Pagination: OFF
Limit: 10 records
Clean, simple dashboard. No page controls cluttering the view.
4. Make Columns the Right Width
Ever seen a column that says "Opportunity Nam..." because it's too narrow? Or a two-letter status code stretched across half the screen?
You control every column width:
Column Widths: 200, 150, 120, 150, 100, auto
Translation:
- Column 1 (Name): 200 pixels
- Column 2 (Account): 150 pixels
- Column 3 (Amount): 120 pixels (perfect for currency)
- Column 4 (Close Date): 150 pixels
- Column 5 (Stage): 100 pixels
- Column 6 (Whatever's last): Flexible width
Set it once. Looks professional forever.
5. Colors That Match Your World
Three Modes, All Point-and-Click:
Object Colors (Set and Forget)
Done. Opportunities are orange. Cases are red. Accounts are purple. Matches Salesforce automatically.
Organization Colors (Brand Consistency)
Done. Your org's primary brand color everywhere. Instant consistency.
Custom Colors (Total Control)
Perfect for:
- Matching corporate brand guidelines
- Meeting accessibility requirements
- Creating visual distinction between different sections
6. Smart Number Coloring
Select "Use Custom Currency Colors" for currency fields or "Use Custom Number Colors" to highlight positive and negative numbers.
Now every financial report tells its story at a glance. Profit in green. Loss in red. No manual formatting required.
Real Configuration Scenarios
Scenario 1: Sales VP's Strategic Dashboard
Goal: High-level view of biggest opportunities, company colors, minimal clutter
Configuration (5 minutes):
Fieldset: "Executive_Pipeline"
Additional Filters: "Amount > 100000 AND StageName != 'Closed Lost'"
Record Limit: 20
Sort: Amount (highest first)
Pagination: OFF
New Button: OFF
Edit Button: OFF
Export Button: ON
Color Scheme: Organization
Alternating Rows: YES
Currency Colors: YES
Result: Professional dashboard showing top 20 opportunities, color-coded by profitability, in company brand colors. No edits, no clutter, just insights.
Scenario 2: Sales Rep's Daily Workspace
Goal: Complete view, frequent editing, personal customization
Configuration (5 minutes):
Fieldset: "Sales_Full_Detail"
Additional Filters: "IsClosed = false"
Record Limit: 200
Sort: Close Date (soonest first)
Pagination: ON
Page Size: 50 (user can change)
New Button: ON - "New Opportunity"
Edit Button: ON - on every row
Export Button: ON
Color Scheme: Object
Alternating Rows: YES
Currency Colors: YES
Text Wrap: Description, Next Steps
Result: Power tool for daily work. Sees all open opportunities, easily edits details, wraps long text fields for readability.
Scenario 3: Support Team's Case Queue
Goal: Focus on urgent cases, quick access, real-time visibility
Configuration (5 minutes):
Fieldset: "Support_Queue"
Additional Filters: "Status != 'Closed'"
Record Limit: 100
Sort: Priority (urgent first)
Pagination: ON
Page Size: 25
New Button: ON - "New Case"
Edit Button: ON - in menu (cleaner)
Export Button: OFF (security)
Color Scheme: Object (red for urgency)
Alternating Rows: YES
Column Widths: 150, 200, 100, 120, auto
Result: Clean, focused case queue. Priority cases stand out. Quick menu access for actions. No export button (meets compliance).
Scenario 4: Multi-Purpose Product Page
Three Tables, Same Component:
Active Contracts (fieldset: "Active_Contracts")
Filters: Status = "Active"
Pagination: OFF
Limit: 10 most recent
Edit: In menu
Renewal Opportunities (fieldset: "Renewal_Pipeline")
Filters: Type = "Renewal" AND Stage != "Closed"
Pagination: ON
Currency Colors: YES
Edit: On row
Support Cases (fieldset: "Product_Cases")
Filters: Status = "Open"
Pagination: ON
Object Colors: YES
Edit: In menu
Three completely different uses. Same component. Total configuration time: 15 minutes.
The Business Impact
Old Way: Custom Development
Requirements Gathering: 4 hours
Development: 16 hours
Testing: 8 hours
Deployment: 2 hours
Documentation: 2 hours
Total Time: 32 hours
Total Cost: $6,400 (at $200/hour)
Timeline: 2-3 weeks
New Way: Configuration
Create Fieldset: 10 minutes
Configure Component: 5 minutes
Test: 5 minutes
Activate: 1 minute
Total Time: 21 minutes
Total Cost: $0 (admin does it)
Timeline: Same day
Savings: $6,400 and 3 weeks per configuration
Multiply by Reality
Most orgs need:
- 10-20 different related list configurations
- Changes every quarter as business evolves
- Different views for different user groups
Traditional Approach:
- 15 configurations × $6,400 = $96,000
- Plus maintenance and changes
- Plus "we can't afford to customize that" limitations
Advanced Data Table Approach:
- 15 configurations × $0 = $0
- Changes in minutes
- "Sure, we can customize that" possibilities
The Flexibility Advantage
|
What You Need |
Standard Approach |
Advanced Data Table |
|
Different fields per group |
Custom code |
Different fieldsets |
|
Custom button labels |
Custom code |
Configuration setting |
|
Filtered views |
List views (limited) |
SOQL filters (unlimited) |
|
Custom colors |
Custom code |
Configuration settings |
|
Column widths |
Hope for the best |
Set exact widths |
|
Multiple configs per object |
Multiple custom components |
Same component, different settings |
|
Timeline |
Weeks |
Minutes |
|
Cost |
Thousands |
Included |
|
Maintenance |
Developer |
Admin |
Why This Matters
For Your Admins
- Empowered to solve problems immediately
- No more "let me ask development"
- Become heroes by delivering fast
For Your Users
- Get exactly the view they need
- See changes implemented same-day
- Feel heard and valued
For Your Budget
- No development costs for UI changes
- No ongoing maintenance contracts
- ROI in the first configuration
For Your Business
- Agility to adapt quickly
- Consistency across the org
- Professional appearance everywhere
Coming Up Next
In Part 5, we'll explore the advanced features that go beyond looking good and being flexible—we're talking real productivity boosters like instant CSV export, smart auto-refresh, and time-saving automation that makes your team more efficient every single day.
