// Get account with parent and children
const account = await db.findOne('Account', accountId, {
  related: {
    ParentAccount: { fields: ['Name', 'Industry'] },
    ChildAccounts: { fields: ['Name', 'CustomerStatus', 'ContractValue'] }
  }
});

// AI automatically updates account risk factors
{
  name: 'AINewsMonitoring',
  type: 'textarea',
  label: 'AI News & Risk Alerts',
  readonly: true,
  description: 'Automatic news monitoring and risk detection'
}

🚨 Risk Alert: Customer "Acme Corp" mentioned in news about layoffs.
Recommend: Contact customer success team to assess renewal risk.

const summary = await aiSummarizeAccountInteractions(accountId);
// Returns:
{
  totalInteractions: 45,
  lastContact: '2026-01-15',
  keyPeople: ['John Doe (CTO)', 'Jane Smith (VP)'],
  sentiment: 'Positive',
  nextActions: ['Follow up on Q2 renewal', 'Demo new features']
}

// Get all decision makers for an account
const decisionMakers = await db.find('Contact', {
  filters: [
    ['AccountId', '=', accountId],
    ['IsDecisionMaker', '=', true]
  ],
  orderBy: { field: 'InfluenceLevel', direction: 'asc' }
});

// Strong relationships at high influence
const keyContacts = await db.find('Contact', {
  filters: [
    ['AccountId', '=', accountId],
    ['InfluenceLevel', '=', 'High'],
    ['RelationshipStrength', '=', 'Strong']
  ]
});

// AI identifies true decision makers from email patterns
const insights = await aiAnalyzeContactNetwork(accountId);
// Returns:
{
  decisionMakers: [
    {
      name: 'John Doe',
      title: 'CTO',
      confidence: 95,
      reason: 'CC\'d on all critical emails, final approver'
    }
  ],
  influencers: [...],
  relationshipStrength: {
    'john.doe@example.com': 'Strong',
    'jane.smith@example.com': 'Medium'
  }
}

// Move opportunity to next stage
await db.doc.update('Opportunity', oppId, {
  Stage: 'Proposal',
  Probability: 60,
  NextStep: 'Present demo to decision makers'
});

ExpectedRevenue = Amount × (Probability / 100)

"High-value enterprise deal with strong champion (John Doe, CTO).
Key risk: Long evaluation cycle (120 days). Competitor: Salesforce.
Recommendation: Accelerate with executive briefing."

"Schedule executive briefing with CEO within 2 weeks.
Prepare ROI analysis showing 300% return over 3 years.
Address security concerns raised in last meeting."

{
  winProbability: 72,
  factors: {
    positive: [
      'Strong champion relationship',
      'Budget confirmed',
      'Decision date set'
    ],
    negative: [
      'Competitor engaged',
      'Economic buyer not identified'
    ]
  }
}

"⚠️ Risks:
1. Long sales cycle (120+ days) - May lose urgency
2. No executive sponsor identified
3. Competitor has existing relationship
4. Budget not yet approved"

"Competing against Salesforce. Key differentiators:
- Our pricing is 40% lower
- Better China deployment options
- Superior customization
Weaknesses: Brand recognition, ecosystem size"

// 1. Create new opportunity
const opp = await db.doc.create('Opportunity', {
  Name: 'Acme Corp - CRM Implementation',
  AccountId: acmeAccountId,
  ContactId: johndoeContactId,
  Amount: 150000,
  CloseDate: '2026-06-30',
  Stage: 'Prospecting',
  LeadSource: 'Trade Show',
  Type: 'New Business',
  OwnerId: currentUserId
});

// 2. Qualify the opportunity
await db.doc.update('Opportunity', opp.Id, {
  Stage: 'Qualification',
  Probability: 20,
  NextStep: 'Conduct discovery call to understand requirements'
});

// 3. Present proposal
await db.doc.update('Opportunity', opp.Id, {
  Stage: 'Proposal',
  Probability: 60,
  Amount: 180000, // Adjusted after scoping
  NextStep: 'Present proposal to decision committee'
});

// 4. Win the deal!
await db.doc.update('Opportunity', opp.Id, {
  Stage: 'Closed Won',
  Probability: 100,
  CloseDate: new Date() // Actual close date
});
// This automatically triggers contract creation

