# Perspective Table: How to display value in dropdown? **URL:** \ **Category:** Ignition\ **Tags:** ignition80, database, perspective\ **Created:** [January 22, 2021, 3:28pm UTC](https://forum.inductiveautomation.com/t/perspective-table-how-to-display-value-in-dropdown/42528 "2021-01-22T15:28:42Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![iceberg](https://avatars.discourse-cdn.com/v4/letter/i/e99b99/32.png) [@iceberg](https://forum.inductiveautomation.com/u/iceberg)\ **Post date:** [January 22, 2021, 3:28pm UTC](https://forum.inductiveautomation.com/t/perspective-table-how-to-display-value-in-dropdown/42528/1 "2021-01-22T15:28:42Z")
I am wondering if there is a way to display a dataset value in as the dropdown value in the perspective table? I have the table setup to write the “WAREHOUSE\_FUNCTIONAL\_AREA” value to a database when it is modified, but I am not able to get the current database value to display in the dropdown box when the table is relaunched. Any help would be appreciated. The dropdown is a view that is tied into the table column. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/0/20018cd43010af3cd58a65a53bf5cc4c0c10ad13.png) ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [January 23, 2021, 1:11pm UTC](https://forum.inductiveautomation.com/t/perspective-table-how-to-display-value-in-dropdown/42528/2 "2021-01-23T13:11:01Z")
From my limited experience, your dropdown should be in a view that is used in the table. The view should take two parameters: 1. The dataset or JSON object containing the options. 2. The _value_ property of the option to be selected. You would then bind the dropdown properties to the view parameters. ---
**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\ **Post date:** [May 27, 2024, 4:28pm UTC](https://forum.inductiveautomation.com/t/perspective-table-how-to-display-value-in-dropdown/42528/3 "2024-05-27T16:28:55Z")
If the dropdown options are bound to a query, and I have a value parameter on the view, and the table the view is embedded in has a JSON data type, how would I pass each row value to it's respective dropdown view? Does each row have an awareness of which row it is, so that I could use some sort of `getRowIndex` or `getValueAt` function? I realize those two functions need an input, so how would I go about getting that row index so I can get the value for the dropdown? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [May 27, 2024, 4:35pm UTC](https://forum.inductiveautomation.com/t/perspective-table-how-to-display-value-in-dropdown/42528/4 "2024-05-27T16:35:29Z")
Views used for cell rendering in a table get a couple automatic parameters: - `value` : the actual value in that cell of the table. - `rowData` : the complete row from `props.data` where that cell is located. Your cell rendering view simply needs to declare those input parameters to use them. ---
**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\ **Post date:** [May 27, 2024, 5:18pm UTC](https://forum.inductiveautomation.com/t/perspective-table-how-to-display-value-in-dropdown/42528/5 "2024-05-27T17:18:47Z")
I don't see how I access those automatic parameters. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/a/0a04bf2448611a694ff91872a0fc4bcab83c0866.png) This is from the embedded view that contains the dropdown. I added a parameter on the dropdown and it's view, so I could pass the `value` to it, but I'm not sure where to add or how to see those automatic ones you speak of. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [May 27, 2024, 5:23pm UTC](https://forum.inductiveautomation.com/t/perspective-table-how-to-display-value-in-dropdown/42528/6 "2024-05-27T17:23:57Z")
You configure those parameters on the view that is specified in the table as the column's rendering view. Then they are available within that view for binding from inner components or embedded views. Views that are intended to be used as cell rendering views are generally not applicable to other uses, and vice versa. The `value` and `rowData` params are not to be mentioned in the table's `columns` property, as they are **automatically** supplied to any rendering view that accepts them. ---
**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\ **Post date:** [May 27, 2024, 5:25pm UTC](https://forum.inductiveautomation.com/t/perspective-table-how-to-display-value-in-dropdown/42528/7 "2024-05-27T17:25:46Z")
Got it!