How to make a range of numbers in a text input

[Aurora]

Hi all, 

I am currently working on an app that tracks the hours spent on engineering projects. I am wondering how I could set a text input to prevent the end users from entering a number above or below a certain range. For example, they shouldn't be allowed to enter a number below 0 or above 12. The number will later be submitted and updated to a column storing numerical values. 

Thank you for any feedback!

[StalinPonnusamy]

Hi @Aurora 

Option 1: We can use Dropdown since we know the valid values

Option 2: Validate the entry Value(TextInput10.Text) <= 12 

[Akshay_R-MCT]

Hi @Aurora 

I tried this from my side, its working perfectly fine for me.

This may help for you.

1) Add on Textbox, in OnClear add this code :

   If (Value(Inputbox.Text) <= 0 and Value(InputBox.Text) > 12, true, false)

2) Add on label below and show popup when they enter less than 0 and more than 12.

   If (Value(Inputbox.Text) <= 0 and Value(InputBox.Text) > 12, true, false) add this code on label onvisible.

If this solve your issue please mark as solved.

[Aurora]

I don't see "text" as an option for this text input, I would prefer to not use a dropdown here if possible. 

[Aurora]

I also can't seem to find either OnClear or OnVisible for the text input. 

 

[Akshay_R-MCT]

Hi @Aurora 

Drop and drag Text box in screen, there you find clear

[Aurora]

@Akshay_R-MCT if I try to put If(Value(txtHoursWorked.Text) <= 0 And Value(txtHoursWorked.Text) >12, true, false) in the visible field the text input disappears, i have it in clear with no errors but it still isn't fully working.

[StalinPonnusamy]

Hi @Aurora

I believe our goal is to verify the text input whether the user entered validly or not. The user should be able to save the form is only valid. So

On click on submit button or Save button 

If(Value(TextInput10.Text) <= 12 && Value(TextInput10.Text) > 0), SubmitForm(FromName), Notify("Not valid input"))

Let me know are were talking about different things.

[Aurora]

@StalinPonnusamy 

I suppose that would be one way to do it. In my head I was envisioning a text input that prevents the users from even entering a number outside of the range, the engineers should know the limit on hours they can submit at a time. So if one enters a "13" on accident instead of a "12" then I was hoping the text input could refuse to let a number over 12 even be entered. 

[Akshay_R-MCT]

Hi @Aurora 

I believe this will restrict user entering data above 12 hours

Add below code in Onchange of Text Box

If(
Value(txtHoursWorked.Text) <= 0 Or Value(txtHoursWorked.Text) > 12, Notify("Your typed value should not greater than the 12 or less than 0",NotificationType.Error)
)