// Mobile check-in
await db.doc.create('Activity', {
  Subject: 'On-site visit to Acme Corp',
  Type: 'Meeting',
  WhatId: accountId,
  WhoId: contactId,
  ActivityDate: new Date(),
  CheckInTime: new Date(),
  CheckInLocation: '123 Main St, San Francisco, CA',
  CheckInLatitude: 37.7749,
  CheckInLongitude: -122.4194
});

"[Meeting Transcript]
John (CTO): We need to migrate 500 users by Q2.
Sales Rep: Our platform supports bulk migration with zero downtime.
John: What about data security?
Sales Rep: We're SOC 2 Type II certified and GDPR compliant..."

"Action Items:
1. [Sales Rep] Send security documentation by Friday
2. [Sales Rep] Schedule demo for IT team next week
3. [John] Get budget approval from CFO
4. [John] Introduce us to VP of Operations"

"Key Points:
- Customer needs 500-user deployment by Q2
- Budget confirmed at $150K
- Main concerns: data security, migration complexity
- Competitor: Currently using Salesforce
- Next step: Technical demo for IT team"

"Recommended next steps:
1. Send security compliance documentation within 24 hours
2. Schedule technical deep-dive demo for IT team
3. Prepare ROI analysis comparing total cost vs. Salesforce
4. Request introduction to VP of Operations"

// 1. Create meeting activity
const meeting = await db.doc.create('Activity', {
  Subject: 'Discovery Call - CRM Requirements',
  Type: 'Meeting',
  Status: 'Planned',
  Priority: 'High',
  ActivityDate: '2026-02-15T14:00:00',
  DurationInMinutes: 60,
  WhoId: contactId,
  WhatId: opportunityId,
  IsOnline: true,
  MeetingLink: 'https://zoom.us/j/123456789',
  Description: 'Discuss requirements for CRM implementation'
});

// 2. After meeting, update with notes
await db.doc.update('Activity', meeting.Id, {
  Status: 'Completed',
  EndDateTime: '2026-02-15T15:00:00',
  Description: `
    Discussed current pain points and requirements.
    Customer needs:
    - 500 users
    - Multi-currency support
    - Integration with existing ERP
    - Mobile access
    
    Concerns:
    - Data migration complexity
    - Training requirements
    
    Next steps:
    - Send proposal by EOW
    - Schedule demo for IT team
  `
});

// 3. AI automatically generates insights
// AITranscription, AIActionItems, AISentimentAnalysis are populated

// 1. Create account
const account = await db.doc.create('Account', {
  Name: 'Acme Corporation',
  Type: 'Prospect',
  Industry: 'Technology',
  Phone: '+1-555-0100',
  OwnerId: currentUserId
});

// 2. Add primary contact
const contact = await db.doc.create('Contact', {
  FirstName: 'John',
  LastName: 'Doe',
  AccountId: account.Id,
  Title: 'CTO',
  Level: 'C-Level',
  Email: 'john.doe@acme.com',
  IsDecisionMaker: true,
  InfluenceLevel: 'High'
});

// 3. Create opportunity
const opportunity = await db.doc.create('Opportunity', {
  Name: 'Acme Corp - CRM Implementation',
  AccountId: account.Id,
  ContactId: contact.Id,
  Amount: 150000,
  CloseDate: '2026-06-30',
  Stage: 'Prospecting',
  Type: 'New Business',
  OwnerId: currentUserId
});

// 4. Schedule discovery call
const activity = await db.doc.create('Activity', {
  Subject: 'Discovery Call - CRM Requirements',
  Type: 'Meeting',
  Priority: 'High',
  ActivityDate: '2026-02-20T10:00:00',
  WhoId: contact.Id,
  WhatId: opportunity.Id,
  OwnerId: currentUserId
});

// Get all my opportunities closing this quarter
const myPipeline = await db.find('Opportunity', {
  filters: [
    ['OwnerId', '=', currentUserId],
    ['CloseDate', 'this_quarter'],
    ['Stage', 'not in', ['Closed Won', 'Closed Lost']]
  ],
  orderBy: { field: 'Amount', direction: 'desc' }
});

// Calculate total expected revenue
const totalExpectedRevenue = myPipeline.reduce(
  (sum, opp) => sum + (opp.ExpectedRevenue || 0),
  0
);

console.log(`Total pipeline: $${totalExpectedRevenue.toLocaleString()}`);