How to populate a field with a sequence / Accumulative value based on a value of another field?

[rawansaleh1]

Hi ,

Is there any way to calculate field based on another field values with a sequence number and if we can make the process automatically?

For Example, I have a feature layer in AGOL with the following field in the attribute table (Defect ID, Defect Location), I need to calculate Defect ID based on Defect location.

In other words, If the value in defect location equal “M4 Bridge” then I need the Defect ID to be Bridge 001, bridge 002…ect, and if the value in the defect location equal “Road” then I need the defect ID to be HR_001, HR002..etc.

 

Is there any way to implement an Automate this?

Thanks in advance,

Rawan