# Need help to populate a list into a table **URL:** \ **Category:** Ask for Help\ **Created:** [May 31, 2024, 11:27am UTC](https://community.glideapps.com/t/need-help-to-populate-a-list-into-a-table/73775 "2024-05-31T11:27:56Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Teejay\_Oyeniran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teejay_oyeniran/32/61251_2.png) [@Teejay\_Oyeniran](https://community.glideapps.com/u/Teejay_Oyeniran)\ **Post date:** [May 31, 2024, 11:27am UTC](https://community.glideapps.com/t/need-help-to-populate-a-list-into-a-table/73775/1 "2024-05-31T11:27:57Z")
l have a field that have Project Plan — for example Electrical Plan, Mechanical Plan, Plumbing Plan, Structural Plan(Check the first image). l want it to populate on a collection(on a table). (Check the second image) How can l do that?? ![VG2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c3a0c03879dbcfd6a740eeb099f456d2bec29d61.png) ![VG3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/de0232e55b53863288e77740dc67ddc7104632cf.png) ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [May 31, 2024, 2:21pm UTC](https://community.glideapps.com/t/need-help-to-populate-a-list-into-a-table/73775/2 "2024-05-31T14:21:50Z")
You’ll need to create a helper table with the maximum number of rows that could be displayed. Add a numbered index column to the helper table Split the projects with a split text column Copy the split text projects with a single value column into the helper table Add another single value column, target the copy split text, it should be from start and the row is your index column ---
**Author:** ![Teejay\_Oyeniran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teejay_oyeniran/32/61251_2.png) [@Teejay\_Oyeniran](https://community.glideapps.com/u/Teejay_Oyeniran)\ **Post date:** [May 31, 2024, 2:28pm UTC](https://community.glideapps.com/t/need-help-to-populate-a-list-into-a-table/73775/3 "2024-05-31T14:28:09Z")
Thank you very much… In this scenario, if project plan were added and submitted…can we create a series of rows on another table with each value selected?? ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [May 31, 2024, 2:34pm UTC](https://community.glideapps.com/t/need-help-to-populate-a-list-into-a-table/73775/4 "2024-05-31T14:34:23Z")
Do you have an example of what should happen? I think this is what you want. > [@fishbaguette\_breadbasket Transpose Columns to an Inline List: The Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766): > > I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [[Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD] ](https://www.youtube.com/watch?v=t-sh_Q3WbQc) ---
**Author:** ![Teejay\_Oyeniran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teejay_oyeniran/32/61251_2.png) [@Teejay\_Oyeniran](https://community.glideapps.com/u/Teejay_Oyeniran)\ **Post date:** [May 31, 2024, 3:10pm UTC](https://community.glideapps.com/t/need-help-to-populate-a-list-into-a-table/73775/5 "2024-05-31T15:10:02Z")
Here’s an example of what l want: whenever l fill a form(say a Quote), it saved in the Project-Created table. l need the Project Plan(list of values to display in a series of consecutive rows in another table(like Project - Tasks) like foundation Plan in a separate row the next value “Section Plan” ![VG4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/b/4b5b8ab119cfbfbd88de9a27e93a9452c4e3a5a5.png). l tried to edit the submit action and set the values “Project Plan” in the Project - Tasks. ![VG5](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/a/5a5e9831fef020e158c737641df6a5b77af2da3f.png) lt didn’t work as expected. l will check out the video tutorial you attached. ---
**Author:** ![Teejay\_Oyeniran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teejay_oyeniran/32/61251_2.png) [@Teejay\_Oyeniran](https://community.glideapps.com/u/Teejay_Oyeniran)\ **Post date:** [May 31, 2024, 6:55pm UTC](https://community.glideapps.com/t/need-help-to-populate-a-list-into-a-table/73775/6 "2024-05-31T18:55:35Z")
l have tried to follow up the video tutorial, unfortunately it didn’t work out as expected … l’m surprised Single Value Column doesn’t work on(text) precisely list of text. @Robert_Petitto @ThinhDinh @Darren_Murphy @Jeff_Hager. Please help me out with this request. ---
**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 1, 2024, 12:20am UTC](https://community.glideapps.com/t/need-help-to-populate-a-list-into-a-table/73775/7 "2024-06-01T00:20:58Z")
I don’t have anything to add. @Eric_Penn 's suggestion and Robert’s video should be the way to do it. If you can show us in more screenshots or a video on how you’re setting it up, we might have more context to help. ---
**Author:** ![Teejay\_Oyeniran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/teejay_oyeniran/32/61251_2.png) [@Teejay\_Oyeniran](https://community.glideapps.com/u/Teejay_Oyeniran)\ **Post date:** [June 1, 2024, 8:02am UTC](https://community.glideapps.com/t/need-help-to-populate-a-list-into-a-table/73775/8 "2024-06-01T08:02:22Z")
I made a video here showing and explain how things were set up https://www.loom.com/embed/ecbd1d43e1b64b9ca54fd602e94e5f75?sid=899a4166-4652-47ef-92d4-86cc88549c9d ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [June 1, 2024, 10:43am UTC](https://community.glideapps.com/t/need-help-to-populate-a-list-into-a-table/73775/9 "2024-06-01T10:43:48Z")
The error with your single value column is because you are not directly taking it from the array column, but instead from the sheet again. Additionally, the array/row index always starts from 0 for the first row. I am still confused about how you work. Perhaps below there is a video reference that I think is interesting for starting a new task that you can learn. Please take a look. [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/a/daee86fcd0e13c4034c789717186e37ef6ec21aa.jpeg "🎓 Glide Tutorial - Add, Edit or Delete Multiple Rows (Glide API)") ](https://www.youtube.com/watch?v=b7_k3_brusQ)