# How do I add multiple items **URL:** \ **Category:** Ask for Help\ **Created:** [August 26, 2021, 4:47am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-items/30970 "2021-08-26T04:47:23Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Peter\_Sloan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_sloan/32/29254_2.png) [@Peter\_Sloan](https://community.glideapps.com/u/Peter_Sloan)\ **Post date:** [August 26, 2021, 4:47am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-items/30970/1 "2021-08-26T04:47:23Z")
On my form for a client I have the following ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/b/7b00df61e04321230b32d84d07dcf77f5fb907d2.png) and the values for the inline list comes from a relation column ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/1026d98294f2e6b99ed9bbe03d8fbd28e54a6abd.png) and I have School 1 and School 2 in the spreadsheet as shown below ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d576ef3e769f4e970cd8f77aa4f215f3840f7d7a.png) For the Add School button I have ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/c/ac0f815d4860492988159df4984dea1df41c8278.png) The problem is that when I click the Add button I get ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/d/0d4408e97391df80f607b86c91bbca727dad2941.png) What I want to do is select a school from a table and add it into my client. Any ideas what I am doing wrong or what do I need to do to make it work? ---
**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:** [August 26, 2021, 4:56am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-items/30970/2 "2021-08-26T04:56:54Z")
Is the number of schools fixed, or could you have many? Either way, if you want to present a list of schools to select from, you would need have them arranged in a single column and then use a choice component. So I would suggest a separate “Schools” sheet with a column for the school name, and then one row per school. ---
**Author:** ![Peter\_Sloan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_sloan/32/29254_2.png) [@Peter\_Sloan](https://community.glideapps.com/u/Peter_Sloan)\ **Post date:** [August 27, 2021, 2:47am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-items/30970/3 "2021-08-27T02:47:57Z")
Thanks for the reply. I can have multiple of schools. I already have the schools on a separate sheet. What I want to know how do I add items in the relationship column i.e GUI? ---
**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:** [August 27, 2021, 3:17am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-items/30970/4 "2021-08-27T03:17:46Z")
There are a few ways to do this. The easiest way would be to create a 3rd table to setup a many to many relationship between Clients and Schools. This table would have one column for ClientID and one for SchoolID, and one row for each Client/School combination. When a client selects a School from your choice component, you would need a Submit button with an action that add a row to that table with the SchoolID and ClientID. You can then create a multi-relation between your Clients and Clients-Schools table joining the ClientID in each. The downside with this method is that it can use a lot of rows if you have many clients and/or schools. Another option is to use a technique referred to as the trebuchet method to create a column containing a joined list of ClientID’s in your Schools table. This option requires much less rows, but is a lot more difficult to implement. ---
**Author:** ![Peter\_Sloan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_sloan/32/29254_2.png) [@Peter\_Sloan](https://community.glideapps.com/u/Peter_Sloan)\ **Post date:** [September 18, 2021, 12:33am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-items/30970/5 "2021-09-18T00:33:05Z")
So how do I add and delete vales into the data array columns? ---
**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:** [September 18, 2021, 12:55am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-items/30970/6 "2021-09-18T00:55:43Z")
Are you using the new Sheet method or the Trebuchet method? ---
**Author:** ![Peter\_Sloan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_sloan/32/29254_2.png) [@Peter\_Sloan](https://community.glideapps.com/u/Peter_Sloan)\ **Post date:** [September 18, 2021, 1:13am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-items/30970/7 "2021-09-18T01:13:10Z")
I’m using google sheets. ---
**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:** [September 18, 2021, 1:30am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-items/30970/8 "2021-09-18T01:30:55Z")
Then you can add new values to the array by using the form to populate that new Sheet, and remove by deleting rows from that same Sheet.