Editing Drop Down Lists

Kristian Fraser

Hi,

 

I have created a drop down list of names but i accidently found out that i missed one. How can i add a new name to the already created drop down list?

 

Thanks in advance

Dave B

You can't edit dropdown list contents in the web form builder.

 

Open the sheet, double click the column header and add the name.  Save the sheet.  Reload the web form and it will be there.

Kristian Fraser

THANK YOU, such a simple answer when pointed out.

Zoee S

Hi - I have a related question...

 

How about if you had used the sheet with the drop down list as a template for many projects, and now need to update the list? Is there a way to update all sheets at once, or is that a manual process? Thanks!

Stephanie Taylor

I beleive that would be a manual process.  I would definately update the template but any sheets created prior to that would have to be manually updated.

Dave B

Zoee,

 

I agree it's a manual process, but to speed it along, I'd fix the template then use CTRL-A (select all) and CTRL-C (copy) to copy the new drop-down list.  Then in the old sheets dropdown lists, use CTRL-A, Backspace, CTRL-V to select all, delete, paste.

 

This will be faster than manually typing in the new updates one by one.

 

Dave

J. Craig Williams

Fir dropdown updates across the system, Richard at Smarter Business Processes (richardr@smarterbusinessprocesses.com) has a solution using Azuqua.

Contact him for a demo.

 

Craig

Dave B

If you're old: There's a pill for that.

 

If you're young: There's an app for that.

 

If you're smart:  Mo money, mo money, mo money!

 

Kitty

Thank you!  This helps me tremendously this morning!!

Kitty

Once the drop-down list is in place and a month later I need to add a new name, keeping the list in alphabetical order - is there a way to reorder the names to put the new name in the correct spot?