LEARN WITH FILESOFT
Practical FileMaker guides.
Find a clear walkthrough for your next task, or follow a learning path one step at a time.
Search stays in your browser and is remembered when you go back. Search words are not sent to Filesoft.
Start with a practical guide.
Article · Practice download
Import Excel or CSV contacts into FileMaker safelyStart with three fictional contacts. Map the fields, preserve identifiers, and check the result before importing a real customer list.
Article
Read a JSON API response in FileMakerExtract nested values and array items, distinguish null from missing data, and plan a safe response-to-record mapping.
Article · Practice download
Review a FileMaker file before customizing itMake a small change with a clear scope, a dependency map and a way to check that the existing workflow still works.
Follow a short learning path.
Each step links to a focused article. Start at the beginning or pick the step you need.
Work with an API
Optional next steps
Make a form easier to use
Browse all guides.
Articles, tool instructions, courses and product guides, organized by topic.
Workflows 32 resources
Case study · Free example file
Keep the original PDF when your FileMaker records change ↗Save a $100 original, issue a $104 revision and retrieve both saved PDFs. Includes an editable FileMaker example.
Case study · Free example file
Check booking overlaps in FileMaker—and allow back-to-back bookings ↗Compare room, date and intervals; allow adjacent times and recheck a stale preview before confirming. Includes an editable FileMaker example.
Case study · Screenshot walkthrough
Track equipment maintenance in FileMaker with Asset Care ↗Connect an equipment record, recurring plan, completed work order, history and report snapshots. Follow the fictional Workshop extractor example in Asset Care Standard.
Practical guide
Check a FileMaker attachment before accepting it ↗Review the file’s metadata and storage, then give the person a clear way to accept or replace it.
Practical guide
Make a FileMaker dashboard count agree with its detail list ↗Define one record-membership rule and make the card, action and refreshed list use it.
Practical guide
Preview a FileMaker bulk update before applying it ↗Show the proposed changes, save the chosen record IDs and report exactly what happened when applying them.
Practical guide
Merge two reviewed FileMaker contacts while preserving their notes ↗Choose a survivor explicitly, move its related notes and keep a record of the decision.
Quick answer
Empty FileMaker portal? Show the right message and next action ↗Distinguish a missing selection from an empty result, and give people a useful way forward.
Worked tutorial
Open a FileMaker detail view and return to the same filtered list ↗Preserve the originating context, open the intended record by ID, and make refresh behavior explicit.
Case study · Email download
Track partial deliveries against purchase orders in FileMaker ↗Follow two deliveries, check the remaining quantities and understand saved receiving PDFs. Free example requires name and email.
Case study · Demo download
Review incoming contacts before adding them to FileMaker.Separate incoming rows, flag missing values and duplicate IDs, then add only ready contacts. Follow native screenshots and inspect the editable FileMaker example.
Case study · Demo download
Find the projects that need attention in FileMaker.Review overdue and at-risk projects, find missing deadlines, then open, edit and return. See native screenshots and try the editable FileMaker example.
Article · Practice download
Check a CSV before importing it into FileMakerUse a six-contact CSV to find duplicate IDs, extra columns, ambiguous dates and leading-zero risks before a FileMaker import.
Article · Practice download
Fix CSV quoting and column errors before a FileMaker importDiagnose unclosed quotes, extra columns, wrong delimiters and encoding problems with small CSV examples and expected checker results.
Article · Practice download
Assemble a cover, report and appendix into one PDF in FileMaker 26Plan a native PDF assembly workflow with a known page order, a controlled record selection and explicit cleanup when an operation fails.
Article · Practice download
Track project time in FileMaker and reconcile your weekly hoursEnter minutes, filter an explicit week and check project totals with a five-entry Time Ledger exercise.
Article · Practice download
Track stock receipts, usage and count adjustments in FileMakerFollow one item from receipt to usage and a physical count. Reconcile a four-movement example with Filesoft Stockroom.
Article · Practice download
Import Excel or CSV contacts into FileMaker safelyStart with three fictional contacts. Map the fields, preserve identifiers, and check the result before importing a real customer list.
Article
Create a quote and follow it through to payment in FileMakerWalk through one fictional sale in Sales Starter, from customer details to an invoice and a recorded payment.
Article
Export a FileMaker report to PDF without surprisesChoose the right records, use a print-friendly layout, and check page breaks before sharing the finished document.
Article
Track project milestones, deliverables and client approval in FileMakerFollow a fictional project from its brief to a saved handover, while keeping work progress separate from client acceptance.
Article
Create a FileMaker value list that shows names and stores IDsLet someone choose a readable project name while the task keeps a stable link to the correct project.
Article
Highlight overdue tasks in FileMaker with conditional formattingMake late work easier to notice without treating completed tasks or missing dates as overdue.
Article · Practice download
Build a monthly summary report in FileMakerGroup a small set of time entries by month, calculate totals, and prove that the report uses the records you intended.
Article · Practice download
Find duplicate contacts in FileMaker before cleaning your dataBuild a review list of possible duplicates without deleting legitimate contacts or breaking related records.
Article
Why do FileMaker style changes appear on only some objects?Understand the difference between one object’s formatting, a named style, and the theme shared by layouts.
Article · Practice download
Review a FileMaker file before customizing itMake a small change with a clear scope, a dependency map and a way to check that the existing workflow still works.
Product guide
Sales workflowSet up business details, add customers and prepare your first quote.
Product guide
Stock workflowTrack consumables, receipts, usage and count adjustments.
Product guide
Contacts workflowKeep contact history and follow-ups together.
Product guide
Time workflowRecord project time and review your working hours.
Product guide
Checklists workflowOrganize tasks in a separate workspace or an existing file.
Data & calculations 36 resources
Practical guide · Free example file
Keep quoted prices unchanged when your FileMaker catalogue changes ↗Preserve copied prices, keep earlier quote versions and deliberately revise an offer. Includes an editable FileMaker example.
Practical guide · Free example file
Correct a FileMaker receipt without losing its history ↗Reverse a mistaken receipt, keep its reason and history, and post the correct quantity. Free editable single-user example.
Practical guide · Free example file
Calculate working-day deadlines in FileMaker ↗Skip weekends and listed holidays, avoid duplicate holiday deductions and handle date boundaries. Includes an editable example file.
Practical guide · Free example file
Manage a session waiting list in FileMaker: fill a cancelled seat fairly ↗Queue participants in saved order, promote one person into an available seat and keep returning participants at the back. Free editable example.
Practical guide · Free example file
Keep FileMaker session registrations within capacity ↗Count active registrations, free seats on cancellation and check Restore before reopening a cancelled record. Free editable example.
Practical guide · Free example file
Prevent duplicate session registrations in FileMaker ↗Use participant and session IDs to prevent duplicate registrations. Cancel and restore the same record, with a free editable example.
Practical guide · Free example file
Skip and restore recurring tasks without creating duplicates ↗Keep a skipped occurrence, save its reason and restore the same task. Includes a free editable FileMaker example.
Practical guide · Free example file
Create recurring tasks without creating duplicates ↗Preview a range, use stable occurrence keys and create only missing tasks. Includes a local FileMaker teaching file.
Practical guide · Free example file
Move recurring due dates past weekends and holidays ↗Keep the calendar anchor while rolling closed dates forward. Includes five screenshot examples and a free editable FileMaker file.
Practical guide · Screenshot walkthrough
Calculate recurring due dates in FileMaker without month-end drift ↗Compare a fixed calendar anchor with scheduling from completion. Follow month-end, leap-day and missed-occurrence examples.
Practical guide
Find an exact email address or literal symbol in FileMaker ↗Separate whole-field matching from special find characters, then check the records that actually match.
Practical guide
Find FileMaker timestamps within a day without losing late records ↗Use the start of one day and the start of the next, with an explicit rule for the time zone.
Quick answer
Why do FileMaker IDs look the same but fail to match? ↗Find hidden differences in imported identifiers before changing the values that connect your records.
Worked tutorial
Import related CSV files into FileMaker using a source-ID-to-UUID map ↗Keep external identifiers separate from your app’s internal keys, then resolve each child before creating it.
Quick answer
Import CSV dates into FileMaker without swapping day and month ↗Stage dates as text, require a declared source format, and reject values that change during conversion.
Worked tutorial
Build a FileMaker import batch report: applied, skipped and unresolved rows ↗Explain every source row without confusing retries, attempted writes and committed changes.
Article · Practice download
Validate FileMaker data at entry, import and commitCompare a required value with a range rule, then inspect what FileMaker accepts, rejects or skips through different entry routes.
Article · Practice download
Build a dependent FileMaker value list—and handle a changed parent choiceFilter an item picker by category, inspect the stored ID and handle an old selection after the category changes.
Article · Practice download
Save related FileMaker records together with a transactionPlan a parent-and-two-lines write with explicit commit, revert and result checks, then exercise success and failure in a practice file.
Article · Practice download
Update matching FileMaker records from CSV without creating duplicatesUse stable IDs, a reviewed update file and explicit blank-value rules to update three fictional contacts in a practice database.
Article · Practice download
Create related sample data for a FileMaker practice fileGenerate contacts, projects and tasks with matching IDs, then check imports and relationships before testing your layouts.
Article
Find the right JSON path in a nested API responseLocate one value in a nested response, copy its FileMaker expression and check missing, null and empty cases.
Article
Create JSON from FileMaker fieldsBuild a JSON object with JSONSetElement, preserve text IDs, inspect the result and read values back in FileMaker.
Article
Pass JSON script parameters in FileMakerGive script inputs clear names, validate their types and return a useful result with a worked contact example.
Article
Read a JSON API response in FileMakerExtract nested values and array items, distinguish null from missing data, and plan a safe response-to-record mapping.
Article
Write your first FileMaker ExecuteSQL queryBuild a small SELECT query, bind a search value safely and understand what the returned text can—and cannot—tell you.
Article
Make FileMaker calculations clearer with LetName the parts of a calculation, make rounding decisions explicit and check a worked line-total example.
Article
Why does FileMaker ExecuteSQL return a question mark?Find the cause of a failed ExecuteSQL query, separate SQL errors from empty results, and check a small example before rebuilding your query.
Article
Use While in FileMaker without losing track of the loopBuild a numbered list with a small While calculation, trace each iteration, and check empty input and stopping conditions.
Article
Add, update and remove JSON array items in FileMakerBuild a small line-item array, update a quantity by index, and avoid changing the wrong item after deleting an element.
Article
Find records between two dates in FileMakerBuild a clear date-range search, test both boundary dates, and avoid mixing date fields, timestamps and ambiguous typed dates.
Tool guide
Follow the sample data guideCreate fictional data, preserve matching IDs and check imports in a separate practice file.
Tool guide
Follow the comparison guideCompare calculation or script text, understand line endings and export a readable change report.
Tool guide
Follow the calculation walkthroughFormat expressions, locate unclosed delimiters and understand the structural checker’s limits before testing in FileMaker.
Tool guide
Follow the SQL walkthroughFormat SELECT queries, review supported syntax checks and create an ExecuteSQL template. Learn what the checker can—and cannot—verify before testing in your file.
Tool guide
Try the JSON walkthroughInspect nested values, find syntax errors and build FileMaker JSONGetElement or JSONSetElement expressions.
APIs 11 resources
Quick answer
Fix spaces, ampersands and plus signs in FileMaker API URLs ↗Encode query values once, while leaving the separators that define the request intact.
Worked tutorial
Handle HTTP 429 in FileMaker with limited retries ↗Give a read request a small retry budget, respect the service’s delay, and stop with a clear result.
Quick answer
Why is my JSON object a quoted string in FileMaker? ↗Choose the intended JSON type when nesting a payload, and check the result before sending it.
Worked tutorial
Recover from an API timeout without creating duplicate records ↗Save the operation identity before sending, then reconcile uncertain outcomes under the provider’s rules.
Article · Practice download
Build a FileMaker Data API find with AND, OR and omit requestsTurn a plain-language contact search into an inspectable request, then verify the exact records returned.
Article
Prepare an API request in FileMakerTurn a simple GET request into FileMaker URL and cURL calculations, then inspect errors, response headers and JSON.
Article
Send JSON with Insert from URL in FileMakerPrepare a POST body, pass it through a FileMaker variable and verify the response before treating a request as complete.
Article
Troubleshoot FileMaker API requestsSeparate connection errors, HTTP responses and application errors, then collect useful diagnostics without exposing credentials.
Article
Plan API pagination in FileMaker before importing recordsUse a fictional cursor response to design page-by-page retrieval, safe stopping conditions and a restartable import.
Tool guide
Follow the data api find builder guideCombine criteria, review omit requests and use the correct output format.
Tool guide
Follow the cURL walkthroughBuild URL and cURL-options calculations, then follow the setup guide in FileMaker. Review the generated steps and test against a controlled endpoint.
Solution analysis 12 resources
Article · Practice download
Diagnose a slow FileMaker portal with a repeatable measurementBuild a controlled baseline, change one factor at a time and check the displayed records before accepting a performance improvement.
Article · Practice download
Handle FileMaker error 301 without losing the user’s intended changeUse a two-session practice case to recognize a record lock, preserve pending input and retry only after reviewing the current record.
Article · Practice download
Archive FileMaker records while preserving related historyKeep stable IDs and historical totals while removing archived projects from new-work choices, then verify a controlled restore.
Article
FileMaker error 401: an empty find or an authentication problem?Identify which system produced 401 before changing credentials or rewriting your search.
Article
Compare two FileMaker calculations before replacing oneReview a small formula change, explain its effect and test boundary cases before using the revised version.
Article
Find where a FileMaker field is usedUse an XML Database Design Report and DDR Explorer to inspect field references before changing a FileMaker solution.
Article
Review a FileMaker script before changing itTrace callers and dependencies, document the script contract and build a focused regression checklist with an XML DDR.
Article
Handle FileMaker script errors without hiding the problemCapture an error immediately, distinguish no matches from failure, and return an outcome the calling script can understand.
Article
Why are related records missing from a FileMaker portal?Check layout context, relationship keys, portal filters and field placement with a two-contact practice example.
Tool guide
Follow the error troubleshooter guideSeparate HTTP statuses from FileMaker codes, then capture a useful reproduction.
Tool guide
Get started with DDR ExplorerExport an XML DDR, follow field and script references, and review unresolved references privately in your browser.
Tool guide
DDR Explorer: features, instructions & privacyFind fields, scripts, layouts, missing references and readable text with the free, browser-only DDR Explorer 1.0. Findings describe the imported reports, not confirmed runtime errors. No project upload required.
Design & icons 15 resources
Quick answer
OnObjectValidate or OnObjectSave: which FileMaker trigger should I use? ↗Choose the right point for field feedback, and keep object events separate from record commits.
Worked tutorial
Build a FileMaker edit card with Save and Cancel ↗Keep proposed edits separate from business fields until the user saves successfully.
Case study · Demo download
Same theme. A clearer FileMaker form.Compare native before-and-after screenshots, inspect the theme and layout decisions, and download the editable desktop learning demo.
Article · Practice download
Set a useful tab order and visible keyboard focus in FileMakerWalk through a contact form without a mouse, fix its field sequence and check that the active control is easy to see.
Article · Practice download
Resize FileMaker layouts with anchors without overlapping controlsUse a small desktop form to predict how labels, fields, buttons and portals respond when a FileMaker window gets wider.
Article
Check a FileMaker color palette before styling your layoutsCompare text, fields and button states, repair weak contrast and take a small palette into a practice layout.
Article
Make SVG icons recolorable in FileMakerPrepare a simple SVG button icon, choose theme-controlled color, and check its appearance in FileMaker.
Article
Design consistent button states in FileMakerGive normal, hover, pressed and focus states clear roles, then reuse and test the styles across your layouts.
Article
Style a test layout with Spring Garden LiteImport the free theme into a copy of your FileMaker file, style a small set of controls, and review the result before applying it more widely.
Tool guide
Follow the theme color & contrast preview guideMeasure contrast pairs and review colors before applying them to a native layout.
Product guide
How to choose a FileMaker themeCompare palettes, inspect real controls and choose for the people who will use your app.
Product guide
Install and customize a FileMaker themeImport a theme, customize reusable UI styles, and save your variation. Includes a short video.
Product guide
Practical FileMaker UI designBuild action hierarchy, group fields and reuse styles. Includes two real theme examples and a visual action comparison.
Tool guide
Add a converted SVG to a FileMaker buttonPrepare your SVG for FileMaker buttons, or browse 2,188 free Heroicons and Lucide icons by category.
Tool guide · Practice download
Browse the icon libraryPrepare your SVG for FileMaker buttons, or browse 2,188 free Heroicons and Lucide icons by category.
Choose & set up 5 resources
Product guide
Themes, add-ons or solutions?A theme, an add-on and a solution serve different purposes. Here’s how to choose.
Product guide
Set up Filesoft DashboardInstall Filesoft Dashboard in a copy of your file, map the JSON provider and connect your scripts. Illustrated guide with adaptation examples.
Product guide
Read the configuration guide (PDF)Install Filesoft Dashboard in a copy of your file, map the JSON provider and connect your scripts. Illustrated guide with adaptation examples.
Product guide
FileMaker navigation sidebar guideInstall the free add-on, connect its relationship and configure your destination layouts.
Product guide
Equipment loan tracking guideFollow equipment from a draft loan through checkout and individual returns in Loan Desk.
Courses & solutions 12 resources
Case study · Email download
Track partial deliveries against purchase orders in FileMaker ↗Follow two deliveries, check the remaining quantities and understand saved receiving PDFs. Free example requires name and email.
Course
Explore the FileMaker coursesStart with Course 1 to build a contact-and-notes app, then follow three more six-lesson courses. Quizzes and practice files by Plato; native exercises use FileMaker Pro 26 on macOS, sold separately.
Course
Explore Course 2: a practical follow-up appContinue your Course 1 contact file: improve data entry, add follow-up tasks, find open work and make a printable report. Six lessons with quizzes and practice files; FileMaker Pro 26 on macOS.
Course
Explore Course 3Continue Course 2: add navigation, one-click searches, overdue cues and filtered task views, then reopen a completed task. Six lessons with quizzes and practice files; FileMaker Pro 26 on macOS.
Course
Explore Course 4Continue Course 3: connect projects and tasks, assign work by stable IDs, calculate progress and build a project report. Six lessons with quizzes and practice files; FileMaker Pro 26 on macOS.
Product guide
Project Delivery: Free StandardClients, projects, milestones, deliverables, client decisions and saved handovers with PDF export. Free Standard and US$99 Premium Cobalt Orchard share the same core workflow; the full Cobalt Orchard theme is sold separately.
Product guide
Project Delivery: Premium Cobalt OrchardClients, projects, milestones, deliverables, client decisions and saved handovers with PDF export. Free Standard and US$99 Premium Cobalt Orchard share the same core workflow; the full Cobalt Orchard theme is sold separately.
Product guide
Project Delivery: Setup guideClients, projects, milestones, deliverables, client decisions and saved handovers with PDF export. Free Standard and US$99 Premium Cobalt Orchard share the same core workflow; the full Cobalt Orchard theme is sold separately.
Product guide
Purchase Desk: Setup guideSet up your business details, explore optional samples, prepare purchase orders and check partial deliveries. Applies to free Standard and US$99 Premium Jade Meridian.
Product guide
Asset Care: Setup guideRegister equipment, plan maintenance, complete work orders and check service reports. For free Standard and US$99 Premium Orchid Alloy.
Product guide
Session Desk: Setup guideSet provider details, plan sessions, register participants and check attendance documents. For free Standard and US$99 Premium Jade Meridian.
Product guide
Project Delivery: Compare editionsClients, projects, milestones, deliverables, client decisions and saved handovers with PDF export. Free Standard and US$99 Premium Cobalt Orchard share the same core workflow; the full Cobalt Orchard theme is sold separately.
Hiring Desk setup guide
Prepare an empty workspace, track the hiring workflow and save documents.
Read the setup guide ↗Booking Desk setup guide
Prepare an empty room or studio booking workspace, check overlaps and save dated documents.
Read the setup guide ↗