Introduction

Drop-downs can be added to grids or form fields on screens using a dedicated view. The below image shows a drop-down on a grid.

Drop-downs can be styled to suit your needs, including row colours, row heights and mouse-over colours, see Adding Styling to a Drop-Down View.

Create a Drop-Down on a Grid

1. Create a view containing the data you wish to display in your drop-down list
   
   

   Expand
   title How?
   Anchor CreateView CreateView This can be configured from your Insert excerpt _erd _erd nopanel true  by clicking on the table header, or from a screen that currently displays a view of the data, by right-clicking and choosing  Insert excerpt _show_table_configuration _show_table_configuration nopanel true . In the  Insert excerpt _tables _tables nopanel true 's  Insert excerpt _property_tabs _property_tabs nopanel true , expand the Views section Click  Insert excerpt _addIcon _addIcon nopanel true  to create a new view Give the view an appropriate name and press Insert excerpt _save _save nopanel true We recommend the view name is prefixed with DD_ to indicate it's for a drop-down In the View Attributes section, select the  Insert excerpt _attributes_icon _attributes_icon nopanel true  icon to open the Available Attributes selector Drag across the attributes you wish to see in the drop-down view into the View Attributes section on the  Insert excerpt _property_tabs _property_tabs nopanel true , then press OK (Optional) On the Insert excerpt _property_tabs _property_tabs name style nopanel true  for the new View, choose or create new styles, if required See Adding Styling to a Drop-Down View

   
   

2. Insert excerpt
   _pin _pin nopanel true

    either the table or drop-down view tab to keep it open
3. On a screen containing a

   Insert excerpt
   _grid _grid nopanel true

   , click on the attribute header for the column where you want to display drop down fields
4. The View Attribute

   Insert excerpt
   _property_tabs _property_tabs nopanel true

   will open
5. On the

   Insert excerpt
   _property_tabs _property_tabs name style nopanel true

   , untick Read Only
6. On the 

   Insert excerpt
   _property_tabs _property_tabs nopanel true

   , drag across your drop-down view into the Selection View field, found in the Drop Down Settings section of the View Attribute properties
   
   

7. Insert excerpt
   _save _save nopanel true

    the properties
8. Close and reopen the screen, then 

   Insert excerpt
   _lock _lock nopanel true

    the screen to see the changes

Create a Drop-Down on a Form

1. Create a view containing the data you wish to display in your drop-down list
   

   Expand
   title How?
   See How? above.

   
   

2. Insert excerpt
   _pin _pin nopanel true

    either the table or drop-down view tab to keep it open
3. On a screen containing a

   Insert excerpt
   _form _form nopanel true

   fields, click on the drop-down field where you want to display the drop down
   1. If your field is not configured as a drop down, right-click it and choose 

      Insert excerpt
      _template_change _template_change nopanel true

   2. Select the Drop Down (Manual) template from the Serene Grey palette
4. The Drop Down

   Insert excerpt
   _property_tabs _property_tabs nopanel true

   will open
5. In the Basic Settings section of the View Attribute properties, make the following changes:
   1. Drag across your drop-down view into the View Name field
      
      
   2. In the Drop Down Value Field, enter the name of the attribute from your drop down view that you want to display in the field 
      
      

6. Insert excerpt
   _save _save nopanel true

    the properties
7. Close and reopen the screen, then 

   Insert excerpt
   _lock _lock nopanel true

    the screen to see the changes

Dynamically Update Form Fields After Drop-Down Selection

Multiple form fields can be dynamically updated depending on the option a user selects in a drop-down field. In the example below, a user selects a customer from the Customer Number drop down field and the fields, Customer First Name, Customer Last Name and Customer Email Address, are dynamically updated.

1. Follow the above steps to create a drop-down on a form
2. In the Drop-Down component properties, in the Mappings section,

   Insert excerpt
   _add _add nopanel true

   mappings to link the data and fields
   1. Assign each Form Field (field name on the screen) to a Drop Down Field (attribute name)
      
3. (Optional) For each field being updated dynamically, enabled Read Only in the 

   Insert excerpt
   _property_tabs _property_tabs name style nopanel true