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
Here is another approach. Make an Automation to delete the record when a certain checkbox is checked. The automation run under the Permissions authority of who created it (actually who last modified it).
So sort of by remote control, the user can request the automation to fire.
Then you have infinite control over who can see or edit that checkbox field and even if the user does not have permissions to delete record, that can "phone a friend" (if you remember that TV show "Who wants to be a millionaire"), and ask them for help.
So sort of by remote control, the user can request the automation to fire.
Then you have infinite control over who can see or edit that checkbox field and even if the user does not have permissions to delete record, that can "phone a friend" (if you remember that TV show "Who wants to be a millionaire"), and ask them for help.
The other approach that i used to use was a webhook to delete the single record. But there is some 'coding" syntax involved in setting up a webhook, so I would not try to guide someone though that coding on this forum.