Input / Display mask question

[WindForce]

In my UX, i need to enter/display a field as follows:
- first character is either + or - sign
- then numbers in the format 99.99
So the field looks like +7.95 or -12.4
How can this be done exactly?

Thanks
Jaime

[peteconway]

Re: Input / Display mask question

Don't know the context or use case but this may help you understand.
2018-12-09_1315.png

if(textboxNumber <>0,(if (textboxNumber>0,'+'+textboxNumber,'-'+textboxNumber)),'0')

2018-12-09_1317_001.png

[Davidk]

Re: Input / Display mask question

In my UX, i need to enter/display a field as follows:
- first character is either + or - sign
- then numbers in the format 99.99
So the field looks like +7.95 or -12.4
How can this be done exactly?

Thanks
Jaime

I think the question needs more detail. Data bound UX? List Control? Calculations being done?

A negative number will always carry the negative sign.
Are you entering -9999 and want to return -99.99?
Are you entering +123 and want to return +123.00?
Are you entering 123 and want to return +123.00?
Are you entering 123 and want to return +1.23?
If a data bound UX, what value is the database carrying... and what do you want to show in the UX. Examples really help.

Some examples of what you want and some detail would help. Also the version/build of Alpha would be nice.

[CharlesParker]

Re: Input / Display mask question

My example is super basic but it works. enter a number into the value field, and the calculated value shows up in the actual_field. I dont know if it's what you want but even if it isn't it might give you an idea on how you might want to do it.

plusNminus.a5wcmp

Like I said it is SUPER simple but it seems like your just looking to concatenate a field with the plus sign for display purposes. Negative numbers will show the negative sign. The actual_field is a character field and could just be used to display the value.

[WindForce]

Re: Input / Display mask question

Sorry for not being more precise in my original question, it's not a calculation issue but just an input mask/display mask issue.
These are plain simple textboxes where an optician enters a value for the Sphere reading. The format should be as described in my question.
In VFP i had character fields with an inputmask of #99.99 which means first character is either + or - or digit, the rest are digits. I then had validation to limit first character to either + or -

[Davidk]

Re: Input / Display mask question

Still some information missing... however...

To keep your "+" and "-" in the database you'll need to use a character field type.

In your UX TextBox control, in Client Side Properties, turn on Client side formatting and change the Format type to "Custom".

In Format definition make sure the "Type" is set to String. Your Parse Out value will be...

data = formatInput(data)

This calls the Javascript function "formatInput" and passes in the value of the Textbox control.

The Javascript function is...

function formatInput(data){

	if(data == 0 && data == '') return;
	var inSign = String(data).substring(0,1);
	if(inSign != "-" && inSign != "+"){
		alert("Value must start with + or -");
		return data;
	} 
	var inData = parseFloat(data); 
	inData = inData.toFixed(2);

	switch(true){
		case (inData > 0):
			return "+" + inData;
			break;
		default:		
			return inData;
	}

}

If the incoming value is 0 or null then just return... nothing to do.

Otherwise, grab the 1st character of the string and check for a + or -. If neither, return the input value with an alert.
Instead of alert you could use .clientSideValidateField() for a nice red error message under the control.

If we have a + or - then convert the string to a number. Then trim it down to 2 decimals places.
Then, in the Switch statement... if the # is greater than 0, add the prefix "+" back to it... and return that string.
If the # is not greater than 0, then just return it. If it's a negative number, then it still has the sign and we don't have to add it as a prefix.

[WindForce]

Re: Input / Display mask question

LOL David unleashed...beautiful code, thank you!

[CharlesParker]

Re: Input / Display mask question

dk_unleashed.jpg

Sign up here!

https://www.emailmeform.com/builder/...HLXhp47Aodt0fi

[WindForce]

Re: Input / Display mask question

LOOOL
Check out my responses :-)

[CharlesParker]

Re: Input / Display mask question

Just so you know it's BYOB, lol

[WindForce]

Re: Input / Display mask question

I know, I should have copy-pasted my answer here :-)
It was something related to David's "Michael Franks" voice :-)