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 |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |