# Negative number in number entry field

**URL:** <https://community.glideapps.com/t/negative-number-in-number-entry-field/80054>\
**Category:** Ask for Help\
**Created:** [February 14, 2025, 9:16am UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054 "2025-02-14T09:16:51Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [February 14, 2025, 9:16am UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/1 "2025-02-14T09:16:51Z")

</div>

Moving from Classic Apps to New Apps I cannot put negative number in a number entry field. I have set min and max values but numbers with the negative sign cannot be input. I am very surprised!

---

<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:** [February 14, 2025, 9:27am UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/2 "2025-02-14T09:27:47Z")

</div>

That should work. Is the number entry component writing to a number type column?

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [February 14, 2025, 9:32am UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/3 "2025-02-14T09:32:31Z")

</div>

Yes!

---

<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:** [February 14, 2025, 9:43am UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/4 "2025-02-14T09:43:16Z")

</div>

Okay. I can’t explain why it doesn’t work for you. It works for me.

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [February 14, 2025, 9:51am UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/5 "2025-02-14T09:51:01Z")

</div>

That’s a pity! It works in Classic apps and I can put negative numbers through New apps Data but this i no good solution. I have to remain in unsupported Classic Apps 🤓!

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [February 14, 2025, 9:58am UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/6 "2025-02-14T09:58:48Z")

</div>

![Screenshot 2025-02-14 10.57.21](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6f3ce96dfa634c6e455241ec455680886de237ff.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 14, 2025, 2:27pm UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/7 "2025-02-14T14:27:35Z")

</div>

Can you explain what happens when you try to put a negative sign? It just doesn’t let you write?

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [February 14, 2025, 5:34pm UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/8 "2025-02-14T17:34:29Z")

</div>

The minus sign (-) dissapear when i press the following number and the result becomes positive.

 ![Screenshot 2025-02-14 18.30.23](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/3/5312d447749179ffa91e0af5ea42c9d3f72557cb.png)

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [February 14, 2025, 5:46pm UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/9 "2025-02-14T17:46:02Z")

</div>

@Darren_Murphy @ThinhDinh glad to know that you both are still here! 🤓

---

<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:** [February 14, 2025, 5:47pm UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/10 "2025-02-14T17:47:47Z")

</div>

So the Base Year number entry is linked to the Costs column? Can you show the configuration for the number entry component? Have you tried deleting the component and re-adding it?

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [February 14, 2025, 5:55pm UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/11 "2025-02-14T17:55:43Z")

</div>

@Jeff_Hager also glad that you also are still here!

The Base Year number entry is not linked to the Costs column.  
The configuration for the number entry component is shown above!  
Yes I have tried deleting the component and re-adding it without success.

---

<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:** [February 14, 2025, 5:59pm UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/12 "2025-02-14T17:59:06Z")

</div>

So to be clear, you have the Base Year number entry highlighted in your last screenshot, but you are actually referring to the the last entry component labeled Costs, correct?

> [@Ralf](#):
>
> The configuration for the number entry component is shown above!

That is the configuration for the column. I want to see the configuration for the entry component.

Setting a Min and Max should not remove the minus sign. At most it will show a warning that you are out of range.

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [February 14, 2025, 6:03pm UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/13 "2025-02-14T18:03:12Z")

</div>

Base year is an independant input!

 ![Screenshot 2025-02-14 19.00.59](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/9833aeff4a7127542706701383a7be64c69d9d52.png)

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [February 14, 2025, 6:07pm UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/14 "2025-02-14T18:07:26Z")

</div>

Changed max to zero, problem remains!

 ![Screenshot 2025-02-14 19.05.48](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/2/e2077db405c5b7acf0807232ce9e285406c23cc7.png)

---

<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:** [February 14, 2025, 6:17pm UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/15 "2025-02-14T18:17:45Z")

</div>

OK, everything looks normal. I tried setting it up myself exactly the same and it works for me. The only noticable difference between you and me is the different regional formatting of numbers, which really shouldn’t matter.

Let’s try something. Your region uses a space for the number group separator. That should not be a problem, but I’m curious if changing the column to not use a group separator would make any difference.

Another thing to try is to create a new number column and point your entry component to that new column instead.

If neither of those two things work, then I’m not sure what’s going on. Like I said, you should be able to type a minus sign and at worst it will give a red warning message if out of range, but should not remove the minus sign. My only guess at this point is that something is weird with the Costs column itself.

Try those two things. Otherwise this may need to be escalated to Glide support.

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [February 14, 2025, 6:31pm UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/16 "2025-02-14T18:31:12Z")

</div>

@Jeff_Hager Thank you very much! I have tried all your suggestions without success!  
It is too hard to escalate the issue to Glide support so I change my underlying Google sheet model instead. But nevertheless thank you all! 🤓

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 15, 2025, 1:53am UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/17 "2025-02-15T01:53:43Z")

</div>

If you use it for a Glide Table number column, does it work?

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [February 15, 2025, 7:39am UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/18 "2025-02-15T07:39:34Z")

</div>

Yes, it works!

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [February 15, 2025, 1:37pm UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/19 "2025-02-15T13:37:12Z")

</div>

Next problem, I would like to use a percentage as input i.e 9%, is that possible?

---

<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:** [February 15, 2025, 3:00pm UTC](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054/20 "2025-02-15T15:00:09Z")

</div>

I would either enter the decimal version of percent (0.09), or enter percent (9), but always divide it by 100 when using it for any math.

[Next page](https://community.glideapps.com/t/negative-number-in-number-entry-field/80054.md?page=2)
