Option to add new items to enum list

Thanks to all who take the time to help.

I have a table PROBLEM with a variable ACTION that is set as an ENUM/REF looking up to a table ACTIONS and is filtered based on the relevant SYSTEM.

Includes Valid If:  "FILTER( ACTIONS , IN( [_THISROW].[System] ,[ACTIONSYSTEM] ) )"

Thanks to guidance from @Marc_Dillon this is working wonderfully - allowing only those values in the ACTIONS table that correspond to the selected SYSTEM. 

However, I have lost the ability to add to the list of actions, when selecting if the action isn't already in the ACTIONS table. "Allow other values" is checked.

Question: Is there a way to gain back the capacity to add other values?

Examples of current working - missing any option to add alternate actions:

Options with system Air ConditioningOptions with system Air Conditioning      Options with system FurnaceOptions with system Furnace

Solved Solved
0 1 604
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

There is no built-in way to allow the user to add arbitrary values when using button input styles. You would have to switch to the drop-down input style, or devise your own method.

View solution in original post

1 REPLY 1

Steve
Platinum 4
Platinum 4

There is no built-in way to allow the user to add arbitrary values when using button input styles. You would have to switch to the drop-down input style, or devise your own method.

Top Labels in this Space