nuBuilder Forum

I have a slightly unique situation I'm trying to figure out. I need people to input numbers quickly, but still save in the correct format. Let me give a few examples to illustrate:

user types "2" and then it auto formats to "+2.00"
user types "-2" and then it auto formats to "-2.00"
user types "1.5" and it auto formats to "+1.50"

I see where to specify decimal point and # of zeros in nubuilder, but I'm not sure about adding the + or - automatically in a format the software understands. I can get it to add +/- easily enough in front of a number... just not be selective depending on what is typed in.

One option I thought to save time was to separate the + and - into a new area that users would select before each number, but I hope there is a simpler way.

An alternative would be to have a drop down of available numbers to pick from and just have -2.00 and +2.00 in that list also, but I haven't figured out if typing or selecting from a list is going to be easier for users. I'm open to advice on this. I just have my past experience as a user thinking the option I'm not using must be faster, ha.

Thank you for even reading all this...

You'd have to use a Text format for "Input Type (and class)" and in the database a varchar column type in order to have a "+" sign stored in the database.

Adding an onblur JavaScript event to the object's Custom Code will format the number accordingly when the field loses focus.

Your speed is most impressive! Many thanks to you and the others who have took up the nuBuilder mantle.

Thanks orangezero , you are the most welcome!