# Table and Dropdown Insert to DB issue

**URL:** <https://forum.inductiveautomation.com/t/table-and-dropdown-insert-to-db-issue/18495>\
**Category:** Ignition\
**Created:** [June 16, 2018, 9:53pm UTC](https://forum.inductiveautomation.com/t/table-and-dropdown-insert-to-db-issue/18495 "2018-06-16T21:53:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jshaffer09](https://avatars.discourse-cdn.com/v4/letter/j/df788c/32.png) [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\
**Post date:** [June 16, 2018, 9:53pm UTC](https://forum.inductiveautomation.com/t/table-and-dropdown-insert-to-db-issue/18495/1 "2018-06-16T21:53:26Z")

</div>

I can get 1 row to insert but not all the rows in the table. It should loop through each one and avoid the rows where column 1 is blank.

---

<div class="post-metadata">

**Author:** ![jshaffer09](https://avatars.discourse-cdn.com/v4/letter/j/df788c/32.png) [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\
**Post date:** [June 16, 2018, 11:02pm UTC](https://forum.inductiveautomation.com/t/table-and-dropdown-insert-to-db-issue/18495/2 "2018-06-16T23:02:39Z")

</div>

if I put a value in each row in column 4 then it will insert all 9 rows that are completely field out. before I just had a value in one row in column 4. well thats one part. Now that part is figured out.

I need to set it up to where if column 2 values are = “no” then column 4 values can’t be blank for that row  
but if column 2 values are =“yes” then column 4 values can be blank. any ideas.

---

<div class="post-metadata">

**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:** [June 17, 2018, 1:18am UTC](https://forum.inductiveautomation.com/t/table-and-dropdown-insert-to-db-issue/18495/3 "2018-06-17T01:18:13Z")

</div>

Please edit your post to have a triple-backquote (these: ```) line above your code and another below your code, so it’ll format with readable indendation.

---

<div class="post-metadata">

**Author:** ![jshaffer09](https://avatars.discourse-cdn.com/v4/letter/j/df788c/32.png) [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\
**Post date:** [June 17, 2018, 8:00pm UTC](https://forum.inductiveautomation.com/t/table-and-dropdown-insert-to-db-issue/18495/4 "2018-06-17T20:00:30Z")

</div>

I belive I have it where it is readable