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
Solved! Go to 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.
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.
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)
For future reference:
User | Count |
---|---|
33 | |
25 | |
22 | |
21 | |
15 |