Make null value an option in dropdown list user interface
Currently you have to use Java Script to create a dropdown list that includes an item with a null (blank) export value. There is not way to add a null value to the list in the Prepare Forms - Dropdown Properties user interface. You can create a list item that looks blank by using the space bar, but that is not the same as null and will generate an error when importing the data into our database (where true null is an acceptable entry, but any text entries that don't match the validation list are not, and the entire record will be rejected). Those of us who don't create a lot of forms need a way to add a null value item through the user interface instead of having to learn to use Java.
Anonymous
shared this idea
-
Robert Duggan commented
Agree 100% - cant use the whitespace for dropdown as it will allow submission - it must be a "null" value.