Create a number sequence starting at zero based and on another fields data.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a multiple text field with the following options:

Quality-1

EHS-2

Coatings-3

Structural-4

Mechanics-5

Estimating-6

HR-7

Tool Room-8

I have another field called document Number that I need to build a sequential number starting at zero for each of these categories based on how many of each record there are. For example; if I enter a record and select HR-7 and it is the first record with HR-7 selected, I need my Doc Number field to auto populate  001. If it is the third QA-1 record created, i need it to auto populate 003. Each option needs it's own sequencing.
Photo of Meme

Meme

  • 10 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,924 Points 20k badge 2x thumb