Find the outcome you need.
Start with a symptom, a platform or the thing you want working.
With JavaScript, search filters the whole collection in your browser. Without it, use the linked pages and section navigation below; query filters need JavaScript.
Showing entries 41–80 of 98 in this first collection.
Troubleshooting guide
Splitting a repetitive Airtable table into linked tables: how the matching works and where it goes wrong
Why exact text matching, commas and formula primary fields matter, and the order that keeps counts reconcilable when one table becomes two.
Troubleshooting guide
A scheduled job that asks for records since its last run: why it loses some and repeats others
Four small pieces make polling reliable: a checkpoint, an overlap, a key for every record and complete paging. See why each exists.
Troubleshooting guide
Who is told when an automation fails? What each tool really does, and how to test it
Zapier, Make, n8n and Airtable each alert in different ways, with delays, gaps and side effects. Find out where yours goes, then test it by breaking a copy.
Troubleshooting guide
Verify a webhook signature on the exact bytes you received, not the data you parsed
Why a correct secret can still fail, how to compare signatures safely, which identifier to trust against replays, and how to test a receiver with known inputs.
Troubleshooting guide
The sender says webhook delivery failed: timeouts, retries, deleted subscriptions and missed events
Answer quickly, expect repeats, and know how to find and replay events that arrived while your endpoint was down.
Troubleshooting guide
Duplicate HubSpot contacts or companies after a web form: which route created them
HubSpot matches contacts by email and companies by domain, but the route a lead takes decides what happens. Learn the four routes and the risks of merging.
Troubleshooting guide
New HubSpot leads with no owner: how rotation, away users and fallbacks really behave
Write the routing rules first, then learn what the rotate action counts for contact records, how HubSpot's Leads tool differs, and where a lead ends up when nobody is available.
Troubleshooting guide
A HubSpot field keeps changing back from Salesforce: sync rules, baselines and picklist errors
Read the sync rule on the field, understand the first-sync baseline, then check types, picklists and where HubSpot lists sync errors.
Troubleshooting guide
A Zap created the record twice: find which of five causes it was
Count the runs, then check for a second Zap on the same trigger, a self-trigger, a replay and a plain create step before you change anything.
Troubleshooting guide
A Zap stopped or shows Errored or Halted: what each status means and what to replay
Read the run status first, understand why a Zap turns itself off, and know what a replay repeats and why error emails can arrive hours late.
Troubleshooting guide
A Make scenario stopped on one record: error handlers and incomplete executions explained
What Make does by default when a module fails, what the five error handlers do, why a route that only sends a message skips the error, and why a stored incomplete execution can hold back the next run.
Troubleshooting guide
A scheduled report arrived at the wrong time or covered the wrong days
Find out which clock your automation tool uses, fix the reporting period in one place, and test across a clock change instead of assuming.
Troubleshooting guide
An n8n webhook works while you watch but not afterwards: test and production URLs
The Webhook node has two addresses with different rules. See which one your sender uses, how to read production runs, and how to be told when one fails.
Platform
Zapier automations: what repeats, what stops and who is told
The documented behaviours behind duplicate records, switched-off Zaps, late alerts and scheduled runs, and which outcome fits each problem.
Platform
Make scenarios: default failure behaviour, error routes and who is told
What Make does when a module fails, how error handlers and incomplete executions change it, and which outcomes cover one bad record or missing alerts.
Platform
Airtable bases: automations that fail or skip records, and tables that repeat themselves
Documented causes of failed and skipped automation runs, limits that count failed runs, and how linked records match, with the outcomes that fit each.
Platform
HubSpot lead flow: duplicates, owners and the Salesforce sync
How HubSpot matches contacts and companies, assigns owners, and syncs mapped fields with Salesforce, and which outcomes fix duplicates, routing and field reverts.
Troubleshooting guide
Converting an ERP export for a store import: decimal commas, day-first dates, codes and rejects
Why hand-editing an ERP export produces different files on different days, and how explicit number, date and code rules, exact decimal arithmetic and a reject file make the conversion repeatable.
Inspectable example
Synthetic price list: a page-by-page row count that finds two mistakes a matching total hides
An invented three-page price list shows why rows are counted per page. A first extraction matches on the total, 14 of 14, while page 1 is a row short and page 2 has an extra row.
Inspectable example
Synthetic merged-cell report flattened: nine rows in, five records out, every total reconciled
An invented printed-style sales report with merged region labels, subtotal rows and a spacer becomes a flat five-record table, with a reconciliation showing 9 original rows = 5 records + 4 removed.
Inspectable example
Synthetic quotation: why the same three lines total 4.38 or 4.39 depending on the rounding rule
Three invented lines of 1.30 plus a 12.5 per cent add-on give 4.38 if the add-on is rounded per line and 4.39 if it is rounded on the total. The rule must be written down.
Inspectable example
Synthetic rename manifest: three clean renames with matching checksums and four held names
An invented seven-file folder shows a dry run and a manifest with a row for every file, with three renamed files whose checksums match, and four held, a pair of names that differ only in letter case, a reserved device name and a name ending in a period, all listed, not guessed.
Inspectable example
Synthetic date column: which rows a rule can settle, and which must stay on the ambiguity list
Nine invented entries show day-first and month-first typing, a two-digit year, a row where only one reading is possible, an impossible date and a four-year shift, with the decision and reason for each.
Platform
PDF documents: getting data, forms and searchable text out of office files
For office managers and administrators with PDF price lists, filled forms and scans: how to tell which kind of PDF you have, how to check what is extracted and where a paid, checked job fits.
Platform
Microsoft Excel workbooks: repair, tidy and make them reliable
For administrators and small businesses who rely on Excel: where workbooks go wrong, the order to diagnose them in, and the checked, fixed-scope jobs that repair formulas, flatten layouts and clean dates and duplicates.
Buyer collection
For an office manager: sort your PDF, scan and old-file jobs into do it yourself, buy, or leave
List the jobs by what the file actually is, find the ones your own software already handles, and ask for outside help only where volume, repetition or the need for a checked record justifies it.
Buyer collection
For an operations lead: stop rebuilding the weekly report by hand, or decide to hand it over
Work out what the report actually costs you in steps, put the method in writing, decide whether to template it yourself or hand it over, and choose checks that show each pack matches its export.
Collection
A messy workbook: the order to diagnose it in, and where each fix leads
Seven checks in a fixed order, from stale calculation to import readiness, each pointing to the guide that explains it and the checked job that covers it if you would rather not do it yourself.
Collection
From a PDF to a checked spreadsheet: the order of questions that saves the most effort
Seven steps from "does it have text?" to "who signs off the exceptions?", linked to the guides, the worked example and the checked jobs, including what to do when the same document arrives every month.
Troubleshooting guide
Excel shows #REF! or #NAME?: work out which kind of broken formula you have
Each Excel error value points to a different kind of break. Learn what they mean, how to trace a formula back to its inputs, and why hiding the error is not a repair.
Troubleshooting guide
Totals look wrong but Excel shows no error: stale calculation, text numbers and displayed versus stored values
When no error appears, three quiet causes explain most wrong totals: manual calculation, numbers stored as text and rounding that is displayed but not stored. Here is how to tell which.
Troubleshooting guide
Merged cells stop Excel sorting and pivoting: how to flatten a printed-style report safely
Merged group labels, spacer rows and subtotal lines make a report readable on paper and unusable as data. See what merging does, what a flat table needs and how to prove nothing was lost.
Troubleshooting guide
Dates sort wrongly or change between computers: serial numbers, text dates and day-month order
Excel stores dates as numbers and reads typed dates through regional settings. Learn how text dates, a four-year offset and day-first entries produce wrong sorting, and what to do with rows that cannot be settled.
Troubleshooting guide
Cleaning duplicates in a contact list: write the match rules before you delete anything
Removing duplicates is a set of decisions, not a button. Compare exact and near matches, avoid merging people who only share a field, and keep a log so every merge can be undone.
Troubleshooting guide
Old .doc and .xls files: what converting really changes and how to check a whole batch
Converting one old Office file is easy. Converting a folder needs an inventory, copies instead of overwrites, a decision about macros and a check that the new files match the old.
Troubleshooting guide
Renaming thousands of files: rules, collisions, path limits and a manifest that proves nothing changed
A bulk rename can overwrite files, break on reserved names or exceed path limits. A dry run, a rule check and a checksum manifest make it safe and reversible.
Troubleshooting guide
Mail merge and quotation templates: why numbers arrive wrong and how to test a batch
A merge copies cell values into a template. Currency symbols, percentages and codes come through differently from how they look, so calculations and formats must be settled before the merge.
Troubleshooting guide
Rebuilding the same report every week or month: how to make it repeatable and checkable
A recurring report drifts when it is rebuilt by hand. Fix the export contract, make refreshing change only the data, and add control totals so each period can be checked against its source.
Troubleshooting guide
Before you import a spreadsheet into another system: the checks that stop a failed load
Loads fail on blanks, types, dates, codes and keys. A column-by-column readiness sheet, the right CSV handling and a test on a copy catch most problems before they reach a live system.
Troubleshooting guide
Can this PDF be read as data? Check for a text layer before you plan an extraction
A PDF can hold selectable text or only a picture of each page. A two-minute test tells you which, and that decides the method, the checks and what anyone can honestly promise.