I am searching for a new simpler work around for below problem. kindly suggest solution .
I need to Avoid Dropdown in Ref column in child table and show an error if the data is not available
My Expectation
I am searching for a new simpler work around for below problem. kindly suggest solution .
I need to Avoid Dropdown in Ref column in child table and show an error if the data is not available
My Expectation
Dropdown:
SELECT(...)
No dropdown:
AND(TRUE, IN([_THIS], SELECT(...)))
Both Cases are same.
Do you have a Suggested values expression?
no @Steve
Unfortunately, I do not think you can hide the dropdown of a REF column on a Form View. In fact if there were NO VALUES to choose from, the field is actually hidden by default in a Form view - ar at least it used to be - becasue it would bascially be useless. It is part of the built-in functionality. I tried based on your other post and I couldn’t make it happen.
What was wrong with the approach you had of a person entering the PINCODE into TEXT column? You can validate that text entry against the PINCODES in the database. Then use a hidden VC to treat it as a REF, if needed!!
@Steve @AleksiAlkio , do you have any work around ?.
So you would like to show the dropdown if the value exits, but the error message if it doesn’t? Is this your goal?
Or do you want that the dropdown is not shown at all? It just makes the validation and if it is false, show the error message.