Skip to main content
Known Participant
March 28, 2025
Question

Auto Create Dropdown List

  • March 28, 2025
  • 2 replies
  • 440 views

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?

 

 

2 replies

try67
Community Expert
Community Expert
March 28, 2025

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.

Nesa Nurani
Community Expert
Community Expert
March 28, 2025

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

Known Participant
March 28, 2025

Once entered, the names and addresses would not change.

try67
Community Expert
Community Expert
March 28, 2025

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