Why do I need the Show at the order location on adding parameter?
When the sort by order field parameter is enabled for the table, users have the ability to manually change the order of rows.
This also allows for immediately displaying rows in the sorted position upon their addition.
Another bonus is the ability to insert rows via code after a specific row.
How do I use n and after to paste in the right place?
To insert new rows after a specific existing row in the table, you need to obtain the id of that row.
Then, in insert or insertList, use the after parameter where you pass the id after which the insertion should occur:
=: insert(table: 'table'; field: 'data' = #data; after: $select)
select: select(table: 'table'; field: 'id'; where: 'summ' >= 100; order: 'summ' asc)
Let's add rows after the smallest value of summ >= 100.
What kind of difficulties can be found in the regular insertion between existing rows?
The fact is that when inserting between two existing values with n enabled, it gets fragmented. Despite n having a very high bit depth, this resource is limited!
What technical action needs to be designed in such cases?
If you have a table where rows are constantly being inserted — you need to set up a cron job to execute normalizeN.
During normalization, n does not trigger the recalculation unit. That is, rows are not recalculated. If fields in rows reference #n, they will not be recalculated!