Repeating group list of tasks ordered by the field Task_Group when you delete an item you use the updated Cell index to re-index the order and store into the Task_Group

Need help Database
1

Eg. Repeating group list of tasks ordered by the field Task_Group when you delete an item you use the updated Cell index to re-index the order and store into the Task_Group

Task 1 – Task_Group = 1
Task 2 – Task_Group = 2
Task 3 – Task_Group = 3

In the workflow
Step 1 - Task 2 is deleted
Step 2 - Then I do a page refresh (Update all Cell index)
Step 3 - Then I want to now update all remaining Tasks

Task 1 – Task_Group = will now equal 1 (using the Cell index)
Task 3 – Task_Group = will now equal 2 (using the Cell index)

Then the page is refreshed again
Can anyone help me to do this simply

2

i think you have to consider using schedule a backend workflow on list (of remaining tasks)

3

The question is, do you really need the order to always remain sequential (no missing numbers) when items are removed? Because if that’s not the case, you wouldn’t even need to worry about it.

But if you really need this, depending of the amount of records in the list, you could follow the suggestion above or use some approach like the suggestion below, before remove the record:

1 - Use the action Make changes to a list of things
2 - Then set the list RG's List of things :items from # Current Cell's Index or in cases when the RG may have some filters applied to it maybe you need to set the list directly from the Database to avoid issues. In this case you could use Do a search for {Select Thing} and then set the constraint Order > Current Cell's Order.
3 - Update Order field to Order = This Thing's Order - 1