AnsweredAssumed Answered

Script to automatically renumber other records when one is manually renumbered

Question asked by bruderdog on May 22, 2014
Latest reply on Sep 3, 2014 by JeremyBrooke

Title

Script to automatically renumber other records when one is manually renumbered

Post

     Hi, I have a product list which is sorted numerically in ascending order (see picture). The Product Numbers are editable, and the list resorts automatically. However, I need a script to automatically renumber the records i didn't modify to avoid duplicate Product Numbers. ObjectModify will trigger this script.

Example with picture below:

     -If I change 6 to 8, 7 and 8 should become 6 and 7.

     -If I change 8 to 6, 6 and 7 should become 7 and 8.

Screen Shot:

     Any ideas? I'm pretty new to this so go easy on me.

     J

      

Outcomes