• Sign In

validating lists

Study Forum (Inactive)

View Message

view list print
validating lists wnels2  2009-11-23 15:03
Status: Closed
 
We have a study the with a hierarchy, Experiment> group> mouse. Each experiment has a different number of groups.
On the data input forms, when the user selects an Experiment they would like the group selection to change to the number of groups appropriate for that experiment. Or, could validation be implemented that related the experiment field to the group field. If each experiment were a study then cohorts could be used for the groups but the user wants everything in one study. Any features that can help with this? We're using 9.3.
Thanks,
Bill
 
 
jeckels responded:  2009-11-25 15:47
Hi Bill,

I don't think that any of the existing validation features will help with this scenario. You could potentially create a customized input form that uses JavaScript to either filter or validate the user's selection.

Or, you might be able to create a report backed by a custom query that shows mismatched values. I realize that it's better to catch this kind of problem at input time, but it could still be helpful.

Thanks,
Josh