Sometimes you create records in an app which you no longer wish to see. Often times the reflex is to delete records. However, if records are deleted in error or you change your mind at a later date, there is no way to bring those records back...they’re gone forever.
In this article we’ll demonstrate how avoid these issues using archiving. Specifically how to archive records using role permissions.
Some cases where we might want to use role permissions include:
In this article we’ll focus on the first example: Allow users to archive materials related to a project so that they no longer add to project costs
Note: Records that users are not permitted to access will not be included in calculations.
Follow these steps to set up your archiving:
If you'd like a role (ex. Administrator) to be able to view and/or unarchive you can omit the custom rule, or toggle it off when the use needs to unarchive a record.
- Check the “Archive” field you created earlier on one of your table records. In our example we’ll archive our paint item.
- Return to your table and note that the ‘Paint item’ is no longer present:
So why would we remove the item via permissions rather than just using a condition to filter “archive” items from our reports?
First, we’d have to apply the same filter over and over whenever we create a new report. Second, and more importantly, records that a user doesn’t have permission to view are removed globally, meaning that items removed using this method will not be included in reports, lookup fields, formula fields or anywhere else within Quickbase.
In many ways this method is superior to deleting. If you delete a record it is gone forever. With archiving, a mistaken archive can easily be corrected by having a role which has permission to view ‘Archived’ records uncheck the archive field on a record.
Note: This method of archiving will not free up space in your database because the records are still located within the database.
For more of our knowledge base articles regarding how to leverage permissions click here.