Okay, I feel like I’m missing something.
Would you mind showing me screenshots of the tables involved please?
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?
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?
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.
2 Likes
Thanks a lot Darren!!!
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.
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…
1 Like
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?
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.
1 Like
Okay Darren, thank you for your help, it was very useful to me, and also to all the users who participated!!
1 Like
ROLE: Staff
Here we see the events to which they were invited (Event Request) (already done).
Here are the events for the staff that were accepted only. How could I implement this?
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.”
And finally, here we see the list of staff (according to those who accept the event) of the Event Host role.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.