Hi All
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 ?
Thank you
Yes, the approach to do is to use a Reference Action. It allows you to identify a set of rows (in this case, your set of rows is of size 1) and to invoke an action on that set of rows (in this case, to un-waitlist that reservation)
Hi @praveen
Thanks for the guidance. For my understanding, Reference Action means “Data:execute an action on a set of rows” in Behavior?
I have used this and added the following as the Referenced Rows.
MINROW(“RESERVATIONS”, “WAIT”,([STATUS]=“Wait Confirmed”))
This is giving me an error "
“The expression is valid but its result type ‘Ref’ is not one of the expected types: List”
Any ideas ?
Thank you
J
MINROW() returns a single Ref value, but Referenced rows expects a list of Ref values. Wrap MINROW() with LIST():
LIST(MINROW(“RESERVATIONS”, “WAIT”,([STATUS]=“Wait Confirmed”)))
See also:
User | Count |
---|---|
40 | |
36 | |
32 | |
23 | |
16 |