Showing ref_rows as a column other than the ID

references
(Riki Armstrong) #1

I have 2 ref tables [client event] and [event detail], one [event detail] can have many [client events]. The automatic de-ref virtual column is as follows:
REF_ROWS(“CLIENT EVENT”, “EVENT DETAIL ID”)
This nicely shows a list of all related client IDs.
How do I get a similar list of all related client names?
I need it as a virtual column so that I can link this back to my calendar view to show all the clients attending that event on the calendar view.

(Aleksi Alkio) #2

You could write something like [Related Client Events][Client Name]

1 Like
(Riki Armstrong) #3

Wow thank you. Appsheet is very intuitive, I didn’t think it would be that simple.

(Aleksi Alkio) #4

You’re welcome