What is the simplest way to do a basic lookup to populate fields either further down in the form, or to hidden fields on form submit?
Example:
I’m asking users to select their account name.
Ideally, I don’t want them to have to type in any additional information that we may already have. Such as Address, Phone Number, Account Number, Etc. I’d like them to, once selecting their account name, be have the other data populate the remainder of the form.
Currently, I have everything stored in a CSV file. I’m hoping for some simple/elegant way to simply have a call out to the CSV file and pull in the data based on the selected value.