General

Re: validation for duplicate entries

DDEBBABY — Thu, 19 Mar 2015 11:54:01 GMT

Thanks so much! That is one of the issues I am having with the first question I am having trouble figuring out how to do that!

Re: validation for duplicate entries

Hilary Stoupa — Wed, 18 Mar 2015 20:39:01 GMT

I guess for the first item, you'd have to requery the list the form submits to in order to find out if there is anything already in the list for a given tester id and schedule. Then you could mark the current request as cancelled (if that is what you are trying to do?)

For the second item, you should be able to just create a validation formula - but put the start and end times on your form as calculated values with the formatting set to show you the XML value - so you know what the actual values are and can write the formulas accordingly.

validation for duplicate entries

DDEBBABY — Wed, 18 Mar 2015 12:12:29 GMT

Hello I have a form that I am trying to create some validations for and having some troubles. anyone know how I can implement this?

Have a validation for duplicate entries (Tester ID that falls on the same requested schedule) Request will still be saved in the List but will be marked as "Cancelled”.

Have a validation for requests that fall (start or end) between 5-6 PM shall be not accepted