# Adding rows from a Form **URL:** \ **Category:** Ask for Help\ **Created:** [December 28, 2024, 10:12am UTC](https://community.glideapps.com/t/adding-rows-from-a-form/78833 "2024-12-28T10:12:34Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Dibadawg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dibadawg/32/81767_2.png) [@Dibadawg](https://community.glideapps.com/u/Dibadawg)\ **Post date:** [December 28, 2024, 10:12am UTC](https://community.glideapps.com/t/adding-rows-from-a-form/78833/1 "2024-12-28T10:12:34Z")
HI guys, So i am trying to make an entry form for our dog show organization. I am trying to build a report that can be exported by our office staff whereby they could log into the portal and view all the dogs entered by all the entrants. Usually we have from around 50 - 200 dogs in the show. trying to work out a way that i can use glide to generate a report based on all the entries that have been received, I have created a helper sheet for use in with the form capture, but i would like to be able to generate a list of all the dogs name and identity number in 2 columns any suggestions ---
**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:** [December 28, 2024, 10:26am UTC](https://community.glideapps.com/t/adding-rows-from-a-form/78833/2 "2024-12-28T10:26:23Z")
I have some questions: - Do you need to be able to export the report, or just view it in the App? - Can you show me what your data table looks like? - Can you show me how you have configured your form? - Do you need to keep a history of entrants for past events? ---
**Author:** ![Dibadawg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dibadawg/32/81767_2.png) [@Dibadawg](https://community.glideapps.com/u/Dibadawg)\ **Post date:** [December 28, 2024, 10:39am UTC](https://community.glideapps.com/t/adding-rows-from-a-form/78833/3 "2024-12-28T10:39:54Z")
![Dogs example](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c90c9f88b0f8d54993cdeb8b3a17e3ecee5e3e96.jpeg) so this would be one of my main sheet that holds all my dogs information. it has around columns related to one specific dog, but i have only showing the relevant information ![Show entry](https://us1.discourse-cdn.com/flex002/uploads/glideapps/optimized/3X/1/c/1c99e09b889ffe4a1887010c83a85376031160d5_2_690x53.jpeg) this is 2 entries for 2 different shows from my helper form. i dont need to keep the history as this information needs to get processed on a seperate program in our office. in terms of history, once the event has passed, the information can be removed manually. ---
**Author:** ![Dibadawg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dibadawg/32/81767_2.png) [@Dibadawg](https://community.glideapps.com/u/Dibadawg)\ **Post date:** [December 28, 2024, 10:45am UTC](https://community.glideapps.com/t/adding-rows-from-a-form/78833/4 "2024-12-28T10:45:37Z")
the way the portal is set up, each owner can only see the dogs they own. the owner can enter their dogs from a drop down menu in the form and the helper sheet has a relation and lookup for the tattoo/microchip number. the helper sheet will collect the entry in 1 single row as soon above. it also collects the user who has submitted that form. in this case, we could have 20 people entering 4/5 dogs per row. i would like to generate a sheet whereby i could select the club “Pinetown” and show only the dogs linked to that show. but i would only want to see 2 columns, dog name and tattoo/microchip ---
**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:** [December 28, 2024, 11:07am UTC](https://community.glideapps.com/t/adding-rows-from-a-form/78833/5 "2024-12-28T11:07:08Z")
> [@Dibadawg](#): > > this is 2 entries for 2 different shows from my helper form. The one thing that jumps out at me here is that you have multiple columns storing basically the same information. eg. Dog 1, Dog 2, Dog 3, etc. Setting a table up in this way is almost always a bad idea and creates additional complexity. Especially if you have no way of knowing what the maximum number dogs per owner is. For example, what happens if you have an owner with 20 dogs? A much better approach would be to keep it to one row per dog. So that would be my first recommendation. > [@Dibadawg](#): > > i would like to generate a sheet whereby i could select the club “Pinetown” and show only the dogs linked to that show. but i would only want to see 2 columns, dog name and tattoo/microchip What I would do here is have a separate table for Clubs, and list each Club one per row. Then add a collection to a screen and set the source as your Clubs table. The default item click action will be to show a details screen for the selected Club. In this screen, add a second collection and set your event/helper table as the source (the one that lists all the entries). Apply a filter to that collection where “Club is Screen-\>Club”. ---
**Author:** ![Dibadawg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dibadawg/32/81767_2.png) [@Dibadawg](https://community.glideapps.com/u/Dibadawg)\ **Post date:** [December 28, 2024, 12:11pm UTC](https://community.glideapps.com/t/adding-rows-from-a-form/78833/6 "2024-12-28T12:11:23Z")
how can i make glide enter the form into rows instead of columns? ---
**Author:** ![Dibadawg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dibadawg/32/81767_2.png) [@Dibadawg](https://community.glideapps.com/u/Dibadawg)\ **Post date:** [December 28, 2024, 12:13pm UTC](https://community.glideapps.com/t/adding-rows-from-a-form/78833/7 "2024-12-28T12:13:39Z")
![Data sheets](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/4/5432ec47b7b91836099316dd26fe2787728c871b.jpeg) the top 3 are my information sheets. the rest are capture/helper sheets for my forms ![Clubs](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/4/d4df19597a14225591acc35611f6cc214495a4ee.jpeg) ---
**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:** [December 28, 2024, 12:18pm UTC](https://community.glideapps.com/t/adding-rows-from-a-form/78833/8 "2024-12-28T12:18:43Z")
> [@Dibadawg](#): > > how can i make glide enter the form into rows instead of columns? Not easily from within a single form. The simplest option would be to ask the user to submit the form once for each dog. You could set it up in such a way that they only need to enter the other information once, and then that gets used with each dog added, so it wouldn’t be overly cumbersome.