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?
You can use for example SELECT(…)+{CONCATENATE([_THIS])} in Valid_If
Worked like a charm. Thanks @Aleksi_Alkio
User | Count |
---|---|
39 | |
28 | |
24 | |
24 | |
13 |