Auto Create Dropdown List

[Brian31867616qsyt]

I have text fields that information is typed into, with separate fields to name, street address and city/state/ZIP, for example":

Alan Adams         111 First Street               Adams, CA  11111

Bob Bowman       222 Second Street      Brookings, NY  22222

Carl Carlson         333 Third Street           Collins, IL  33333

etc. up to 25 lines

I would like the name boxes to auto-populate into a separate drop-down list box, and then when one of the names is selected from the drop-down list, the name street address  and city/state/ZIP are entered into another set of text fields.  So, if Bob Bowman is selected from the drop-down list, Bob's name would populate into another text field, his street address would populate into yet another text field and his city/state/ZIP would populate into yet another text field.

Is this possible?

[Nesa Nurani]

It's possible, does the names changes or are they fixed?

[Brian31867616qsyt]

Once entered, the names and addresses would not change.

[try67]

Then why copy them from the fields? It's easier to hard-code them into the drop-down or code directly.

[Brian31867616qsyt]

That's the way I have it now, but there are some documents where I might use some of the names, not all of them.  If I have a list of ten names, I want to be able to pick, say names 3, 6 and 8 to insert into the document instead of having all ten names populate and have to delete the names I don't want and move names and addresses into empty spaces.

[try67]

Yes, but it's not a trivial task. You would need to write a set of custom scripts to do it: One script to populate the drop-down with the data from the input fields and another to populate the other fields when a selection is made in the latter.

You would also need to think about when to update the drop-down and the second set of fields.

Say the user entered Alan Adams's data and then selected it from the drop-down, but saw they made a mistake in the address for Alan in the first set of fields and went to correct it. It would then need to not only re-apply the values in the drop-down, but also in the second set of fields, or at least reset them and require the user to make the selection again... And what about if they changed the name, not just the address? Say if it's not "Alan Adams", but actually "Alan Adam"? Then the entire thing will have to be cleared, as the name doesn't match any longer to the selection in the drop-down, etc.