Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one input filed and it has the integer values in that. Values is range of 800 to 2700. That Inputfield I can enter any number now. Here I need to restrict to the user to enter only the value with in the range of 800-2700. How can I restrict ? Can you please help us?
Thank you
Srikanth Kota
It's not possible to restrict the values in an inputfield. Anything that is valid for the data type of the field can be entered.
Hi Manideep,
That is input field not input box, where I am taking that in Listbox. User is going to enter the range of values as I said.
Thank you
Srikanth Kota
Hi,
Is there anything preventing you from building those values in the script (from 800 to 2700) and then just displaying them in the list box? User could scroll for the number they want or search for it
-art
Hi,
Try using below expression in you list
if(Values>=800 and Values<=2700,Values)
Hi Swetha,
I already given a try with that expression. If we use that we are going to loose the Input field functionality.
Thank you
Srikanth Kota
Hi Atatum,
Initial load we are taking the range of values from excel. Later if we want that user can enter any number like input with in the range. by the we are not able to restrict other than range.
Thank you
Srikanth Kota
try this
rangeonly(if(fieldname>=800 and fieldname<=2700,fielname))as newfieldname