New to appsheet here .
I am trying to make a Inventory Management app
I have a sheet which totals my Stock the Columns are ( Details and Inventory(which is just a Sumif formula in my google sheets that sums the purchases and subtracts the sales) .
I then have a sheet that records all my transactions which has Columns ( Date , Time , Details , Purchase , sales )
Then created 2 slices for the Purchase and sale forms and added them as action buttons.
However Sometimes Users sell more inventory than we have and the Stock column will display a negative , is there a away to give a error code before they save the form or is there a way to make a variable min and max range slider ?