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

    Sequential Number Calculations

    sotura

      I have a table with the following 5 fields:

       

      Location

      Building

      EquipmentClassification

      EquipmentType

      SequentialNumber

       

      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?