MicroStrategy ONE

Formatting a List control

The List style displays as:

  • A drop-down list in Web

  • A wheel on an iPhone

  • A list on an iPad or Android device

For steps to navigate to where you can select the following options, see Creating a transaction-enabled document.

To format a List control

  1. You can require that users specify a value using the input object control before submitting their changes. Do one of the following:

    • To require users to specify a value for the control before submitting their changes, select the Input is required check box.

    • To allow users to submit their changes without specifying a value, clear the Input is required check box.

  2. You can display the list automatically when the document is viewed, or display the list only when a user selects its grid cell or text field. Do one of the following:

    • To display the list automatically, select the Show by default check box.

    • To display the list when its grid cell or text field is selected, clear the Show by default check box.

  3. To specify a width for the list, type the value (in inches) in the Width field.

  4. You can automatically generate the values displayed in the list, or manually determine the values. If determined manually, you can specify the text displayed for each choice that is presented to the user, and the value to use to update, insert, or delete data. Select one of the following under Input type:

    • To display automatically generated values, select Calculated.

      1. Specify the lowest and highest selectable values in the list by typing values in the Minimum value field and the Maximum value field.

      2. To specify the interval displayed between each value in the list, type a value in the Interval field. For example, if the minimum value is 0 and the interval is 10, users can specify 0, 10, 20, 30, and so on.

    • To use manually entered values, select Manual.

      1. In the Value field, type the value to use when the choice is selected.

      2. In the Label field, type the text to display for the choice.

      3. To add another choice to the list, hover the cursor over a choice and click the Add icon. A new choice is added below the selected choice.

      4. To delete a choice from the list, hover the cursor over the choice and click the Delete icon.

      5. Repeat the appropriate steps above for each value that you want to display.

      6. By default, when the text field or grid cell of the list is set to a value for which no label is defined in the Control Properties, the list is displayed as blank and no value is selected. You can specify text to display in the list instead. To do so, type the text to display in the first field in the Label column, next to the Unset field.

    • To display a list of attribute elements from a selected dataset, select Dataset. Perform the following steps:

      1. From the Source drop-down list, select the dataset that contains the attribute that you want to use to display the list control.

      2. From the Attribute drop-down list, select the attribute whose elements you want to use as options in the list.

      3. You can specify the attribute form MicroStrategy will use to display each attribute element as an option in the list. For example, you can choose to display the ID of each attribute element as an option in the List control. From the Displayed Forms drop-down list, select one of the following:

        • To allow MicroStrategy to automatically determine which attribute form to display, select Automatic.

        • To manually specify the attribute form you want to use to display options in the list, select the name of the attribute form.

      4. From the Writeback Form drop-down list, select the attribute form to use to update your data. The value of this form will be supplied to the Transaction Services report when a user selects an attribute element from the list control.