# Multiple Similar Operations for a row in a table **URL:** \ **Category:** Ask for Help\ **Created:** [June 19, 2023, 8:59pm UTC](https://community.glideapps.com/t/multiple-similar-operations-for-a-row-in-a-table/62944 "2023-06-19T20:59:46Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Prasanth\_Thoppe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prasanth_thoppe/32/57244_2.png) [@Prasanth\_Thoppe](https://community.glideapps.com/u/Prasanth_Thoppe)\ **Post date:** [June 19, 2023, 8:59pm UTC](https://community.glideapps.com/t/multiple-similar-operations-for-a-row-in-a-table/62944/1 "2023-06-19T20:59:46Z")
Hello Gliders. Need some help in designing table. I need to store the data of patients in a single row and I find the best way to make modifications easier. For eg : Lets say each patient’s data is being recorded for every organ. There are 20 organs - Brain, Heart, Lungs, Stomach etc. And each organ has 6 metadata - Front, Back, Top, Bottom, Left, Right. So there are 6 x 20 columns for each patient (Brain/Front, Brain/Back, Brain/Left, Brain/Right etc… ). If I have a container component for each organ and its metadata, and to calculate the visibility for each organ to show on UI, I have to create 20 more computed columns to set visibility. Is there a way to have 1 logic and repeat this for 20 times depending on the organ? Currently I have to create 20 columns for 1 functionality - visibility. If there are 5 functionalities for each organs (say IsVisible, IsGood, IsTreated , IsSuccessful, IsNormal etc) I need 20 X 5 = 100 columns. If there is some logic change, I have to keep repeating the change 20 times. Whats the best way to do this ? Few other challenges that I face : If I want to reference those 20 x 6 columns in another table, I have to re-create those column lookups Cant duplicate multiple columns - Even though I have grouped it with ‘/’ in table name Cant delete multiple columns I’m fairly new to Glide and any ideas are appreciated. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 19, 2023, 11:33pm UTC](https://community.glideapps.com/t/multiple-similar-operations-for-a-row-in-a-table/62944/2 "2023-06-19T23:33:59Z")
> [@Prasanth\_Thoppe](#): > > Cant duplicate multiple columns - Even though I have grouped it with ‘/’ in table name > Cant delete multiple columns You can’t do this as of now. > [@Prasanth\_Thoppe](#): > > If I have a container component for each organ and its metadata, and to calculate the visibility for each organ to show on UI Can you tell us more what decides if a component should be visible or not? It sounds like you can group them into a container, but it might be more complex than I think. ---
**Author:** ![Prasanth\_Thoppe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prasanth_thoppe/32/57244_2.png) [@Prasanth\_Thoppe](https://community.glideapps.com/u/Prasanth_Thoppe)\ **Post date:** [June 20, 2023, 12:32am UTC](https://community.glideapps.com/t/multiple-similar-operations-for-a-row-in-a-table/62944/3 "2023-06-20T00:32:54Z")
For visibility - If one of the values of the meta data is updated, then it should be visible. Another major issue is that if I want to reference those 20 x 6 columns in another table, I have to re-create those columns. Is there a work around ? If I can speak programatically, I want to pass an organ name and the value I need (top / bottom / left / right / front / back) , I should get the right column value. This might be helpful in some cases. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 20, 2023, 2:42am UTC](https://community.glideapps.com/t/multiple-similar-operations-for-a-row-in-a-table/62944/4 "2023-06-20T02:42:50Z")
> [@Prasanth\_Thoppe](#): > > I need to store the data of patients in a single row and I find the best way to make modifications easier. You should carefully check Glides [Terms of Use](https://www.glideapps.com/legal/terms), and in particular the restrictions on [User Data](https://www.glideapps.com/legal/user-data). From the above: ![CleanShot 2023-06-20 at 10.40.54](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/1/115acaf5a7cc1e28c938714e970ed97a5728a4ac.png) ---
**Author:** ![Prasanth\_Thoppe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prasanth_thoppe/32/57244_2.png) [@Prasanth\_Thoppe](https://community.glideapps.com/u/Prasanth_Thoppe)\ **Post date:** [June 20, 2023, 2:56am UTC](https://community.glideapps.com/t/multiple-similar-operations-for-a-row-in-a-table/62944/5 "2023-06-20T02:56:22Z")
Thank you. I just gave an example whereas what I’m working on is totally different and doesn’t fall under HIPAA. But thanks for letting me know as I didn’t know about this earlier. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 20, 2023, 11:11pm UTC](https://community.glideapps.com/t/multiple-similar-operations-for-a-row-in-a-table/62944/6 "2023-06-20T23:11:37Z")
> [@Prasanth\_Thoppe](#): > > If one of the values of the meta data is updated, then it should be visible. I’m still not entirely sure if it works, but maybe you can try putting each group’s data into a container and set the visibility conditions on the container level? > [@Prasanth\_Thoppe](#): > > Another major issue is that if I want to reference those 20 x 6 columns in another table, I have to re-create those columns. Is there a work around ? May we know why you need to have another table here? ---
**Author:** ![Prasanth\_Thoppe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prasanth_thoppe/32/57244_2.png) [@Prasanth\_Thoppe](https://community.glideapps.com/u/Prasanth_Thoppe)\ **Post date:** [June 21, 2023, 12:52pm UTC](https://community.glideapps.com/t/multiple-similar-operations-for-a-row-in-a-table/62944/7 "2023-06-21T12:52:05Z")
> [@ThinhDinh](#): > > a container and set the visibility conditions on the container level? Thats what I’m doing. even with that I have 20 containers for each ‘organ’ and have to do this in both add and edit screen just for visibility. Also 20 computed columns for each organ for visiblity all with almost similar logic. And I used another table (a temp table) in order to transpose the columns into rows for viewing purpose. But its uses up my update quota. Hence not the best solution. Exploring alternative ways. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 21, 2023, 11:36pm UTC](https://community.glideapps.com/t/multiple-similar-operations-for-a-row-in-a-table/62944/9 "2023-06-21T23:36:29Z")
Without knowing a lot about the specific structure of your db I may not be able to help more. Why do you need to have 20 containers for each organ though? Wouldn’t it be 1 per each organ, and 20 in total since you mentioned 20 organs? ---
**Author:** ![Prasanth\_Thoppe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/prasanth_thoppe/32/57244_2.png) [@Prasanth\_Thoppe](https://community.glideapps.com/u/Prasanth_Thoppe)\ **Post date:** [June 22, 2023, 2:41am UTC](https://community.glideapps.com/t/multiple-similar-operations-for-a-row-in-a-table/62944/10 "2023-06-22T02:41:01Z")
It is actually 20 containers - 1 container / organ. Don’t worry about it for now as it is getting too technical. But thank you for trying . Appreciate it.