Hi, I have created a screen that shows two lists. List 1 is a list of people attending an event, and List 2 is a list of users waiting to get on the list 1 for a specific event.
As you can see the people going list is working but the people waiting list is empty. There are 7 users marked as going to the pool event, but the capacity is set to 6, so there should be one person on the waiting list.
Waiting List 2 setup
I also want users added to the waiting list automatically when the capacity for a specific event is reached. Then if a user is removed from the attending list they will automatically be replaced by the first user on the waiting list, (the list is sorted oldest-newest.)
I am now officially stuck and any help gratefully received.