Auto fill fields based on text entered in another field

Question

Hello,I fill out multiple PDF forms a day, and I’m looking to save time by having some of the fields auto fill based on information from another field.  ie: When I enter a Customers Name at the top of the form, I’d like to have 2 other fields auto fill;  Zip Code, and Travel Days.Would it be better to use a script, import data from Excel, or import data from Access?  I’m new to this kind of thing, so any help would be greatly appreciated!

default2io3ybp6itq6 · Answer

Hi,

Thanks for reaching out to us. For the example that you shared, are the fields which you want to be autopopulated are static always? If yes, you can use simple javascript like

if (this.getField("Customer Name").valueAsString=="xyz")

event.value = "Some zipcode";

else

event.value = "Some other zipcode";

Or else, it can be done from an excel sheet too. You can checkout this page as an example: https://answers.acrobatusers.com/Can-I-import-data-Excel-spreadsheet-fillable-PDF-Form-q113686.aspx

Thanks

[As Community Admin we are removing personal details to avoid phishing attempts]

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