List Field defaults and Validation

[wesoos]

Hello, I was wondering how I can get some validation working on list fields.  I have it working with text fields but need it with list fields as well.  With that I probably need some default value as the first item in the list field, something like "--Select Item--".  How can I get a value like that in there if I'm using lookup tables to populate my list fields?

Thanks

[Rob Nicol]

Here is an example of a data change action script for a list field:

myField = clientevent.field

if (myField.value == "-1") then
  myField.validation = "Field value is invalid"
else
  myField.validation = ""
end

The lookup table bound to this field should include the default value. In your case the first value in the list should have a display value of "-- Select Item --" and a data value of -1. The ordering of the list is defined by the select statement of the associated lookup table.

Rob

[IanBowles]

Another way to add a default value is to use the Empty List Selection String = "--Select Now--" This string will be put at the top of the list and will be the initial selection if it's a new record or the assigned data record has no value for that field.
If the list selection is not changed by the user, i.e. left as --Select Now--, this will be treated as a null value.

[IanBowles]

You'll also have to set AllowEmpty = true

[wesoos]

Thanks guys...