Validating drop down
I am working on creating a self-service provisioning portal, so our server admin's can generate new VM requets. for the CPU and RAM input, I started out using an array of "Predefined answers", with a default value.
Watch the steps in this short video, and the written instructions are below the video Instead of referring to a list of items on the worksheet, you can type the list in the Source box, separated by commas.If it is, prompt the user to make a selection, otherwise use the form's submit() method to submit the form.Limit the choices in an Excel drop down list, depending on the value in another cell.This worked great, except the user could choose "Select..." or "-------" as an option in the drop down, and the workflow would break.What is the best way to validate for that in the webview?I hope after reading this article you will be able to use this trick in your code.
I would like to have feedback from my blog readers.
At the moment users can select that option and gain access to the next page, what I want to do is if 'Please Select One' is selected ensure that access to the next page/step will not be given until an actual option on the drop down list is selected.
Im guessing some sort of If statement but im unsure of how to do this. This is my code for my ddl If you are adding code to your questions, please take a minute to format it, you have a preview of what it looks like just under the question text.
It is tricky and avoids the use of Java Script function to validate List Box and Drop Down List. For validating Drop Down List, make sure you have "--Select--" option value 0 other wise validation on it will not work.
In this article I try to explain how to validate Drop Down List and List Box using Required Field Validator.
Another option is to use a macro, to clear the dependent cell, after making a selecting in the first drop down. In this example, column B contains a drop down list of Regions.