Using something like the excel LEFT formula in a PDF

Question

I have a PDF that collects the student's name and birthday. We then take the first three letters of their last name, the first two letters for their first name, and the two digit birth year and create an unique testing ID for each student. This is simple to do in excel with the LEFT formula but I want the fill-able PDF to do this and can't figure out the correct javascript to make it happen. First name, Last name, and birthday are all in separate fields in the PDF currently.

Example:

Last Name: Smith

First Name: Jane

Birthday: 01/03/1980

Desired result in separate field: SMIJA80

Thanks! Dayna

try67 · Accepted Answer

Use this code as the custom calculation script of the target field:

event.value = (this.getField("Last Name").valueAsString.substr(0,2) + this.getField("First Name").valueAsString.substr(0,2) + 
     this.getField("Birthday").valueAsString.substr(-2)).toUpperCase();

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