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

[starryeyed223]

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 solution]

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 = "";

[starryeyed223]

It works! Thank you!