Part 2: CRM – Companies, Contacts & Data Management

Master Relationship Database Architecture

At the core of MRSware Desktop is the Master Relationship Database. Companies and Contacts form the central foundation to which all journals, tasks, calendar events, projects, customer accounts, orders, invoices, and commissions are tied.

Company & Contact Hierarchy

MRSware supports multi-tier organizational structures:

• Parent / Division / Branch Relationships: Connect corporate headquarters to regional branches and job sites.
• Individual Contact Roles: Associate contacts with specific departments (Purchasing, Engineering, Management, Accounts Payable) with custom job titles and direct contact info.

Categories vs. Additional Custom Fields

CRM View Modes: Table View, Compact Cards & Multiline Cards

MRSware Desktop provides three standardized view modes across all CRM listings (Companies, Contacts, Tasks, Journals, and Projects):

• Table View (Standard Grid): High-density data grid displaying all custom fields in tabular columns with multi-column sorting, column reordering, dynamic header grouping, and summary aggregate footers.
• Compact Card View (2-Line Cards): High-efficiency 2-line cards rendered via custom GDI+ drawing:
  • Line 1: Primary name (Company or Contact), status badge, and quick action icons. On Task cards, includes an interactive click-to-complete checkbox to mark tasks done without opening the task dialog.
  • Line 2: Contextual details including direct phone extension, email address, physical location (City/State), category tags, or due date.
  • Interactive Sort Menu: Dedicated toolbar sort button and context menu to sort cards by Name, Date Created, Due Date, or Category.
• Multiline Card View (Expanded Cards): Multi-line structured card presentation (CardsView):
  • Displays full category badges, note previews, and user-defined custom fields.
  • Expand All / Collapse All controls to quickly adjust screen density.
  • Card Field Settings... Dialog: Choose exactly which fields appear on the card layout (e.g. Phone, Mobile, Direct Email, Street Address, Categories, Custom Fields).

Tip: You can customize your font family and font size for both card views in Tools > Preferences > Settings (Font for Card Views). Card heights dynamically adjust to accommodate your chosen text size.

Dockable Record Preview Window & Rich HTML Formatting

The Record Preview Window provides real-time, zero-click inspection of Company and Contact details directly within the primary CRM workspace. Docked at the bottom or right side of your window, the Preview Panel eliminates modal dialog fatigue when navigating customer lists.

Key architectural highlights of the Preview Window include:

• Rich Read-Only HTML Rendering: Generates cleanly formatted HTML summaries with structured section headings, contact badges, and financial metrics.
• Line-Break (<br/>) Preservation: Multi-line account notes and call interaction logs preserve natural formatting and line breaks seamlessly.
• Top Action Bar: Features an instant Edit button (opens the record dialog) and a Print button (invokes native Windows print dialog for WYSIWYG hard copies).
• Debounced 250ms Selection Timer: Keeps scrolling fast and fluid even across databases with tens of thousands of contacts.
• Comprehensive Sub-Entity Tabs:
  • Summary & Contact Info: Primary directory info, direct phone extensions, physical addresses, custom fields, and account notes.
  • Journals & Activity History: Full chronological log of past calls, meetings, emails, and touch-point interaction notes.
  • Open Tasks & Follow-ups: Scheduled tasks, delegated team members, task priorities, and upcoming due dates.
  • Opportunities & Quotes: Active sales pipeline deals, bid specifications, forecasted values, and close probabilities.
  • Contact Roster: For Company records, lists all linked individual contacts, job roles, and direct contact details.
  • Orders & Invoices: Recent purchase orders, invoice numbers, shipment status, and year-to-date sales totals.
  • File Share & Attachments: Linked contracts, specification PDFs, drawings, and uploaded documents stored in File Share.

Pivot & Paste High-Speed Data Entry

To eliminate tedious record creation, MRSware Desktop supports Pivot & Paste. You can copy formatted customer data directly from Excel or email spreadsheets and paste entire rows directly into the MRSware CRM grid, automatically mapping columns to Company Name, Address, Contact, Phone, and Email.

Drag-and-Drop Record Conversion

MRSware Desktop allows instant workflow record conversion via drag-and-drop:

• Drag an Email or Journal entry onto the Task Panel to turn it into a follow-up task.
• Drag a Contact onto the Project Panel to assign them as a participating stakeholder.
• Drag an incoming inquiry onto Opportunities to initiate pipeline tracking.

Merging Duplicate Contacts & Companies

Over time, duplicate entries may occur. Admins and users can utilize the Merge Duplicate Sales Reps / Contacts / Companies tool under the Tools menu. Specify the primary record to retain; MRSware will automatically re-associate all historical journals, tasks, quotes, invoices, and commission records from the secondary record into the master record before deleting the duplicate.