How to add increasing numbers in a field on a duplicate record
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.