How do i subtract from all cells of a column

amer2 · 2024-09-15T09:23:18.488Z

I have an “Order” field in the “Lessons” datatype, and when deleting a lesson I need to subtract 1 from all the cells of the column “Order”.
Here is the example:

Order / Lesson
1 / introduction
2 / Datatype
3 / Privacy rules

When deleting the first lesson I need to change the order of all other lessons to it will be like this:

Order / Lesson
1 / Datatype
2 / Privacy Rules