Forum Stats

  • 3,874,142 Users
  • 2,266,672 Discussions
  • 7,911,738 Comments

Discussions

how to prevent inputting negative figures in data forms?

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

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?

Tagged:

Answers