What happens with a row when it is deleted when "Hide" deletion mode is selected?
By default, Deletion is set to Delete.
In Delete mode, rows are instantly deleted without the possibility of recovery.
There is no undo. For critical tables, you can set a deletion timer or attach a linkToInput call to the deletion trigger, requesting a PIN code input and throwing an errorException if it is incorrect.
But if you switch it to Hide, the rows will not be deleted — they will be marked as deleted.
Can it be restored?
Yes, by clicking the restore button. This feature can be restricted by roles.
What happens with a Select that uses a hidden value?
His display will be strikethrough.
What happens with codes that take values from a hidden row?
Values from the hidden row can only be taken if the query is where: 'id' = VALUE.
What should be done with the role, for the user to be able to duplicate rows in the table?