I have a parent page, with a page properties macro. There are child pages under the parent. The child pages have a numbered priority row, so we can number the child pages as a priority, kind of like our backlog. So each child page has this priority number on it at the top of the page, and the page properties macros on the parent sorts by that field.
Task Name | Priority (Sorted) | Contact Name
Research | 1 | John Doe
Code | 2 | Bob Smith
Test | 3 | Sam Jones
The end result is, on the parent page, you see a bunch of development items in the page property table that is sorted by the priority number.
When developers start work on that item, the item is moved from its current parent folder, into an "in progress" folder.
What that causes is, when child with priority one is moved, then the page properties table shows the priority two record as the top record...as expected.
Task Name | Priority (Sorted) | Contact Name
Code | 2 | Bob Smith
Test | 3 | Sam Jones
Is there a macro, that will allow me to sequentially renumber the priority column of all the child pages to kind of reseed like so:
Task Name | Priority (Sorted) | Contact Name
Code | 1 | Bob Smith
Test | 2 | Sam Jones
