Skip to main content
egar040203
egar040203
Participant
December 12, 2016
Answered

Create a JavaScript

  • December 12, 2016
  • 1 reply
  • 592 views

Hello all -

I am hoping someone could help me create javascript for a personal reimbursement for that I have created for my office.

I would like for the employee id (six digit number) to auto populate in field B, when an employee enters their last name in field A. There is approx 50 or so employees in my office and I would like to capture all of them in these to fields.

Thank you in advance for you help.

This topic has been closed for replies.
Correct answer try67

The most simple way of doing it is with a series of statements like this (this code should be placed as the custom calculation script of the Employee ID field):

var employeeName = this.getField("Employee Name").valueAsString;
if (employeeName=="") event.value = "";
else if (employeeName=="John Doe") event.value = "123456";
else if (employeeName=="Jane Doe") event.value = "789000"; // etc.

1 reply

try67
Community Expert
try67Community Expert
Community Expert
December 12, 2016

There are a couple of ways it can be done. You can hard code the employee numbers and names into a script and then use a simple lookup or if-condition, or you can do it using an embedded text file that contains all of that data, and then when you need to update the list you just replace the text file with the new version and it will automatically update the lookup table. The latter is more complex, of course, and requires a custom-made script, but is much easier to maintain in the longer run.

For the former see this tutorial: https://acrobatusers.com/tutorials/change_another_field

If you're interested in hiring someone to develop the latter for you, feel free to contact me privately via try6767 at gmail.com.

egar040203
egar040203Author
Participant
December 12, 2016

I haven't done any scripts for a while now, but how would hard coding the employee numbers and names look like in a script?

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
December 12, 2016

The most simple way of doing it is with a series of statements like this (this code should be placed as the custom calculation script of the Employee ID field):

var employeeName = this.getField("Employee Name").valueAsString;
if (employeeName=="") event.value = "";
else if (employeeName=="John Doe") event.value = "123456";
else if (employeeName=="Jane Doe") event.value = "789000"; // etc.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices