topic Re: Ensure only numbers are used as input in 'Variable input' object in App Development

Ensure only numbers are used as input in 'Variable input' object

Kartik2 — Thu, 14 Mar 2024 07:02:42 GMT

how can i ensure that only numbers are input and not text or any characters in 'Variable input'
If any text or char is used set the variable to 1.
How can we do this

Re: Ensure only numbers are used as input in 'Variable input' object

marcus_sommer — Thu, 14 Mar 2024 07:51:22 GMT

In QV there are options to enforce only certain values and especially the possibility to provide (calculated) value-lists from which the user could select the wanted value is very useful. I don't know if Sense has similar features.

Beside this you could query the variable-value and reacting on it, maybe like:

sum(Value) * $(=rangemin($(MyVar), 1))

and/or:

if(isnum($(MyVar)), 'MyVar = ' & $(MyVar), 'invalide value in MyVar')

and showing it within a title or any text-box and/or using isnum($(MyVar)) as a calculation-condition.

Re: Ensure only numbers are used as input in 'Variable input' object

Kartik2 — Thu, 14 Mar 2024 11:02:27 GMT

Hi @marcus_sommer , isnum() or istext() or isnull() shows error as I input nothing or any 'xyz' string in the input string.
I want to let the user input an exchange rate ,if the user puts nothing or zero or any string in that case i want the variable to be set to 1 ,so that wherever i have used that variable as a division i can see proper values.

Re: Ensure only numbers are used as input in 'Variable input' object

marcus_sommer — Thu, 14 Mar 2024 11:35:04 GMT

Yes, of course if the content of a variable is a string then needs the variable-call be adjusted. In your case maybe like:

if(isnum(num#('$(MyVar)')) or num#('$(MyVar)') = 0, 1, num#('$(MyVar)'))

Re: Ensure only numbers are used as input in 'Variable input' object

Kartik2 — Thu, 14 Mar 2024 12:05:30 GMT

Thanks @marcus_sommer , I tweaked your solution to meet my needs ,this is the working expression

if(not isnum(num#('$(vEuroRate)')) or num#('$(vEuroRate)') = 0 or isnull(num#('$(vEuroRate)')), 1, num#('$(vEuroRate)'))

The first one is to handle any text in the input box ,second is to handle 0 and the third is to handle null