Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Data Validation on Webforms Question

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
Best Answer
-
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
Answers
-
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
-
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
-
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.
-
I believe you're referring to the @RETURN function.
There's another post today where someone is having issues getting the error message to render correctly via an input form.
- Jake
-
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