I have a dillemma, I am trying to validate dropdown fields in the update template on the right.
I understand that masks cannot be applied to dropdown fields, so how can I validate that they are entered since they only appear in the update template and not in the grid, all the information that is pertinent to the user in in blue on the left, some of the information that they have to capture is for statistical reporting and is not of importance to the every day user, hence it is not displayed in the grid.
Those fields are mandatory and I cannot use a default, if they dont select one.
For other mandatory fields that are also dropdowns, I have used magiccells, but to display the error you have to include those fields in the grid, which is very restrictive if you don't need to show that data, and also a magiccell validates after the update, which defeats the purpose of validating input data before it is posted.
In my opinion we need to be able to validate dropdown fields before the update takes places, for my purpose, a dropdown fields eliminates the need for the user to type long descriptions, and I should still have the ability to validate that they did select one since I cannot default to one.
I need to keep statistics on 6 different grants, and I cannot default to any one of them.
We cannot assume that every dropdown field will have a default and if they dont select one, we can default to one.
Hope you can help on this.
PS I've attached a screen print (zip PDF) to give you an idea of what I mean.
Reply With Quote