">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1668958/RackMultipart20171103-14093-c41o7g-MCF_Tech_LogoforQBComm_inline.jpg?1509736865">
We have a solution at MCF for automatically creating backups (among other data capabilities) but I'll save that for last and layout a purely native option.
There are a couple ways to do this, but the one way to do this without writing custom code would be to create a sync table in your main app to "clone" all the records in your main table, and schedule that connected table to "sync" daily. You could then change the report subscription you have now to the new table.
Keep in mind, (depending on how you set this sync up with regards to the "Key" fields in each table) there are to routes you can take.
A. You set the same key field on the clone table as the original, which will effectively buy you 24 hours to review the data before it's overwritten on the next Sync,
B. You choose an alternative keyfield than the one in the main table which will keep a "copy" of your main tables records as they were when they were cloned, but you're clone table will grow pretty rapidly, so you'd want to periodlically delete the older records by "date created"
Both of these have pro's and cons, but here's what we offer that would behave the way you want.
https://www.mcftech.com/technology/add-ons-extensions/backup/Hope this helps!