When designing advanced web forms, it may sometimes be necessary to adapt menu options to previous choices already made in the form. Dynamic Dropdown menus lets you create menus “live”, directly from cells, with formulas and all.
December 21, 2015 — SpreadsheetConverter is an add-on to Microsoft Excel that lets you convert spreadsheets to live web pages. The new version 8.2 recently became available at SpreadsheetConverter.com.
An electronic form may contain very advanced information structures. One such structure is the geographical relationship between country, state and city. Selecting the right city from a long, flat list of cities all over the world may be very time-consuming. For geographical information, most people would prefer to first select the right country, then the right state in that country, then the right city in that state.
“Excel is fantastic at handling large amounts of data. We designed the Dynamic Dropdown widget to help developers use Excel to handle very advanced information relationships in the converted web pages”, says Anna Winter, sales manager for SpreadsheetConverter.
The Dynamic Dropdown can also assemble menu choices in real-time using functions and formulas. This enables the developer to express the options in more detail, since much may already be known about a product, event or delivery from other fields in the form.
“As an example, you could have a menu that lets users choose between various courier services like FedEx or UPS. Using a dynamic menu, you could include also the actual price and even the expected delivery time for the planned shipment with each courier directly in the menu. This would enable users of the form to make much better decisions”, says Winter.
A Dynamic menu is set up using ordinary cells in Excel. Since the cell contents are live, a dynamic menu can provide the user with totally different options depending on the circumstances. On the web page, the dynamic menu looks just like an ordinary dropdown, and the underlying calculations occur so quickly and transparently that you won’t even notice them.
SpreadsheetConverter is available for free trial at /buy/free-trial/. It creates web pages that are completely standalone, do not use Excel and run on all web servers. You only need Excel and the Spreadsheet Converter add-on for the actual conversion from spreadsheet to web page format. There is a one-time fee for the conversion program, with no extra fees per page, user or server. You may use the program and the web pages it creates for as long as you like. Full versions start at $127.
Media contact: Anna Winter, email@example.com