Auto Populating Text Fields

Question

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?

try67 · Accepted Answer

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.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.