Ref vs Enum while using "Other" value

[Caden_Davis]

Hello!

I need some help with determining which Column Type/configuration to use in the case below:

I have a column/form field that looks into a read only reference data source for a list of IDs, Names, and group IDs.

I am filtering the records by the group IDs based on a previous selection in the form. (It shows the user the label of the record (Name) and saves the key (ID) in the column which is what I’m looking for)

I need the option to let the user select an “Other” value that doesn’t exist in the reference data.

Right now, I have the column type set to “Ref” and I’m using the “Suggested values” to do the filtering of the reference data.

I tried to change the column type to “Enum” and use the “Allow other values” feature, but it displays the key to the user instead of the label.