Hello,
I am trying to display a count of each zone checked-in/not checked-in in a group but whatever I tried it gives the same count for both zones.
I want to display the check-in count and not checked-in count of each zone in my live dashboard.
And I tried filtering the zone to do checked-in and not checked-in count but even though no one is assigned to that zone, it will shows the same count as the other zone.
I have attached some screenshots to kind of help what I need.
Just to keep in mind, I have 3 things connected to each other here:
-
Tickets (where the check-in-at time is set)
-
Event
-
Zones
Each ticket has their own event where the user registered for and each event has their own zones.
Could be privacy rules issue where data is private and not being returned from database based on user signed in during testing.
Could be there are the same amount of items in the database.
Have you ran the same filters inside the app database from editor?
Have you used the inspector tool on preview page to check the values there?
on the privacy rules, I kept the privacy rules to be find in searches and view all.
I used the check-in data in 2 other pages but this time Im trying to display the check-in count of each zone.
so the data that I want it to be taken from is Ticket, Event, Zones.
the ticket has the check-in time. so I want it to display how many people have checked-in in that particular zone.
Have you used the same filters in database inside editor to verify data exists?
Have you used the inspector element from preview page to see how search expressions are being returned?
I used the almost the same filters but the issue I have is that I cant connect the zone to the ticket. or vice versa.
I am getting the count of all tickets checked-in time and not that specific zone.
Oh, you need an additional filter for the zone…your search filters just show two, one for is checked in and one for is not checked out. You need a 3rd filter for zone equals groups zone…but you need tickets to have zone field and parent group to have a zone as data source.
so in the tickets I need to add a zone field? in order to display them by zone.
Yes, because, in order to count how many tickets are in a zone, you need to know what zone a ticket is for. To know what zone a ticket is for, you need a field that is the zone.
I added zone to tickets and tickets to zone. but when I assign a user to a zone the data doesnt get updated.
so technically when I assign a user, it should update the zones field in tickets and tickets field in zones.
But I can’t quiet get them to make changes to that thing.
Anyway you think I could update it?
Relating data properly can be confusing.
You typically do not need each ticket to have a zone AND each zone to have list of tickets. One or other is fine, and choice between a one to one relationship (each ticket has a zone) or one to many relationship (each zone has list of tickets) can come down to several factors, but often simplest is one to one.
Also knowing which data is updated when we make changes to one data type is not always intuitive.. When you relate a user to a zone that doesn’t have anything to do with tickets and zones, unless you already have a list of tickets related to user or a user related to ticket AND run necessary workflows to update the tickets and zones when done updating users and tickets.
Best approach for your needs is add a zone to a ticket.Then search tickets with a filter for zone.
So these are the fields I currently have connected.
User:
~ Events Registered (List of Events)
~ Tickets (List of Tickets)
Events:
~ Ticket (List Of Tickets) [tickets of who are registered for the event]
~ Event Zones (List Of Zones) [list of zones for the event]
Zones:
~ Tickets (List Of Tickets)
~ User (List Of Users) [users assigned to a particular zone]
~ Event [the event the zone is for]
Tickets:
~ User
~ Zone
~ Event
Each user is only assigned to 1 zone in each event. That’s why the ticket wont be list of users.
So right now in my admin page, I have an assignment and de-assignment of users to a zone. The first issue I had was fixed when you told me to have another field created. But now, when I assign a user to a zone, im having issues updating the ticket and the zone so it fills the data for it to be displayed in my event live dashboard.
So I most probably think this is a workflow issue or im doing something wrong honestly 
You are over relating data to each other, and likely not thinking through exactly how the data needs to be created/modified and how it will be view/searched.
If you want to search for all users who are part of an event in a particular zone, no data needs to be on user, on event or zone, only on tickets.
Can search tickets and if it has a field for event, can find all tickets for that event. If ticket has field for zone, can find all tickets for a zone. If ticket has a user can find all tickets for a specific user. One to one relationships are easiest to start with an do not need to have full understanding of data structuring and all the if/and/or for why to use a one to many relationship or not.
If you want to assign a user to a zone or remove them from a zone, you should just assign a user to a ticket for the zone, because zones can only in reality have so many tickets per zone, but if you think in terms of users per zone, you are having to also update tickets, so just update tickets and at same time update the zone and user and event if need be.
Correct setup is a ticket has zone, event and user fields. No need for list of tickets on user, no need for list of tickets for zone and no need to have list of tickets for event.
the ticket has all 3. Event, User and Zone.
The data is displaying properly on the page, but I cant get the workflow to add the list of the multi-dropdown users (which is the list of users getting assigned to the zone) ticket to the zone. and since I have a field now for the zone in tickets I also want to add zone to tickets.
If you dont get me, I could share the editor link with you so you can check 
Doing what you are doing would over complicate it. You only need one ticket a field for a single user.
Do you plan on only letting an admin create tickets or will this be like a real ticket booking system where a single user will buy a ticket?
no only real ticket booking and only I can create a ticket from the database in the editor.
Are you saying ‘not real ticket booking and only you will create tickets from inside the editor’?
If it was a real ticket booking you’d create the ticket at time of booking and assign the user booking ticket at that time, and likely set zone based on user choice at time of booking.
No, IT IS a somewhat a booking system.
Just to give you a general idea of the website.
The website is for Volunteers. So each volunteer signups and makes an account. When a event is active and they register, the ticket gets created and it gets added to the user’s list of tickets and vice versa (user added to tickets).
The tickets will have the Check-In/Check-Out time. I have added a ZONE (singular data/zone), each volunteer is assigned to ONE zone only.
And when i create the zone in my admin page, the zone gets added to the event (list of zones).
What i am trying to pull in my live event dashboard is COUNT of checked-in and COUNT of not checked-in (that issue is cleared and displays correct)
The issue im having is that when i assign the volunteer to the zone. The zone doesnt get added to the ticket and vice versa (the ticket doesnt get added to the zone).
I would make a decision, do you want to assign a volunteer to zone after or before they have ticket.
For me, the answer is assign the ticket a user and zone when ticket is issued. Otherwise you overcomplicate data structure and need for making changes to 3 different sets of data instead of one, so my advice remains consistent throughout the entire thread.
