Filter EnumList items

Hello, community,

I am trying to figure out how Show/Hide certain values from my EnumList.

It might be pretty straightforward but I wasn’t able to crack it for hours.

What I’m trying to get is:

When Credit Check = Pass… I want to see only “30%”, “70%” and “100%” buttons in [Issue invoice of:]

When Credit Check = Fail…I want to see only “30%”, “40%” and “100%” buttons in [Issue invoice of:]

When Credit Check = N/A…Only “FOC” button should appear

Thank you all for your help

In the valid_if of the [Issue Invoice of] enumlist column, please add an expression something like

SWITCH([Credit Check],

“Pass”, LIST( “30%” , “70%” , “100%”),

“Fail”, LIST(“30%” , “40%” , “100%”),

“N/A” , LIST(“FOC”),

LIST(“”)

)

Please remove any manually entered values in the enumlist column settings

2 Likes

Thank you so much!

This is exactly what I was looking for! You saved my day!

1 Like