Forum Discussion
BlakeHarrison
5 years agoQrew Captain
First, I would ask if it's absolutely necessary that the users should be able to actually delete the records. Unless the table houses hundreds of thousands of records and space on the table is at a premium, I generally recommend that only Management or Administrators are able to fully delete records. Instead, I put a process in place that allows users to recommend a record for "deletion" and then mark the record as "Inactive" or "Deleted" and use that field as a filter so that users can no longer access it, but it remains in the system.
If you DO need to actually remove the record, but want to keep an archive of deleted records, I would still do the same process as above, but would add in two Automations or Pipelines. The first automation would make a copy of any record marked for deletion and then mark the original that a copy had been created. The second automation would actually delete the records. I typically set these up so that there is a period of about 48 hours between when the record is originally marked to when it is deleted. Something like this:
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
If you DO need to actually remove the record, but want to keep an archive of deleted records, I would still do the same process as above, but would add in two Automations or Pipelines. The first automation would make a copy of any record marked for deletion and then mark the original that a copy had been created. The second automation would actually delete the records. I typically set these up so that there is a period of about 48 hours between when the record is originally marked to when it is deleted. Something like this:
- Day 1 - Record is flagged for Deletion
- Day 2 - Records flagged as Deleted Yesterday are copied to the Archive and flagged as having been Archived (Automation 1)
- Day 3 - Records flagged as Archived Yesterday are deleted (Automation 2)
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
- DanielSirbu5 years agoQrew MemberThanks, that was fast! Points taken on the necessity and on earmarking for Deletions, good proposal. But what is the fastest way to configure and disable certain roles from actually seeing and hitting a Delete button?
Daniel
------------------------------
Daniel Sirbu
------------------------------- BlakeHarrison5 years agoQrew CaptainThat would be in the settings for each Role. Once you access the Role, go to the Properties tab and you'll see something that looks like the below image. Uncheck the 'Delete' permissions for that Role and it will immediate take effect.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------