How to "restrict" the type of input to text fields, i.e. check that the input is valid?

[fliptoback]

Hi again,

for an input like the following:

'Custom Values, 'V = ? {123}

Is there a way we can limit the type of values we input? such as check if the value falls within a range?

Thanks!

[javila]

Hi, @fliptoback !

It depends on what you are doing with this information... I'm not sure there is a builtin function for that. But you can use a simple if() or #if-#else:

'<!-- Here I just used 1 or 0 for true or false -->
#hide
isItWithinTheRange(val; val_min; val_max) = if(and(val ≥ val_min; val ≤ val_max); 1; 0)
#show
V = 123
itsOK = isItWithinTheRange(V; 100; 200)
'<!-- Then you can just check it with if-elses whenever you want -->

[fliptoback]

Thanks Javila. I am sorry I didn't phrase my questions correctly. What I meant to ask is this...

I have a text field whereby I can insert some numbers into this variable "V". Now say the valid "V" values I can accept is range between 100 and 200. If I enter say 250, how do i "ignore" it in the text field - similar to how the excel validation would work in the cell?

So essentially i want to force the input of valid numbers into the text field.

Is this achievable?

[javila]

Does this help you?

V = 250
#if or(V < 100; V > 200)
'<span class="err">V is outside accepted range!!! So pick another value!</span>
#else
'<span class="ok">Yay! Let''s do some hard calculation stuff!!!</span>
a = 1 + 1
b = 1*1
c = 1/1
#end if

[fliptoback]

Hi Javila, not quite - I have put together a screen capture video of excel. could you please have a look to see if this can be done on Calcpad?

excel.validation.mp4

[javila]

@fliptoback ,

It thought that was exactly what I did (without the popup, of course). No? If the value is outside the range, it shows the error and does nothing. I haven't play with inputs and forms, though. So, if you need something related to that, I can't help much. I'm sorry.

[fliptoback]

@fliptoback ,

It thought that was exactly what I did (without the popup, of course). No? If the value is outside the range, it shows the error and does nothing. I haven't play with inputs and forms, though. So, if you need something related to that, I can't help much. I'm sorry.

No worries thanks Javila. You have been a big help already. It might be a limitation of the calcpad input method. I will use the if-then-else strategy for now. Hopefully Ned will provide such feature in a future calcpad release.

[idealkindom]

#hide v=0 #while or(v<100;v>200) #input #pre v=?{150}'. #post v'. 在 2025-09-05 08:48:24，fliptoback ***@***.***> 写道： Thanks Javila. I am sorry I didn't phrase my questions correctly. What I meant to ask is this... I have a text field whereby I can insert some numbers into this variable "V". Now say the valid "V" values I can accept is range between 100 and 200. If I enter say 250, how do i "ignore" it in the text field - similar to how the excel validation would work in the cell? So essentially i want to force the input of valid numbers into the text field. Is this achievable? — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[fliptoback]

Thanks idealkindom. I try out the code - say I input 250 (which is outside of the valid range), then i press F5, it run the rest of the script and populate the number 150.

How do i make the original input to be within 100 and 200?

[idealkindom]

#hide v=0 #while or(v<100;v>200) #input #pre 'v should be in the range of (100,200)： v=?{150}'. #hide #loop #post v'. 在 2025-09-05 09:38:35，fliptoback ***@***.***> 写道： Thanks idealkindom. I try out the code - say I input 250 (which is outside of the valid range), then i press F5, it run the rest of the script and populate the number 150. How do i make the original input to be within 100 and 200? — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.Message ID: ***@***.***>

[Proektsoftbg]

Hi!

You can do that entirely in input phase by JavaScript. Try this example:

'<p id="v">'v = ? {150}'</p>
'<p>'d = ? {50}'</p>
#val
'<script>
'$("p#v input").focusout(function(){
'    var v = Number($(this).val());
'    if(v < 100 || v > 200) {
'        alert("Invalid value!!!"); 
'        $(this).css("color","red");
'    } else $(this).css("color","black");
'});
'</script>

[fliptoback]

Thanks Ned. This is a good solution.

However, when i input the value into "V", I have to press "tab" instead of "enter" key.

Is there a way I can press enter instead?