Data Validation on Webforms Question

1048239

Hi,

I put some data validation on a webform that will turn the cell Orange if user enters a negative value.  However it still accepts the negative value.  So technically they could leave it and move on.   Is there a way to block users from entering a negative value into a cell?  Or is this as close as you can get?

Thanks

Jake Turrell

Data validations cannot currently prevent the data from actually being saved.  (It has been requested many times.)  With that said, you CAN prevent users from promoting their data if this validation fails.

Hope this helps,

- Jake

Jake Turrell

Data validations cannot currently prevent the data from actually being saved.  (It has been requested many times.)  With that said, you CAN prevent users from promoting their data if this validation fails.

Hope this helps,

- Jake

amith.madisetty

Hi,

The Only way we can avoid doing this is through having workflow in the validation so that when the user tries to promote the data to next review level so that until he comes over with positive numbers its should not promote which is acheivable through workflow in validation rule.

Thanks

Amith

1048239

Thought so.  I did read a blog a while back that there is a new function you can use in a calc script/business rule that can do some validation and actually pop a window up and have a message in it.  Can't remember where to find it though.Some new function that will dislplay and error warning.

Anyways, thanks for confirmation.

Jake Turrell

I believe you're referring to the @RETURN function.

@RETURN

There's another post today where someone is having issues getting the error message to render correctly via an input form.

- Jake

1048239

Yes.  That's me.  Error pops up perfectly as designed when run from Business Rules menu.  As soon as you run from Webform it gets cryptic