Forum Stats

  • 3,874,142 Users
  • 2,266,672 Discussions


how to prevent inputting negative figures in data forms?

User_B7S1S Member Posts: 1 Green Ribbon
edited Sep 1, 2022 9:16PM in Planning and Budgeting


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?