Custom rule for deleting a record, possible?
When you go into a table's access panel to view the roles and their permissions against it, you have the option to make custom rules for the viewing and modifying of a record. There is no option like...
Forum Discussion
Thanks for all the replies. I've been busy with a couple other projects and now able to get back into this one. Will take a look at the automation, and also the button hiding shortly.
So what worked for me is to remove the delete permission for all access on the table in question. Then leave just the administration role with the delete permission. (I would have created another role, but then it looks like I would have to setup a user specifically for that role when I created the automation then). This allowed the delete method to disappear completely for that table, both with the form and with any grid edits or users like to do. I then create a checkbox for deleting and added it to the form. Then I created the automation script to be triggered when a record in that table is modified and the deletion checkbox is checked. This worked. I also added in another step to that to modify the parent table (for our case) and add a note stating who deleted the record and basic information about that record. Works great!
Glad they added the automations!
Thanks!
Glad they added the automations!
Thanks!