Remove option in dropdown list

[Phong_Lam1]

Hi all, how can I remove the option in the dropdown list in [department] ? In this case I want to remove “operation”, I used this expression for this column

But in the config HRM [department] does not have “operation” option to remove, Thanks

[Kirk_Masden]

I’m not sure that I understand your question properly but you should be able to subtract a list made up of the word “operation” as a list. If “operation” is not in “config HRM[department]” I don’t think that would be a problem:

sort(config HRM[department])-list("")-list("operation")

P.S. Do you want to subtract “operation” or “operations”?

[Phong_Lam1]

Thanks @Kirk_Masden, I tried but It’s not working

sort(config HRM[department])-list("")-list(“operation”)-list(“Innovation”)

It’s still show as below

[Aurelien]

Hi @Phong_Lam

You may want to set this expression in the Valid_If expression instead of Suggested_Value.

From my point of view (but not tested), if “Innovation” has been entered previously, it will be suggested even if you remove it from the Suggested_Value list.
Also, set a capital first letter for -LIST("Operation") ?

One strange thing I notice, is that you use the SORT() expression, but… the list is not sorted on your screenshot

[Phong_Lam1]

Aurelien:

One strange thing I notice, is that you use the SORT() expression, but… the list is not sorted on your screenshot

I guess It just sort value form the [Department] column, the others value that user entered previously not sorted.

When I put it in Valid_If column, It’s working but It not allowed user to add additional department

How can we allow user to add new value ?

[Aurelien]

Phong_Lam:

How can we allow user to add new value ?

You may want to use a new table “Departments”.
And set the current column with type Ref, source table “Departments”.
This way, people will see a “New” choice that will allow them to add a new department in this table.

[Phong_Lam1]

Thanks @Aurelien