Referenced Enum List

I need to make an Enum list from values in a shift table.
In Valid If I select the values of the shift table:
SELECT (Shifts [Shift ID], true)
In the Shift table, the name of the Shift is the Label (morning shift, afternoon shift…)
But on the buttons I get the Id
How do I save the list of Id’s selected in the EnumList, but show the Label in the buttons?
If instead of Select [Shift ID], I select [Shift], it shows it well, but it gives a reference error.

0 1 1,729
1 REPLY 1

Steve
Platinum 4
Platinum 4

Unfortunately, there’s (currently) no way to choose the table to which Ref columns refer, so we have to guide the app editor toward the right choice. Try changing the column type away from EnumList, then back to EnumList. This should reset the EnumList settings and allow the editor to rediscover the Ref. Make sure your Valid If expression is in place before you then save your changes.

Top Labels in this Space