Unanswered

Culture formatted custom number input

(0) Share

Report

Posted on by birger2

I am looking for a nice, open source, method in js/jquery to add number input fields to my page.

I am located in Norway, so my users want to type the decimal separator with comma (e.g. 1 002,23). This is not supported for the standard input with number type.

<input type="number"></input>

So I am forced to use type="text", but the I loose the ability to specify max, min, and step and react to invalid input. All of which are necessary. I also would like to support both Norwegian and English formats detected from the user's browser. Ideally, it should be something as smooth as the number input on Model Driven apps. The input field should also run on the Portal (or is it power page now?) without adding a lot of extra overhead. I also need to be able to create and delete the inputs on the fly without reloading the page, ideally through a jquery-interface.

I did stumble upon JQuery UI that is already loaded on the page, but this library has functionality for a "spinner", not a pure number input and is hard to mould into the existing layout of the page (yes I am retrofitting this functionality).

Tips to other internet sources, snippets of code or anything to help advance my quest for a simple to implement localized number input is welcome!

Categories:

Customize & extend

I have the same question (0)

All responses (3)

Answers (0)

oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

Hi, have you set the expected formatting in your environment settings?

Please take a look at this: Customize regional options - Power Platform | Microsoft Docs

Was this reply helpful? Yes No
birger2 6 on at

Like (0)

Report

Yes, I have tried changing this setting. Nothing happened, probably because I'm building a custom interface without using simple forms and lists as provided by the portal. I'm making an excel-like grid in javascript/jquery that uses the portal web api for read/write.

Was this reply helpful? Yes No
Fubar 8,375 Super User 2025 Season 2 on at

Like (1)

Report
<input type="number"></input>
the type=number will take the locale of the users browser for the displayed format. So I don't think there is any real way around it other than doing it as text and applying a regular expression to validate it.

Was this reply helpful? Yes No