Error "Cannot read properties of undefined (reading '0') or "Could not find document" when previewing a spreadsheet

Plan: Available: All plans 

Users: Available: All users

Practice Management Source: Available: All sources

Issue

When a Spreadsheet has been created by an automation process, the spreadsheet cannot be previewed without encountering one of the following errors:

  • Cannot read properties of undefined (reading '0')
  • Could not find document

Cause

The spreadsheet has been created with both Merge Fields and Merge Names enabled.

These settings control how Merge Fields from FYI are sent to the document, and with both options enabled, causes a conflict. 

Refer to Including Merge Fields in Excel Templates and Including Merge Names in Excel Templates.

Solution

  1. Click on the document to open the Spreadsheet drawer
     
  2. In the Filing section, ensure only one of the following options has been selected (click on the toggle to disable the other option):
    • Merge Fields
    • Merge Names

1983_Excel_Merge_Names.gif

Was this article helpful?
0 out of 0 found this helpful

Stay Up-To-Date

  • Events

    We host a range of product demos, training webinars, workshops and more.

  • Service Status

    Check for updates on the FYI Platform

  • What's New

    Round-up of new features, fixes, and other important announcements.