# Data Validation - Dynamic Maximum Limit on Number Entry

**URL:** <https://community.glideapps.com/t/data-validation-dynamic-maximum-limit-on-number-entry/10019>\
**Category:** Ask for Help\
**Created:** [May 30, 2020, 4:38am UTC](https://community.glideapps.com/t/data-validation-dynamic-maximum-limit-on-number-entry/10019 "2020-05-30T04:38:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Spellytics](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spellytics/32/2770_2.png) [@Spellytics](https://community.glideapps.com/u/Spellytics)\
**Post date:** [May 30, 2020, 4:38am UTC](https://community.glideapps.com/t/data-validation-dynamic-maximum-limit-on-number-entry/10019/1 "2020-05-30T04:38:19Z")

</div>

Hi Everybody,

Does anyone have an alternative solution to limiting the number that can be entered into the **Quantity** so that they do not go over the amount that is available to them?

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a56f1dc263f6404cca6a96e8b8ba34988104805f.png)

My options are currently:

1. Void the transaction if Quantity entered \> Resources Available (Not great UX)
2. Create specifc quantity categories [1K, 2K, 3K] etc., make a relation to filter the categories based on Resources Available (A lot of work)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 30, 2020, 5:01am UTC](https://community.glideapps.com/t/data-validation-dynamic-maximum-limit-on-number-entry/10019/2 "2020-05-30T05:01:38Z")

</div>

Could you create a text warning message with visibility set, if the entered value is greater than the available amount, then show the warning? Might not stop them from submitting, but might keep them honest.

---

<div class="post-metadata">

**Author:** ![Spellytics](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spellytics/32/2770_2.png) [@Spellytics](https://community.glideapps.com/u/Spellytics)\
**Post date:** [May 30, 2020, 5:47am UTC](https://community.glideapps.com/t/data-validation-dynamic-maximum-limit-on-number-entry/10019/3 "2020-05-30T05:47:04Z")

</div>

Thanks for the suggestion @Jeff_Hager!  
Mmmm, not ideal though - but most likely the easiest way to implement it.

I will do a feature request then.