What is weak blocking?
Any blockages through setFormat in formatting (in all possible formats)!
As well as restrictions in select queries. If the select value is not in the dropdown list, it does not mean that it cannot be entered by tampering with the frontend.
What is strong blocking?
Role-based locks in field and table settings and in action codes!
How to stop the execution of any chain of actions if the control condition is not met?
To do this, you need to execute the function errorExeption at any point in the action code.
When executed, the chain of actions will be stopped and completely canceled!
How do I check the role or user before action?
The quick variable $#nr (now roles) — it returns a list of roles assigned to the user.
And if you want to guaranteedly reject any action if the role does not match the specified one, then:
=: if(condition: $#nr != $appr; then: $err)
appr: json`[1,2,5]`
err: errorExeption(text: "Only the Creator, Manager, and Boss can change the status!")
How to make a button to delete a row and check the conditions for deletion?
For example, in a row we create a "Delete" button that will delete the current row:
=: delete(table: $#ntn; where: 'id' = #id)
And we want to perform the check not in the button, but in some other field. And there we create the action code triggered by deletion:
=: if(condition: $#onfv = 3; then: $err)
err: errorExeption(text: "Cannot delete a row with status Approved")
And here is an important point — since a trigger on deletion is used, we need to take the previous value of the field — $#onfv.
Using table action code to strongly block any action in a table?
Sometimes it is necessary to block any action with a table if a certain condition is not met. This is often used for tables within loops.
For example, when an order is closed, nothing in it can be changed.
To avoid writing blocking action code for each field, there is table action code — this is an action code that is executed once for any change in the table before all other action codes in this table.
And in it, you can write:
=: if(condition: #status = 3; condition: $#nr != 1; then: $block)
block: errorExeption(text: "Cannot change Order in Shipped status!")
In this example, we unlock the change for the Creator!