Conditional Field Type based on user?

For some users I need an Enum to limit to one selection. For others I need an EnumList to allow multi-selects. Based on the same data column.

Is there a way to do this?

1 Like

Not sure if this helps, but here’s one I did this week where you can have “Customer” on its own, or any number & combination of the others

OR(
	AND(
		IN("Customer",[Type]),
		COUNT([Type])=1
	),	
	NOT(IN("Customer",[Type]))
)
3 Likes

On rereading the requirement, I think @1minManager ’ suggestion is in the correct direction. I had slightly misunderstood the requirement so I deleted my suggestion. I think the requirement is to restrict to “any one” selection in the enumlist. I probably misread the restriction to “one specific value”.

2 Likes

Pattern for Valid If:

IF(
  user-allowed-many-choices?,
  LIST(...multiple-items...),
  LIST(one-item)
)

Example:

IF(
  IN("Privileged", Current_User[Type]),
  LIST("Good", "Great!", "Amazing!"),
  LIST("Good")
)
2 Likes