Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to prevent inputting negative figures in data forms?

User_B7S1SSep 1 2022 — edited Sep 1 2022

Hello
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?

Comments

Processing