Skip to main content
Participant
May 31, 2024
Question

Need auto populate field by entering specified value in another field

  • May 31, 2024
  • 1 reply
  • 248 views

I have a long list of roughly 600 part numbers in an excel form that need to be entered into field 1. Is there a way that typing this can trigger an auto population of field 2 with a corresponding description of part?

 

 

This topic has been closed for replies.

1 reply

PDF Automation Station
Community Expert
Community Expert
May 31, 2024

If you use a dropdown for the part numbers, and enter the corresponding descriptions as the export values, you can populate Field 2 by entering a custom calculation script in field 2:

event.value=this.getField("Field1").value;//Field1 is the dropdown.

I developed a tool that allows you to copy both columns of part numbers and descriptions from Excel and paste them into a window to populate the dropdown.