# Dropdown view in table problematic behaviour - perspective

**URL:** <https://forum.inductiveautomation.com/t/dropdown-view-in-table-problematic-behaviour-perspective/97973>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [October 30, 2024, 8:03pm UTC](https://forum.inductiveautomation.com/t/dropdown-view-in-table-problematic-behaviour-perspective/97973 "2024-10-30T20:03:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Francesco\_Vittadini](https://avatars.discourse-cdn.com/v4/letter/f/9dc877/32.png) [@Francesco\_Vittadini](https://forum.inductiveautomation.com/u/Francesco_Vittadini)\
**Post date:** [October 30, 2024, 8:03pm UTC](https://forum.inductiveautomation.com/t/dropdown-view-in-table-problematic-behaviour-perspective/97973/1 "2024-10-30T20:03:20Z")

</div>

Hello  
i have a problem on a table with some columns with view

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/1/c16de9326e05b34e0b25251120222d66ccd47be3.png)  
All columns are populated from named query  
When a value in columns BC1 to BC4 is choosen using dropdown, that value is immediately written in db (script).  
Yellow button will execute some event, remove the line and refresh the table values (refreshbinding).  
The problem is that, supposing I've choosen value 1 in dropdown BC1 and value 2 in dropdown BC2 for example, when the line is validated so it will disappear, values 1 and 2 will appear on the line below.  
These values will not be written in DB. It's just a matter of visualization which confuses a lot the final user  
Moreover if user has to choose value 1 on BC1 he needs to change to 2 for example and then back to 1. Only in this way value 1 will be written in DB  
The only way to go back to initial situation is to close the page and reopen it.

I don't know if I was able to explain the issue. I hope so  
Anyone has any idea how to bypass this?  
Thanks

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [October 30, 2024, 9:07pm UTC](https://forum.inductiveautomation.com/t/dropdown-view-in-table-problematic-behaviour-perspective/97973/2 "2024-10-30T21:07:30Z")

</div>

> [@Francesco\_Vittadini](#):
>
> when the line is validated so it will disappear, values 1 and 2 will appear on the line below.

I'm not sure what you mean by "validated" here? How come the next row's columns display as the newly selected values?

> [@Francesco\_Vittadini](#):
>
> Moreover if user has to choose value 1 on BC1 he needs to change to 2 for example and then back to 1. Only in this way value 1 will be written in DB

Where is your script defined that writes the selected value into the dB?

If you could get a screen video capture that might help