Populate a text field depending on text contained in another text field

Question

I have a text field named ReportNumber_TB. Users of my form will enter an alphanumeric code in ReportNumber_TB that includes employee initials.

I have another text field named ContactInfo_TB. I need ContactInfo_TB to automatically populate the full name and email address associated with the employee initials that were entered in ReportNumber_TB.

For example:

if ReportNumber_TB contains “AAA” then ContactInfo_TB populates with “Alice Adams, AAA@email.com”

if ReportNumber_TB contains “BBB” then ContactInfo_TB populates with “Bruce Banner, BBB@email.com”

if ReportNumber_TB contains “CCC” then ContactInfo_TB populates with “Chris Carter, CCC@email.com”

if ReportNumber_TB contains “DDD” then ContactInfo_TB populates with “Dan Davis, DDD@email.com”

What script can I use to do this? I’ve searched but can’t find anything to try that’s similar enough to what I need to accomplish.

try67 · Accepted Answer

As the custom calculation script of the second field enter the following code:

var v = this.getField("ReportNumber_TB").valueAsString;
if (/AAA/.test(v)) event.value = "Alice Adams, AAA@email.com";
else if (/BBB/.test(v)) event.value = "Bruce Banner, BBB@email.com"; // etc.
else event.value = "";

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.

Scanning file for viruses.

This file cannot be downloaded