How to Prevent Inventory Stock from Going Negative

[ThinhDinh]

You are trying to lookup the “max value” in a form, that won’t happen naturally due to the sandbox nature of the form.

You have 2 ways to go here:

• First method: For the Product ID choice, create a column in your users table for it, and write to that column instead of the Product ID in your Work Orders table. Then, add a special value in your form to write User Profiles > Product ID to the Work Orders.

This allows you to access the Product ID value whilst still inside the form. From that value, you can create a relation & lookup to retrieve the max value allowed for the quantity.

• Second method: Create a custom form.

How do I create a custom form?

I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using User Specific Columns and Relations Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particular…