Field validation between 2 workspaces

[bestmichael]

Is it possible to validate information entered on 1 workspace a field on another workspace?

I've created a workspace similar to the "Approval List" with 3 fields:  First Name, Last Name, Password.  The last field is computed as "Last name, First Name"

In the other workspace, when editing a report I want them to log in with a different password that is stored in the new "Approved List" after they select their "Last Name, First Name" from a picklist.

Any ideas what I need to do?

Mike

[jpiggee · Accepted solution]

Hi Michael,

What you are trying to is possible is possible

To do this, the user in question that you want to check the password with would have to be in a linking pick list, so we have somewhere to look and compare passwords.

The best way to do this would be to utilize the new on demand script running (behavior script added in 9.05) this would allow you to run this at will by using JS that would be the easiest to do.

An example of this would be

var user=item.user;

var passwordLocal=item.password;

var passwordSaved=item.user.password;

If (passwordLocal====passwordSaved){

//do something

}

Else

{passwordLocal==='incorrect password';}

[mbest]

Thank you Joe!