# \[Perspective\] Turn table columns into dropdown

**URL:** <https://forum.inductiveautomation.com/t/perspective-turn-table-columns-into-dropdown/62332>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [July 27, 2022, 6:58am UTC](https://forum.inductiveautomation.com/t/perspective-turn-table-columns-into-dropdown/62332 "2022-07-27T06:58:12Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [July 27, 2022, 8:04am UTC](https://forum.inductiveautomation.com/t/perspective-turn-table-columns-into-dropdown/62332/4 "2022-07-27T08:04:40Z")

</div>

scope should probably be page instead of view.

> [@n.meluccio](#):
>
> ![Dropdown_event_script](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/8/783763446823a52e848347f1066dc8e7631294a8.jpeg)
> 
> Dropdown\_event\_script1577×891 102 KB

Updating the table directly is dangerous... Because im guessing you want the tables data to be filled by a binding it self. This will cause the binding to rewrite the data, so the users edit will be lost. Either update the sql directly here, or if they have to press a confirm button somewhere first, save all the changes seperately and make your table combine the pulled data and the changes

> [@n.meluccio](#):
>
> ![Table_script_message_handler](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/0/e0f794c9740691bce600171b560a118a04247be1.jpeg)
> 
> Table\_script\_message\_handler1011×763 61.5 KB

I dont think this will do anything because the event comes from the combobox and not from the tables onEdit, so you can delete this.

> [@n.meluccio](#):
>
> ![Table_script_onEditCellCommit](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/9/191a1653fe34d3722546ab8cefe99deddb4ca9b4.jpeg)
> 
> Table\_script\_onEditCellCommit911×889 72.3 KB

---

_[View the full topic](https://forum.inductiveautomation.com/t/perspective-turn-table-columns-into-dropdown/62332)._
