Display one to many records in concat style
Application Type

Hi i have the above data which show the type of services each room will have 

Instead of displaying multiple line , can i display the above in the following format

101   1  0  $34   HairDryer, TV


Hi Teo,

For the mentioned use case, I suggest defining a separate block that takes an input parameter, i.e. RoomId. Then, based on the RoomId value, fetch all the RoomAmenities and using String_Join server action join all the room amenities with ',' (comma) delimiter.

See this demo screen: Rooms

Refer to the attached .oml file.

I hope this helps you!

Kind regards,

Benjith Sam


Thank you for your help, i will go through and get back to you if i face any issue

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.