AnsweredAssumed Answered

Field Validation using conditional value list

Question asked by LuukvanSummeren on Sep 3, 2015
Latest reply on Sep 4, 2015 by LuukvanSummeren



Im trying to validate a field using a calculation but im getting stuck somehow.


In my database I have a table with students, every student has a username to login to an NMR system

A user can either be active or inactive

I made a conditional valuelist with the usernames of all active users using

Now when i enter a username for a new user I want to check that it is not allready in assigned to an active user.


my calculation looks like:

IsEmpty( FilterValues ( ValueListItems (Get ( BestandsNaam);"Unames"); student::Uname))


when i run this calculation in a script it seems to be working fine. An occupied username returns 0, a free username returns 1

but when i use this calculation to validate the Uname field i get an error message saying that the entry is not valid even when i enter a unique username


I cant use the unique option to validate because i have students in the database that are inactive and their usernames have allready been deleted form the NMR system so they are reusable.


What is going wrong, and how can i fix this?


Thanks in advance