# Form validation \> Number field

**URL:** <https://community.glideapps.com/t/form-validation-number-field/43969>\
**Category:** Ask for Help\
**Created:** [July 6, 2022, 11:27am UTC](https://community.glideapps.com/t/form-validation-number-field/43969 "2022-07-06T11:27:19Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![blairrorani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blairrorani/32/43426_2.png) [@blairrorani](https://community.glideapps.com/u/blairrorani)\
**Post date:** [July 6, 2022, 11:27am UTC](https://community.glideapps.com/t/form-validation-number-field/43969/1 "2022-07-06T11:27:19Z")

</div>

I have a form that includes a number field.

I created a custom action that includes a condition to check if the value in the number is greater than another value in my datasource that changes daily. However, the only option that Glide gives me is to enter a custom value (i.e. I can’t the value to another value in my datasource).

See what I’m seeing, I added “100” to test the action, but this needs to be dynamic from my datasource vs. a custom value.

![Screen Shot 2022-07-06 at 9.25.59 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/1/81631b7f98d1d760e11b22e8cb780f8437a2747c.png)

Is there another way to achieve this?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 6, 2022, 11:35am UTC](https://community.glideapps.com/t/form-validation-number-field/43969/2 "2022-07-06T11:35:13Z")

</div>

Is the column that you want to compare it against also a number type?

---

<div class="post-metadata">

**Author:** ![blairrorani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blairrorani/32/43426_2.png) [@blairrorani](https://community.glideapps.com/u/blairrorani)\
**Post date:** [July 6, 2022, 11:45am UTC](https://community.glideapps.com/t/form-validation-number-field/43969/3 "2022-07-06T11:45:34Z")

</div>

that was it, so the logic is, the fields available in conditions are the ones of the same data type 🤝

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 6, 2022, 1:26pm UTC](https://community.glideapps.com/t/form-validation-number-field/43969/4 "2022-07-06T13:26:19Z")

</div>

Yes. Although probably more correctly the same _data_ type. So for example, if you were doing a text comparison (is/is not/includes/etc), you just need to be comparing text to text. So any column that returns text should be available. That could be a text column, or a template, or a joined list, an if-then-else, or a handful of others.

---

<div class="post-metadata">

**Author:** ![blairrorani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blairrorani/32/43426_2.png) [@blairrorani](https://community.glideapps.com/u/blairrorani)\
**Post date:** [July 7, 2022, 2:43am UTC](https://community.glideapps.com/t/form-validation-number-field/43969/5 "2022-07-07T02:43:14Z")

</div>

Link to [related tweet](https://twitter.com/blairrorani/status/1544852201545183234?s=20&t=W2XD0Kq45UPChAkRLEEoow)

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 8, 2022, 2:43am UTC](https://community.glideapps.com/t/form-validation-number-field/43969/6 "2022-07-08T02:43:58Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.