Skip to main content
D
DGodfrey90
Known Participant
September 16, 2022
Question

Can't get autopopulate dropdowns to work by any method

  • September 16, 2022
  • 2 replies
  • 1981 views

I am going to please ask for help again. I have basically started from scratch on this. I have figured out how to get one piece of this to work, but not the other.

On my form I have a "MasterList" dropdown set to accept custom text from the other 18 dropdowns "Location" (I don't care if it is Location 1.0, etc or Location1, etc. whatever will work). These also allow custom text entry. As it stands, this part works. I can add to the MasterList all day long from these fields with the validation script I have. I finally got that part figured out. I need it to work this way and also allow me to clear the Location dropdowns with my clear form button and on page load. This also is currently working.

 

The part I cannt get to work by any code I have tried, whether document level or in the validation script, or otherwise is this: I want to autopopulate the 18 Location dropdowns with all of the items in the MasterList, not just one item and not just a blank like it is currently doing. Always blank fields. MasterList is already populated by the option tab with the initial list plus whatever is added from the other fields. I need this to be dynamically autopopulated FROM all of  the current MasterList items to the 18 Location dropdowns. Obviously the 18 boxes will be an exact copy of the MasterList when the box is clicked on. I am NOT using an "ADD" button to do this, it must occur in the background The MasterList will be hidden in the final form.

Can someone please help me with this final piece? I have wasted far too much time on this. I don't kn0w what I'm missing and some code from other threads actaully create syntax errors or otherwise or break the part I do have working.  I have attached the version that is working as far as adding to the MasterList. If there is a better way than repeating the same validation script 18 times that would be nice too, but I just want it to work.

 

Thank you very much. I hope this is easier to troubleshoot than my previous posts on the subject.

This topic has been closed for replies.

2 replies

try67
Community Expert
try67Community Expert
Community Expert
September 17, 2022

When do you want this to happen? Whenever the user enters a new item into one of the drop-downs?

D
DGodfrey90Author
Known Participant
September 17, 2022

Yes, if row one has a new entry, it should be available in Row 3 or 4 or whatever, ideally, but definitely in the MasterList the next time the file is opened (and likewise available in all the dropdowns as well, upon opening). Not sure about the MasterList being saved when the file is closed...I haven't really gotten to that point yet.  I don't want them to have to type a repeat location every month or within the same month. It's an additive list that should be available any time the form is filled out.

 

I hope that clarifies it and thanks for responding.

try67
Community Expert
try67Community Expert
Community Expert
September 18, 2022

If you save the file when closing it, the list will be saved, just like anything else in it. If you don't, the items added to it since the last save will be lost, of course.

ls_rbls
Community Expert
ls_rblsCommunity Expert
Community Expert
September 17, 2022

Did you get a chance to see the last file that I fixed and shared with you back on 5th September in the older thread?

 

If you missed it here's the link:

 

 

If you already tested it and this not what you were asking help with then disregard.

 

 

D
DGodfrey90Author
Known Participant
September 18, 2022

I'm still testing this. You removed the "MasterList field altogether? I checked sort on the boxes, but they are not sorting. Location1 has two blank spaces and I can't delete either one so that there is only one. I "downloaded a copy" of the shared file and I have a status bar that is stuck on "Preparing the shared file"? If you can help me with these few things I will test thoroughly and ket you know. To answer your question, I did not see this until you asked. Thanks for the work.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices