I want to filter "Flat/Unit" dropdown column ...

[Swapna_Nirman_W]

I want to filter “Flat/Unit” dropdown column based on the “Status” of payment. So the drop down should only display “Flat/Unit” whose “Status” is “DUE” .I used SELECT expression for this which is working fine for new additions.

However, when I try to update a record, it says invalid entry as the

"Flat/Unit"s status for this specific column is changed to

“Clear” while addition.

Is there any way around it?

[Aleksi_Alkio]

You can use for example SELECT(…)+{CONCATENATE([_THIS])} in Valid_If

[Swapna_Nirman_W]

Worked like a charm. Thanks @Aleksi_Alkio