Jump to: This document explains the two ways to implement drop-down lists: From the current application (applies to Retrievals & Reports templates) and from an external table (applies to Retrievals, Reports, and Maintenance templates).<\/p>\n Build your application as you normally would. Next, open m-Painter. Find the input box that you would like to convert into a drop-down box. From the image below, you can see I am working with a Multiple Record Retrieval.<\/p>\n Right-click on the input box you want to convert, and select "Insert\/Edit Option List" (Or you can left click on the input, and select the "Insert Option List" button from the m-Painter toolbar). A dialog will appear. Below, each option is explained:<\/p>\n Type — This list contains the different inputs you can choose:<\/p>\n Blank Option Text — If there is a value in this input, it will be used as the default value for the drop-down list. A very common value for this option is "Select a …" (Replacing … with the appropriate subject matter). If you do not specify default text, the end user is forced to select a value from their drop-down list.<\/p>\n Option Data Source — You have two valid options:<\/p>\n Apply to Field — This option tells m-Painter where to build your drop-down list. The value in this input box is decided by which input you clicked on when you created the drop-down list and does not need to be modified.<\/p>\n The below screenshot is the result set from our Current App drop-down list. Notice how in my small dataset, only the states listed in the table are available to select.<\/p>\n In this section we will cover how to create a drop-down from the current application.<\/p>\n Click "OK". Save and run your application.<\/p>\n In this section we will cover how to create a drop-down from an external table.<\/p>\n The below screenshot is the result set from our External table drop-down list. Notice how even though my dataset is still small, all 50 states are available. This is because the current table is not<\/strong> queried, but instead my external table (which contains all 50 states) is being used.<\/p>\n Combobox drop-downs are a combination of a text-input box and a drop-down lists which allows users to easily search within drop-down lists.<\/p>\n \n Combobox Options<\/p>\n \n<\/div>\n The Interactive Report Template allows for two "bonus" drop-down list options:<\/p>\n Both the Button List and the Check Box List allow you to create a list from the Current Application or from an External Table.<\/p>\n When creating either of these lists you will have the option of specifying how wide each item is and also how many items you wish to appear on each row.<\/p>\n After clicking "Accept", please note that your Button\/Check Box List will still render as drop-downs in m-Painter. Rest assured that at run-time they will appear correctly.<\/p>\n
\nCreating Drop-Down Lists from the Current Application<\/a>
\nCreating Drop-Down Lists from an External Table<\/a>
\nCreating Combobox Drop-Down Lists<\/a>
\nCreating Drop-Down Lists in the Interactive Report Template<\/a>
\nRelease Notes<\/a><\/p>\n![](\"\/legacy\/images\/dropdowns1.JPG\")
<\/p>\n![](\"\/legacy\/images\/dropdowns2.jpg\")
<\/p>\n\n
\n
![](\"\/legacy\/images\/dropdowns3.JPG\")
<\/p>\nCreating Drop-Down Lists from the Current Application<\/a><\/h2>\n
\n
Creating Drop-Down Lists from an External Table<\/a><\/h2>\n
\n
\n![](\"\/legacy\/images\/dropdowns4.JPG\")
<\/li>\n![](\"\/legacy\/images\/dropdowns5.JPG\")
<\/p>\nCreating Combobox Drop-downs<\/a><\/h2>\n
![](\"\/legacy\/images\/combobox.png\")
![](\"\/legacy\/images\/combobox1.png\")
<\/p>\n\n
![](\"\/legacy\/images\/combobox3.png\")
Checked<\/p>\n![](\"\/legacy\/images\/combobox2.png\")
Unchecked<\/p>\n\n
Creating Drop-Down Lists in the Interactive Report Template<\/a><\/h2>\n
\n
![](\"\/legacy\/images\/dropdowns6.JPG\")
<\/p>\n
![](\"\/legacy\/images\/dropdowns7.jpg\")
<\/td>\n![](\"\/legacy\/images\/dropdowns8.jpg\")
<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n