Notification body not showing

[fedeyobe]

Hello, i'm experiencing this problem:

In my workflow, when two conditions are met, a notification is sent. This part works perfectly. But the problem is that in the body of the notification, when it's sent, it just shows the first of three values, like this:

Room: <<any(Select(lugar_reservado[lugar_reservado_base];[id_lugar_reservado]=[_thisrow].[lugar_reservado]))>>.

Travel Agency: <<select(agencias_viaje[nombre_agencia];[origen_reserva]=[_thisrow].[id_agencia])>>.

Guest: <<any(Select(huespedes[huesped];[id_huesped]=[_thisrow].[huesped]))>>.⠀

It only shows the room. The other two expressions are fine, i've tested them on a test column. I have tried to do this with other values but it just won´t work. What i'm missing here?

Regards,

Federico.

[Joseph_Seddik]

Please show the columns of the table on which you are running this bot.

[fedeyobe]

Hello Joseph, thanks for your answer. Here is a picture of all the columns of the table, they are side by side because i cant fit them all in a vertical picture.

Thanks again for taking your time to help me.

Regards,

Federico.

[fedeyobe]

I've just corrected the one for "travel agency". Now this one is working, the formula was wrong.

This is the right one:

Travel Agency: <<any(select(agencias_viaje[nombre_agencia];[id_agencia]=[_thisrow].[origen_reserva]))>>.

But i can't figure it out for the Guest one. Maybe it doesn't work because it's an "Ref" type column?