Hello Marcelo,
You can do it. First, you need a have a screen that displays all the records you want to update in a grid. For my example I chose Invoices. Next, create a button that will have actions that will update the sort order field for the records in the grid.
Here is an explanation of the actions.
1. Start Loop Through Grid - A Basic loop that takes you through each record in the grid individually. It has a corresponding End Loop Through Grid.
2. Basic Math Calculation - While in the loop, you retain the individual record you are on. Here, I take the SortOrder value for the record the loop is on and multilpy it by 10 to get the extra 0.
3. Update Filed in Table - I have the value I need but it is not yet in the table. I need to update the actual table record which is what I am doing with this action.
Basic Math Calculation
Update Field in Table Action
This should work for all the transactions. I did run into an issue where one transaction would not save and the loop stopped. You may run into this problem and have to update a transaction manually and re-run the actions if it can't save on the Update Field In Table transaction. Just watch out you don't run the action twice on the same records or you will get two zeros.
Greg