I have item prices and average calculated as follows:
If new item is entered using Form Screen, I want to limit price entry within -50% and +50% of average unit price. In this example, for ham would be 5-15 and Eggs for 0,20-0,60.
Calculating avrege price was easy, but I can’t find the solution for set the limits intended in real time, e.g. during the data entry for new item. It is requred that after filling of field “Item”, the limits for “Price” should be 5-15 for “Ham”!
When you use a Custom Form, the values the user enters are written to User Specific columns, which means that you can use them to compare to pre-existing data, and control the user flow based on those comparisons. You don’t have this option with native forms, as the values are not written to the table until after the form is submitted - which is too late to take any action.