Skip to main content
Question

Abort the Delete when Check box field is checked?

  • November 15, 2019
  • 0 replies
  • 51 views

Hi,

Say,
* I have a table with a checkbox field.
* I have 10 records in the table.
* There are 4 records with Checkbox checked. i.e., (Checkbox=True) and 6 records which are not checked

Can we restrict the User from not able to delete the Checked Records?
i.e., When all the 10 records in the table are selected and Clicked on to DELETE, it Should just delete 6 Non-Checked records and should still show 4 Checked Records. 

Can We Achieve This?




------------------------------
Vivek Vishwanath
Hyderabad, India
+91 8185868789
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • November 15, 2019
Well, you cannot do that, but here is an approach.

set permissions for that class of users not to be blue to delete.

make a checkbox field called [Delete]

then trigger an Automation to actually do the deletions if some conditions are met.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

BrianCafferelli
Forum|alt.badge.img+17
Alternatively, as a workaround have you considered allowing these users to simply archive records instead? You could add a checkbox field called Archived, and either use custom data rules to control which records the users are allowed to archive - or create a report of archived records which admin users could review and determine which ones should be deleted. The only drawback here is that you would need to update the filters for your reports to only show records which have not been archived.

This is similar to your suggestion Mark, just adding some additional guardrails to help ensure the wrong records aren't being deleted.

------------------------------
Brian Cafferelli
------------------------------