Using CSV table to auto-populate form based on dropdown selection

Question

I need to make a PDF form filable based on data I'm given in .csv format.

The .csv has the following headings that match what the form fields are called in the PDF.
Tail, Designation, Serial, MTOW, MLW, Noise, Full, Approach, Flyover, Overflight, and Takeoff.

I have a dropdown with all of the numbers in the Tail column. What I want is the rest of the form to fill based on what is selected in the dropdown.

1. I have basically no javascript knowledge and was wondering if someone would be able to help me in coding this.

2. Since I may not be the one who always edits the file in the future, would it be possible to make a .bat file or something that someone could drag and drop the .csv file on and the .bat would automatically output the javascript to a .txt file that could be pasted into the PDF?

Thanks in advance!

try67 · Accepted Answer

1. This is not a trivial task if you don't have any JS knowledge at all.

2. You can't use a bat file for this, nor do you need to. The script doesn't need to contain the data from the CSV file. You need to attach the CSV to the PDF and then the script will read its contents and use them to populate the fields.

To update the data all you'll need to do is to replace the old CSV file with the new one, save the PDF and then re-open it, and the code will use the new data.

I've actually already developed a paid-for tool that will allow you to do all of that, without having to write any code.

You can find it here: https://www.try67.com/tool/acrobat-populate-fields-from-dropdown