AnsweredAssumed Answered

How to add increasing numbers in a field on a duplicate record

Question asked by AliSheikh on Dec 5, 2013
Latest reply on Dec 5, 2013 by philmodjunk

Title

How to add increasing numbers in a field on a duplicate record

Post

     Hello,

            I have a field called part_name on an items layout . What I'm trying to do is to get this field to show an, r1, r2 and so on, at the end of the part's name, each time I duplicate that record.

      

     So for example I have a part with a part name called Delta. WHen I duplicate the record delta, I want the new duplicate record to show delta r1 . When I duplicate delta r1, I want the new duplicate to show delta r2, and so on.

      

     P.S. part_name is not a unique identifier, its just a text field.

      

     Any help would be appreciated, thanks.

Outcomes