AnsweredAssumed Answered

Sequential Number Calculations

Question asked by sotura on Jun 14, 2016
Latest reply on Jun 30, 2016 by greatgrey

I have a table with the following 5 fields:








For each combination of Location - Building - EquipmentClassification – EquipmentType I will have multiple rows.


I would like to create a calculated field that populates the SequentialNumber field. I would like the number to start at 1 and increment by 1. At each change in Location / Building / Class / Type I would like the SequentialNumber to start at 1 again.


I think I can accomplish this by writing script that loops through all of the records in a batch once all my records are entered.


Is there any way this can be accomplished using a calculated field and adding the SequentialNumber as each record is added?