This topic is locked

Number format on Add Screen

5/5/2020 2:45:15 PM
ASPRunner.NET General questions
J
jetsguy author

Hi good people.
I would like for a user to enter a number such as "1000" and have the display show the number as 1,000 (with commas) after the user enters the number?
Does anyone have any tips on how to do what I need?

Sergey Kornilov admin 5/6/2020
J
jetsguy author 5/8/2020



Maybe try masked edit?
https://xlinesoft.com/asprunnernet/docs/edit_as_settings_text_field.htm


I'm struggling with this one. Any help with this would be absolutely appreciated.

Sergey Kornilov admin 5/8/2020

What exactly is the struggle? Please be more specific.

jadachDevClub member 5/9/2020

Using SQL Server, change the field from int to float, When a user enters 1000 it is stored in the database as 1000 but the list and view page shows 1,000 (view as number).
If you want to see the number prior to saving, you can check here to see if this works.

https://stackoverflow.com/questions/1990512/add-comma-to-numbers-every-three-digits/1990590

J
jetsguy author 5/14/2020



Using SQL Server, change the field from int to float, When a user enters 1000 it is stored in the database as 1000 but the list and view page shows 1,000 (view as number).
If you want to see the number prior to saving, you can check here to see if this works.

https://stackoverflow.com/questions/1990512/add-comma-to-numbers-every-three-digits/1990590


Thanks I've read that. Here's where I am at.

I got mine to work in a very complicated way using Jquery and regular expressions and it's a lot of overhead for each field I want do this with on the ADD screen. input fields on the Add screen. s

What I want is for the user to be able to enter numbers on the ADD screen and have those numbers reformat with commas. I've seen it work on many websites but they all seem to use Jquery plugins. I simply do not know how to use Jquery Plugins in ASPRunner. Have you ever used Jquery Plugins in ASPRunner?

Sergey Kornilov admin 5/15/2020

But what exactly is wrong with Masked Edit?

J
jetsguy author 5/19/2020



But what exactly is wrong with Masked Edit?


I do not find anything in the help files about what I'm trying to do. I was hoping a user had come across this before. I have no idea how to get masked edit to do what I need actually.