Copy link to clipboard
Copied
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.
Side Question:
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.
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
This worked great! Thank you!