Solved: How to get label from Ref type EnumList - Page 2

Gaius · 10-12-2021 02:07 PM

I have a table with an EnumList column of Ref type. I’m trying to populate a Show type column that shows the selected EnumList items as new-line delimited text. However, it only returns the Keys, not the Labels.

How can I get the labels for an enumlist? Thanks in advance.

Safe (Enumlist with base Ref type) column:

Safe Pretty (Show type) column:

Output:

Steve

Try:

SUBSTITUTE([Safe][label-column], " , ", "
")

Replace label-column with the name of the table’s label column.