Is there a way to make the Maximum Value Dynamic (Number Column, in Form View)?

[jpsmith]

Hello all,

I have a form view, with a number coloumn/row.

I want the max. quantity amount that users can input to be limited by the amount of laptops or iPads that are actually available at any one time (live data) e.g 40 laptops total, only 13 available - so the user cannot enter more than 13.

My data source is already working this out. I've tried entering a few different expressions under Data Validity and Auto Compute but can't seem to get anything to work.

Any suggestions?

Been racking my brains trying to figure this out.

[lynchk21 · Accepted solution]

You should be able to use Valid_if for this. The expression would be something like:

• [_This]<=[Available Quantity]

Of course, I am not sure how you are getting the "available quantity", so that will need to change based on what column(s) you have

[KareemElkafi]

Good solution 👍

[BlueTech]

You might run into issues if you’re trying to amend an order. For example, if you select all 13 available items and save, the available stock becomes 0. When you later edit the order (e.g., update delivery details), the system may block the save because it doesn’t recognise the stock was allocated to this order.

To handle this, try something like the following Valid_if expression to account for the current row’s quantity:

[_THIS] <= ([Available Quantity] + [Quantity])

This ensures the system checks available stock plus the quantity already reserved for the current row, allowing edits without conflicts.

[jpsmith]

Ah thanks so much! I tried a few different expressions under Valid If but couldn't get one to work as I had expected but this seems to have solved it!

Thanks again!