I have a table that contains a list of reservations. Once the maximum number of reservations for an activity is reached, any new reservations for the same activity go into a waitlisted status.
I would like to be able to change the first waitlisted reservation every time a cancellation takes place.
I have tried by using Actions and Bots and don’t see an option where I can use MINROW() to achieve this.
Any ideas ?