Troubleshooting Missing or Disappearing Records

If you're certain that a sheet previously contained one or more records and no one has deleted them, but you can’t find them now, try the following methods to troubleshoot the issue.

1. Checking for Filters or Sorting

The most common reason records appear to be missing is that filters or sorting have been applied to the sheet. This can hide records from view or move them to another page based on the sort order.

Try clearing all filters and sorting settings, then recheck the sheet to see if the missing records reappear.

2. Using Full Text Search

Use the Full Text Search bar at the top to look for keywords from the missing record. This can help confirm whether the record still exists in the database but is simply not visible due to display settings or incorrect assumptions about its location.

3. Checking the Recycle Bin

Try restoring relevant records from the Recycle Bin. The record may have been accidentally deleted.

4. Checking for Related Subtable Records in Other Sheets

Confirm whether this sheet was created as a New Sheet From Subtable or as a Referenced Subtable in another sheet.

In these cases, even if the record wasn’t deleted in this sheet, it may have been removed from the related subtable, which causes it to also disappear here.