2 Replies Latest reply on Jun 30, 2016 1:04 AM by greatgrey

    Sequential Number Calculations


      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?