# Customizable Column Data Formats on Table Views **URL:** \ **Category:** Product Feedback\ **Created:** [March 10, 2018, 12:24am UTC](https://connect.superhuman.com/t/customizable-column-data-formats-on-table-views/301 "2018-03-10T00:24:34Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Lane\_Greer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/lane_greer/32/5619_2.png) [@Lane\_Greer](https://connect.superhuman.com/u/Lane_Greer)\ **Post date:** [March 10, 2018, 12:24am UTC](https://connect.superhuman.com/t/customizable-column-data-formats-on-table-views/301/1 "2018-03-10T00:24:34Z")
When I’m on a Section which is defined by filtered views of master tables, I want to source column selectable items from only the values available in the views represented on that section. If I were to just populate from the master table there would be tons of irrelevant data I’d have to weed through. I would like to be able to customize the column selectable list items from any table for a view of a master table and those customized selectables only apply to that column on that view. Today, if I create a column data format in a Table View of TableMaster like =View1ofTableMaster.Col3() and then I create another view of TableMaster and I want to source the selectable list items from =View2ofTableMaster.Col3() then the first column format is overwritten. ---
**Author:** ![Al\_Chen](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/al_chen/32/7293_2.png) [@Al\_Chen](https://connect.superhuman.com/u/Al_Chen)\ **Post date:** [March 10, 2018, 2:40pm UTC](https://connect.superhuman.com/t/customizable-column-data-formats-on-table-views/301/2 "2018-03-10T14:40:59Z")
How is the select list in your master table currently populated? Not sure if this would solve your challenge, but I would store the list of selectable items in a different table and then each view built off of the master table would filter out the values you don’t need. In the example below, the select list in the “Employee” column would only show the names Pam and Dwight: ![00%20AM](https://global.discourse-cdn.com/coda1/original/1X/6adff8b70c16f88806381acb215e6772e0a804e5.png) ---
**Author:** ![Lane\_Greer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/lane_greer/32/5619_2.png) [@Lane\_Greer](https://connect.superhuman.com/u/Lane_Greer)\ **Post date:** [March 14, 2018, 2:27pm UTC](https://connect.superhuman.com/t/customizable-column-data-formats-on-table-views/301/3 "2018-03-14T14:27:42Z")
I believe this method will still result in the “Selectable Items” formula being added to all additional views of this master table, correct? ---
**Author:** ![Al\_Chen](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/al_chen/32/7293_2.png) [@Al\_Chen](https://connect.superhuman.com/u/Al_Chen)\ **Post date:** [March 14, 2018, 3:06pm UTC](https://connect.superhuman.com/t/customizable-column-data-formats-on-table-views/301/4 "2018-03-14T15:06:34Z")
Correct. I understand the issue you are trying to solve. My thinking was that you would create individual tables where you can manually change the select list, but it sounds like you are sticking with the master table=\>multiple views structure. I don’t this is doable right now given the bi-directional nature of tables and views, but if I think of anything I’ll let you know! ---
**Author:** ![evan](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/evan/32/5534_2.png) [@evan](https://connect.superhuman.com/u/evan)\ **Post date:** [March 15, 2018, 5:39am UTC](https://connect.superhuman.com/t/customizable-column-data-formats-on-table-views/301/5 "2018-03-15T05:39:49Z")
@Lane_Greer totally see what you’re looking for - in the current Coda parlance it sounds like you want to dynamically pass the filter predicate for a given View into a formula within a select list. Conceptually it could work by enhancing our `ThisTable()` namespace to reference the Table or View you’re looking at and return the subset of values based on the filter applied (currently `ThisTable()` accesses all rows from the source Table without considering filters etc.). This does create some infrastructure issues but definitely something we should look into! ---
**Author:** ![Lane\_Greer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/lane_greer/32/5619_2.png) [@Lane\_Greer](https://connect.superhuman.com/u/Lane_Greer)\ **Post date:** [March 17, 2018, 1:42am UTC](https://connect.superhuman.com/t/customizable-column-data-formats-on-table-views/301/6 "2018-03-17T01:42:48Z")
I actually fully solved this by using Master.Filter(mastercol=thisrow.childcol).masterrefcol ---
**Author:** ![Al\_Chen](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/al_chen/32/7293_2.png) [@Al\_Chen](https://connect.superhuman.com/u/Al_Chen)\ **Post date:** [March 18, 2018, 12:07am UTC](https://connect.superhuman.com/t/customizable-column-data-formats-on-table-views/301/7 "2018-03-18T00:07:41Z")
@Lane_Greer Can you share an example of what you did in Coda? Is this the formula you put the Select List of the view? ---
**Author:** ![Lane\_Greer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/lane_greer/32/5619_2.png) [@Lane\_Greer](https://connect.superhuman.com/u/Lane_Greer)\ **Post date:** [March 18, 2018, 12:41am UTC](https://connect.superhuman.com/t/customizable-column-data-formats-on-table-views/301/8 "2018-03-18T00:41:44Z")
Uhh. It’s actually a ton easier to show than to explain