Dropdown control allows the user to select one or more options from a specified list of choices. For example, it can be used to let the user select all the required entries from a list of cities.

Properties

UI Properties

  • Label: Label is the text that is displayed above the text box and helps the user to understand what the Dropdown is for.
  • Properties: These properties help you customize the Label by changing the text size, weight ( Light, Normal, Bold, Extra Bold, X Extra Bold), alignment (Left, Center, Right, Justified) and color of the label.
  • Type: The Type field is automatically generated depending upon the type of control used. In this case, it is a “dhq_dropdown” type.
  • Unique Name: A Unique Name is used to uniquely identify a control in your App. Every control that is added on the screen gets an auto-generated Unique Name on the basis of the Label name given to the control.
  • Submit Data: This field lets you determine whether to send the value of the control or not in Workflow based on various control states. There are three conditions that could be set for this field.
  1. Always: When this condition is selected, the selected fields will be submitted irrespective of the state of the Dropdown.
  2. Never: When this condition is selected, the selected fields will never be submitted irrespective of the state of the Dropdown.
  3. No When Hidden: When this condition is selected, the selected fields will be submitted if the Dropdown is visible and not submitted when the Dropdown is hidden.
  • Required: When you select the required option, the field becomes a mandatory field and the user can not submit without filling it.
  • Read Only: When you select this option, the user will no longer be able to edit this field.
  • Hidden: The hidden option helps you to hide the field from the user. This might help if you want to show certain fields only when a specific condition is met/not met.
  • Caching: When the caching option is selected and if a LOOKUP formula is applied to this control, the state that the LOOKUP returns will be cached and the user will be able to see this state in the Dropdown even when the user accesses the microapp later with no connectivity. This option is required when you want your app to be accessible in offline mode as well and getting the latest data from the sheets always is not critical.
  • Hide Label: This option hides the label of the Dropdown from the view.

Properties

  • Theme: This lets you choose the color of the Dropdown. You can either enter a custom hex code value or use one from the available themes in the builder.
  • Border: This option lets you change the color of the border of the Dropdown container.
  • Type: This lets you define if the user can select just one of the available options is the Dropdown or multiple options. There are two types that you can choose from in the dropdown.
  1. Single Select
  2. Multi-Select
  • Placeholder: It is a prompt that gives a hint to the user as to what has to be done. It is present in the Dropdown container and is overridden when the user selects one or more items. It will only be displayed when there is no default selected option in the Dropdown list.
  • Default Column Number: This is useful when you are displaying more than one column of Sheet using LOOKUP function, so this property will determine which column number’s value to be sent to Workflow on Submit or other dependent control.

How to Use a Dropdown?

Start with selecting the Dropdown from the Selection section of the Controls Menu.

The Dropdown will then appear on the screen in the builder, you can then set all the above properties as per your requirements.

You can use the F option to bind data to the Dropdown and the V option to add validations to the field. You can learn more about validations here. There are four ways in which you can bind data to the Dropdown field.

  1. Static Data: This is used to directly type in the text for each option that you want to display and add more options by pressing Enter key when you are at the last option. You can use the Selected option to define which of the options you wish to be selected by default.
  2. Sheet: This allows you to get data from a sheet and display it as the options of the Dropdown.
  3. Control: This allows you to bind data to the Dropdown by using another control’s value present in the microapp.
  4. Formula: The Formula options can be used to apply formulas and store the output of those formulas in the Dropdown. You can learn more about formulas here.

Preview

Dropdown with placeholder

Dropdown with default selected option

Dropdown options widget

You can search for a specific item using the search bar present.

Did this answer your question?