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
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
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.
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
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.
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”.
how can i make glide enter the form into rows instead of columns?
the top 3 are my information sheets. the rest are capture/helper sheets for my forms
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.
1 Like
