Is there a way to auto populate a text field with consecutive numbers? Looking at the picture, say I start typing in 'Operation TypeRow1', I want the 'Op #' in that same row to auto populate as the number "10". and then when I start typing in Operation TypeRow2, I want the 'Op #' to auto populate to 20.
The Op # for a Rework is always 900. Say I type "Rework" into the 'Operation TypeRow', I want the cooresponding 'Op #' to auto populate as "900" but also keep the formatting mentioned above. Is this possible?
You can use something like this as the custom calculation script of the first "Op #" field:
var opType = this.getField("Operation TypeRow1").valueAsString;
if (opType=="") event.value = "";
else if (opType=="Rework") event.value = "900";
else event.value = "10";
Adjust the values and field names and you could use the same code for the other fields, too.
This worked great! Thank you!