- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
how to prevent inputting negative figures in data forms?
we have a requirement to prevent all users from inputting any negative numbers in all forms.
any ideas what would be an efficient way to implement this?
we thought of the following:
1-using validation rules in all forms
but then the user will be able to input negative values normally , will only be stopped when he reaches the approval submission workflow.
Also , this leads to some trouble with forms that has too many rows.
2-using a BR attached to each form that detects if entered data is negative , and then sets it to #missing and maybe returning an error
but this looks like a very costy solution
do you have better suggestions?