# How to assign users in a event **URL:** \ **Category:** Ask for Help\ **Created:** [June 25, 2024, 3:11am UTC](https://community.glideapps.com/t/how-to-assign-users-in-a-event/74356 "2024-06-25T03:11:48Z")\ **Posts on this page:** 12\ **Page:** 2
**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 26, 2024, 5:12am UTC](https://community.glideapps.com/t/how-to-assign-users-in-a-event/74356/22 "2024-06-26T05:12:21Z")
Okay, I feel like I’m missing something. Would you mind showing me screenshots of the tables involved please? ---
**Author:** ![polsze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/polsze/32/70146_2.png) [@polsze](https://community.glideapps.com/u/polsze)\ **Post date:** [June 26, 2024, 5:17am UTC](https://community.glideapps.com/t/how-to-assign-users-in-a-event/74356/23 "2024-06-26T05:17:19Z")
![xd](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/18c858c9b279820a3d7add1cd377f5a0c8b7e55c.png) ![xd2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/f/2f9f66124e4680be29d872a1b5cf603b7b56d107.png) ![xd3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/f/8f51587d8c7e91d639a8e29daf392563ddbd5fcd.png) ---
**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 26, 2024, 5:29am UTC](https://community.glideapps.com/t/how-to-assign-users-in-a-event/74356/24 "2024-06-26T05:29:52Z")
What is the relationship between a Ticket and an Event? I would expect to see something like an EventID column in the Tickets table, but I don’t see that. In other words, how do you know which Tickets belong to which Event? Is it purely based on EventTitle? ---
**Author:** ![polsze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/polsze/32/70146_2.png) [@polsze](https://community.glideapps.com/u/polsze)\ **Post date:** [June 26, 2024, 5:32am UTC](https://community.glideapps.com/t/how-to-assign-users-in-a-event/74356/25 "2024-06-26T05:32:28Z")
I had created a relationship between the event ID and the ticket ID, but it didn’t display anything. How could I set up this relationship, or what should I do to relate them? ---
**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 26, 2024, 5:46am UTC](https://community.glideapps.com/t/how-to-assign-users-in-a-event/74356/26 "2024-06-26T05:46:36Z")
I would recommend adding an EventID column to your Tickets table. Then every time you create a Ticket, store the EventID of the associated Event in that column. You can then use that as a filter on a Collection to filter Tickets for the signed in user in the same way that you filter Events. If you need the name of the Event in the Tickets table, create a single relation in the Tickets table that matches the EventID with the same value in the Events table, then use a Lookup column to fetch the Event Name via that relation. This is a more robust approach than storing the Event name directly in the Tickets table, because if you have more than one Event with the same name (or if you change the name of an Event), nothing will break. ---
**Author:** ![polsze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/polsze/32/70146_2.png) [@polsze](https://community.glideapps.com/u/polsze)\ **Post date:** [June 26, 2024, 7:21am UTC](https://community.glideapps.com/t/how-to-assign-users-in-a-event/74356/27 "2024-06-26T07:21:04Z")
Thanks a lot Darren!!! ![dasda](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/f/2fa17f74cbb655a23023cf4edacac12f2e963bb6.png) Now I need to solve this. Could you give me some guidance on how to approach it? This is the last question and I won’t ask any more. ---
**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 26, 2024, 7:26am UTC](https://community.glideapps.com/t/how-to-assign-users-in-a-event/74356/28 "2024-06-26T07:26:17Z")
Are you asking how to calculate the numbers in the boxes? They should be just a combination of query columns and rollups. - Total Tickets Generated – Rollup-\>Count of the Tickets table - Total Tickets Used – A query into the Tickets table, filtering by used tickets (however that is determined) – Then a Rollup-\>Count via that query - etc… ---
**Author:** ![polsze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/polsze/32/70146_2.png) [@polsze](https://community.glideapps.com/u/polsze)\ **Post date:** [June 26, 2024, 8:09am UTC](https://community.glideapps.com/t/how-to-assign-users-in-a-event/74356/29 "2024-06-26T08:09:54Z")
I still need to solve this chart issue because, as you can see, the event categories are appearing, and the chart should be based on the used tickets. How could I do this? ![xDS](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6f76f47f31da9cb83779f90d50bfc757a6aa24ae.png) ![sds](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5f6cfcd51bc08d2cd59708be723358a544736e04.png) ---
**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 26, 2024, 8:16am UTC](https://community.glideapps.com/t/how-to-assign-users-in-a-event/74356/30 "2024-06-26T08:16:50Z")
Do you have a query for used tickets as I described earlier? It should be just a matter of using that query as the source of your chart. ---
**Author:** ![polsze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/polsze/32/70146_2.png) [@polsze](https://community.glideapps.com/u/polsze)\ **Post date:** [June 26, 2024, 8:22am UTC](https://community.glideapps.com/t/how-to-assign-users-in-a-event/74356/31 "2024-06-26T08:22:46Z")
Okay Darren, thank you for your help, it was very useful to me, and also to all the users who participated!! ---
**Author:** ![polsze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/polsze/32/70146_2.png) [@polsze](https://community.glideapps.com/u/polsze)\ **Post date:** [June 27, 2024, 4:14am UTC](https://community.glideapps.com/t/how-to-assign-users-in-a-event/74356/32 "2024-06-27T04:14:35Z")
ROLE: Staff Here we see the events to which they were invited (Event Request) (already done). ![eventrequest](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/7/7785d5d8442768d0cd6f803f979da74289919d9b.png) Here are the events for the staff that were accepted only. How could I implement this? ![myeventStaff](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/1/8143575cfbf80b9826c99f240450d72fe429f20a.png) ROLE: Event Host We see the view from the event host role, situated in an event assigning staff members. This is done, I just don’t know how to do the part of Invite pending, and that upon accepting (the staff user), instead of saying “Invite pending,” it says “Confirmed.” ![EVENTS](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/4/e425042d20deaa74e772e6456a4c797966cacd26.png) And finally, here we see the list of staff (according to those who accept the event) of the Event Host role. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ec39091ecc70a96bab89f41eba204bf185b147cc.png) ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [July 4, 2024, 4:15am UTC](https://community.glideapps.com/t/how-to-assign-users-in-a-event/74356/33 "2024-07-04T04:15:30Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed. [Previous page](https://community.glideapps.com/t/how-to-assign-users-in-a-event/74356.md?page=1)