FileMaker Pro vs. Alternatives: Which Database Tool Fits Your Business?

How to Build a Custom CRM in FileMaker Pro (Step-by-Step)

Building a custom CRM in FileMaker Pro lets you tailor contact management, sales tracking, and reporting to your exact workflow. This guide walks through a practical, prescriptive process to design, build, and deploy a basic but expandable CRM. Assumptions: you have FileMaker Pro installed and basic familiarity with its interface. I’ll use reasonable defaults (Contacts, Companies, Opportunities, Activities) and provide structure you can expand.

1. Plan your data model

• Entities: Contacts, Companies, Opportunities (deals), Activities (calls, meetings), Users.
• Key fields:
  • Contacts: ContactID (UUID), FirstName, LastName, Email, Phone, CompanyID (FK), Tags, Notes.
  • Companies: CompanyID (UUID), CompanyName, Industry, Phone, Website, Address.
  • Opportunities: OpportunityID (UUID), Title, CompanyID (FK), ContactID (FK), Stage, Value, CloseDate, OwnerID.
  • Activities: ActivityID (UUID), Type, DateTime, ContactID (FK), OpportunityID (FK), Notes, Completed (boolean).
  • Users: UserID, Username, Role, Email.
• Relationships: Contacts → Companies (many-to-one), Opportunities → Companies/Contacts (many-to-one), Activities → Contacts/Opportunities (many-to-one).

2. Create tables and fields

• Open FileMaker and create a new file (or add to existing).
• Create the five tables above. Use UUID for primary keys (Auto-Enter > Get(UUID)).
• Add the fields listed and set appropriate field types (Text, Number, Date, Timestamp, Container for attachments, Calculation for FullName).

3. Define relationships and occurrences

• Open Manage Database → Relationships.
• Create table occurrences for each table. Link CompanyID, ContactID, OpportunityID, OwnerID appropriately.
• Add occurrences for self-joins if needed (e.g., parent company).

4. Build layouts (UI)

• Create core layouts in Layout mode with a clean, consistent header and navigation:
  • Dashboard: KPIs (pipeline value, activities due), quick search.
  • Contacts List / Contact Detail.
  • Companies List / Company Detail.
  • Opportunities List / Opportunity Detail with stage visual.
  • Activities Calendar / List.
  • Admin / Users.
• Use Portals to show related records (e.g., on Company Detail show Contacts and Opportunities).
• Add buttons for common actions: New Contact, New Opportunity, Log Activity, Convert Lead.

5. Add scripts for workflows

• Script examples to implement:
  1. New Contact: create record, set CompanyID (if selected), go to Contact Detail.
  2. New Opportunity: create record, set OwnerID = Get ( AccountName ) or current user, set default Stage = “Prospect”.
  3. Log Activity: create Activity linked to current Contact/Opportunity, set DateTime = CurrentTimestamp.
  4. Close Opportunity: change Stage, set CloseDate, optionally create follow-up Activity.
  5. Assign Owner: set field and send notification (see integrations).
• Use Script Triggers for inline actions (e.g., onRecordLoad to refresh related counts).

6. Implement value lists, validations, and calculations

• Create value lists for Opportunity Stage, Activity Type, Industry, Tags.
• Field validations: required fields (Email for Contacts optional), number ranges for Value.
• Calculations: FullName = FirstName & “ ” & LastName; Age of Opportunity = CloseDate – Get ( CurrentDate ).

7. Searching, sorting, and quick finds

• Add a global search field on the header. Script to perform multi-table finds (Contacts, Companies, Opportunities) using Constrain/Extend Found Set or ExecuteFind requests.
• Provide saved finds and filters (by Stage, Owner, Date range).
• Add quick sorts on list layouts (LastName, Company, CloseDate).

8. Reporting and dashboards

• Dashboard layout: summary fields and charts (pipeline by Stage, monthly won value).
• Use summary fields (total, count) grouped by Stage or Owner.
• Create printable reports (list or invoice-style) with headers/footers.

9. User accounts, permissions, and sharing

• If using FileMaker Server or FileMaker Cloud, define Accounts & Privileges: Admin, Manager, Sales Rep, Read-Only.
• Limit access to sensitive fields (OwnerID, Admin notes).
• Use record-level access based on OwnerID for Sales Reps, with calculation-based privileges.

10. Attachments, email, and integrations

• Use Container fields for attachments (contracts, logos). Enable external storage if large.
• Use Send Mail script step to email contacts; for richer templates, use Perform AppleScript/PowerShell or plugin/integration.
• Integrate with external services via REST API (Insert from URL) for calendar sync, SMS, or third-party CRMs. Use JSON for payloads.

11. Testing and data import

• Create test records for each entity and run through common workflows.
• Import existing contacts via File → Import Records (CSV). Map fields, set matching for duplicates.
• Test scripts, layouts on different screen sizes.

12. Deployment and backups

• Host on FileMaker Server or FileMaker Cloud for multi-user access.
• Set up scheduled backups and incremental backup retention.
• Train users with a short guide and provide a sandbox for trial.

13. Maintenance and future enhancements

• Monitor performance; add indexes to frequently searched fields (Email, CompanyName).
• Add automation: scheduled scripts for reminders, nightly reports.
• Extend with lead scoring, email tracking, mobile-optimized layouts, and API endpoints.

Example: Basic “New Opportunity” script (steps)

1. New Record/Request.
2. Set Field Opportunities::OpportunityID; Get ( UUID ).
3. Set Field [Opportunities::OwnerID; Get ( AccountName )].
4. Set Field [Opportunities::Stage; “Prospect”].
5. Set Field Opportunities::CompanyID; Companies::CompanyID.
6. Commit Records/Requests.
7. Go to Layout [“Opportunity Detail”].

This plan gives a complete, practical path to build a working custom CRM in FileMaker Pro that you can expand. If you want, I can generate sample layouts, a field list CSV for import, or full script steps for specific actions (e.g., multi-table search, email templates).