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:

 

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?

Outcomes