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?
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.
1
Reply
AdChoices