Skip to main content
C
CC_132445408-Gravel
8-Gravel
April 13, 2026
Question

JSON Configuration for Grid Column Edit: Dropdown List Using Service Data

  • April 13, 2026
  • 1 reply
  • 33 views

I am trying to configure a grid widget to editable via a dropdown list in one or more columns.

I have reviewed the documentation here and here. 
Both documents that detail JSON configuration and dropdown lists indicate statically defining the dropdown list selections in the JSON configuration directly (ie

"dropdownConfiguration": {"items": ["Active", "Parked", "Undergoing Maintenance"]}

Due to the potential size and expected change over time for the list of selections I would like to define the dropdown list via a service rather than statically defined in the JSON configuration.

I would appreciate some guidance on how to define a data source to be used for the dropdown list 

1 reply

S
slangleyCommunity Manager
Community Manager
April 22, 2026

Hi @CC_13244540

To configure a grid widget with an editable dropdown list sourced from a service rather than statically defined in the JSON configuration, follow these steps:

  1. Select the Grid Widget: In your mashup, select the Grid widget and open the properties panel.

  2. Open Columns Configuration: Access the columns configuration dialog.

  3. Choose the Column: In the left pane, select the column where you want to add the dropdown.

  4. Enable Editing: Ensure the column is editable by checking the Editable checkbox.

  5. Configure Column Renderer:

    • Under the Column Renderer tab, set:
      • Column Renderer: Select STRING.
      • Cell Editor: Choose Dropdown.
      • Dropdown Source: Select "From Service".

  6. Select Data Source:

    • Click the "+" button and select the All Data property of the infotable that contains your dropdown items.

  7. Specify Dropdown Value Field: Indicate the column that contains the values for the dropdown items.

  8. Optional Dependent Fields: If necessary, configure any dependent fields that will dynamically update the dropdown list based on selections in other fields.

  9. Save Configuration: Click Done to close the dialog and save your changes.

By following these steps, you can successfully set up a dynamic dropdown list in your grid widget that retrieves data from a service, allowing for flexibility as the list of selections changes over time.

For further details on configuring the grid using JSON data, you can refer to the Configuring the Grid using JSON Data.

Regards.

--Sharon

    Terms & ConditionsAccessibility statement