I am wondering if there is a way to archive prior year records or move them to another table?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
We have reached the maximum number of records in our existing table (max size 10,000) and it will no longer show all records.  We have to filter to find what we are now looking for.  I am wondering if there is a way to archive prior year records or move them to another table?
Photo of Marsha Snyder Kasowski

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
So by default when a table reaches 10,000+ records QB options to not display them right away (for speed and performance reasons).

However, What you can do is set up a  report that filters out old records, and then set that report as the table homepage. 

Then every time somebody clicks the table they see the filtered report that in effect "archives" all the old records.

If you need more details on how to set that up, just post back with your questions or where you get stuck.

I am very new at report writing with this software so any assistance you could give me would be great.


Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,702 Points 50k badge 2x thumb
When the table home page is set to the default report, you get the default behavior.

The default behavior is as Matthew described,

But if you change your table home page report to be a report, even the List All report, then it will continue to behave as it used to with the full report and a filter box. The assumption is that if you consciencly choose the list all report and knowing choose to take the risk of slowing down your app, then that is your choice.