Prevent certain records from being deleted

[marcelo34]

Hello,
I have a table named “Orders” where clients create new records with the default value of “Pending” for the column Status.
If the order gets processed by the internal team, the value of “status” changes to “confirmed”

The client should only be able to delete records that have [Status]=“Pending”.
I realize that with Behavior I can control if it can be edited, but this does not prevent it from being deleted.

The only workarround I see, is copying/moving the record to another table when the Status changes.
Is there another option?

Thanks

[Suvrutt_Gurjar · Accepted solution]

Have you tried setting the condition of the system delete action for the Order table to [Status]=“Pending”

Additionally if you wish that the delete action be available to say your internal team, you could use their emails in the conditions.

[marcelo34]

Thanks Suvrutt!
Took me a while to find “system Actions” but it was exactly what I needed!!

(anyone else, “system actions” are in tiny-little-small print in the behaviors section)

[Steve]

For future reference: