Can I sort the rows in the table manually?
Yes, for this you need to enable sorting by order field.
How to sort is described here.
How does the order of calculation of rows change when "Order by N-order field" is enabled?
Strings in the lowercase section, when changed simultaneously by default, are calculated in ascending order of their id. But if sorting by the order field is enabled, then in ascending order of n.
In which technical field is the order of the rows written?
Field n. The row sorting number can be obtained as #n or select ... field: 'n'. If manual row sorting is disabled, such references will return an error.
When the order is changed, n values are reassigned.
When adding to the end, n increments by 1.
When adding between rows, the inserted row receives a fractional n.
A large fractional number is used there, but if you have a situation where insertion always occurs between rows, then you need to schedule a task (more on that later) to run the normalizeN function — it removes these fractional tails.
Why do we need automatic recalculation in case of an order change?
The parameter automatic recalculation when changing order is used when you have rows that reference previous ones in the codes — then, when saving the new order, the earliest n is found and all rows with a larger n will be recalculated.
Example code for calculating sequential row numbering:
=: if(condition: $sel = ""; then: 1; else: $calc)
calc: $sel + 1
// the addition row has #id = "" — so we do another check
~sel: if(condition: #id = ""; then: $s1; else: $s2)
s1: select(table: $#ntn; field: 'id'; order: 'n' desc)
s2: select(table: $#ntn; field: 'id'; where: 'n' < #n; order: 'id' desc)