Filtering Reference choices in dropdown lists : show only what is left

Ask for Help
1

Hi,

I have implemented the filtered dropdown list as described in :

I wanted to know if there would be a possible formula so that the dropdown list does not show options that have already been selected.

So for example if the column is empty, the dropdown shows options A, B, C.

If on a row I already have A, then the dropdown list would only show B and C.

If all options already exist, then the dropdown list is empty.

Would that be possible ?

2 Likes
2

This should be possible using a separate formula column that simply mirrors the current value of your reference column. Set up a new column, let’s call it ‘YourDummyColumn’ (you can simply leave its type set to ‘Any’), and put this formula:

return $YourReferenceColumn

Then in your reference column, provide the following formula as dropdown condition:

choice.id not in $YourDummyColumn

Does this help?

1 Like