Is it possible to have text fields pre-populate external data values based on the selection from separate drop down field?
For example, in the form, if the user selects the Caledonia location from the drop down field, the text fields below: Name, Address and Phone etc, populate with the values for that location, based on an external data file.
The user then may modify the text fields if needed. Dropdown prefills fields.pdf