# Limit Entries in Editable Table

**URL:** <https://forum.inductiveautomation.com/t/limit-entries-in-editable-table/1625>\
**Category:** Archived Topics\
**Created:** [March 10, 2010, 9:01pm UTC](https://forum.inductiveautomation.com/t/limit-entries-in-editable-table/1625 "2010-03-10T21:01:59Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cas](https://avatars.discourse-cdn.com/v4/letter/c/77aa72/32.png) [@Cas](https://forum.inductiveautomation.com/u/Cas)\
**Post date:** [March 10, 2010, 9:01pm UTC](https://forum.inductiveautomation.com/t/limit-entries-in-editable-table/1625/1 "2010-03-10T21:01:59Z")

</div>

Hello,  
I have an Editable Table in my FPMI project. I downloaded it from the Goodies section.  
One column is named “Ingredient”. There are only a few valid entries for this column.  
I would like the user to be able to select an entry from a list rather than type freeform. This will avoid typos.

Can I get some ideas about how to make a list box pop up when a cell in the “Ingredients” column is clicked for editing, and limit the entries to the items on the list?

Thanks,  
Cas

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [March 11, 2010, 4:41pm UTC](https://forum.inductiveautomation.com/t/limit-entries-in-editable-table/1625/2 "2010-03-11T16:41:32Z")

</div>

The editable table currently doesn’t have an ability to do this.

You can do this more easily using the breakout-editing style of table manipulation. This is a common paradigm where you have dedicated input controls (text fields, dropdowns, etc) for each field and then an “Add/Edit” button that will either insert a new row or edit the selected row.

The “Dairy” demo project has some examples of this in the administrative section.

---

<div class="post-metadata">

**Author:** ![stuartd](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@stuartd](https://forum.inductiveautomation.com/u/stuartd)\
**Post date:** [December 10, 2013, 5:19pm UTC](https://forum.inductiveautomation.com/t/limit-entries-in-editable-table/1625/3 "2013-12-10T17:19:05Z")

</div>

Hey, has there been any changes to this? I am looking to do something similar?

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [December 11, 2013, 12:57am UTC](https://forum.inductiveautomation.com/t/limit-entries-in-editable-table/1625/4 "2013-12-11T00:57:49Z")

</div>

For editable columns that have the translation table feature turned on, they’ll get a dropdown instead of free-form edit.

---

<div class="post-metadata">

**Author:** ![jim\_lapratt](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\
**Post date:** [December 11, 2013, 1:20pm UTC](https://forum.inductiveautomation.com/t/limit-entries-in-editable-table/1625/5 "2013-12-11T13:20:45Z")

</div>

How would one have the mapping’s be populated from a query instead of manually entering them?

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [December 11, 2013, 6:50pm UTC](https://forum.inductiveautomation.com/t/limit-entries-in-editable-table/1625/6 "2013-12-11T18:50:09Z")

</div>

One wouldn’t… 😊

For what its worth, we’re aware that this isn’t exactly how people want this to work and are working on an alternative table for 7.7