Copy link to clipboard
Copied
I have just installed Adobe DC Pro and slowly creating my first client form for my very small business. I am not a programmer or anything like it but hopefully with the community, YouTube and Google, I will hopefully get to the end still smiling.
On my form I have a drop down list of vets in the local area and hoping to save clients time and reduce potential mistakes link each of the vets to excel which then populates on the form the address and telephone numbers. So is this possible for me to do and would I be able to set it up without being too complicated?
Copy link to clipboard
Copied
It depends on what exactly you are trying to achieve and what exactly will you be able to catch up with if you have no prior experience Acrobat JavaScript.
Hard coding a simple script to populate fields in your PDF when something is selected from a dropdown menu may appear easy to some users.
However, the part that will deal with importing or exporting text delimited data to and from your PDF file to a MS Excel file could get complicated.
If I were you I would hire a developer to guide you through the workflow that you're trying to implement.
Copy link to clipboard
Copied
As mentioned, this requires a script. If the list of items is long, or if it frequently changes, hard-coding the data into the script will not be ideal. In that case it's better to use an external data source (it will need to be a plain-text file, though, not an xls(x) file), which the script will read, parse and use the data from it to populate the other fields when a selection is made in the drop-down.
I've actually created such a (paid-for) tool already, if you're interested. You can find it here:
https://www.try67.com/tool/acrobat-populate-fields-from-dropdown
Get ready! An upgraded Adobe Community experience is coming in January.
Learn more