How do I change the ref'd rows from count to list in a table?

Not sure how to ask the question more precisely, but look at the image here: It is from the "ppl" table with related columns. "Related mentors" is auto-generated; "Virtual Mentors" is what I created. In "Virtual Mentors", the related items show up as a list (unlike "Related mentors" which has a count in each cell).

My problem is with "Virtual Courses2", which I created. It refuses to display as a list.  I checked all the settings, the respective column settings are identical in in the tables "courses" and "mentors".

So where is the control for how related columns are displayed (list vs count)?

Screen Shot 2022-10-27 at 4.30.15 PM.png

Solved Solved
0 2 134
  • UX
1 ACCEPTED SOLUTION

You can change the column definition to EnumList,  Base Type = Ref,  and reset the source table the same.  See the image for an example.

Note:  That making this kind of change so you can see the values in the column as a list will prevent this same list being viewed as an inline table in Detail Views and Forms!

 

Screen Shot 2022-10-27 at 6.06.13 PM.png

View solution in original post

2 REPLIES 2

You can change the column definition to EnumList,  Base Type = Ref,  and reset the source table the same.  See the image for an example.

Note:  That making this kind of change so you can see the values in the column as a list will prevent this same list being viewed as an inline table in Detail Views and Forms!

 

Screen Shot 2022-10-27 at 6.06.13 PM.png

Worked like a charm! No issue with inline display either, which was one of my concerns. Thank you so much!

Top Labels in this Space