How to add leading symbol in a numeric field?

[jasonw51098449]

Hi!

I need to add leading symbol * in a numeric field.

Numeric field length is 10. If enter 15000,the result will be *****15,000.

Please help me out. Thanks!

[try67]

You can't do that using the built-in Number format setting. You will need to write your own custom format and possibly keystroke and/or validation scripts to achieve it.

[Joel Geraci · Accepted solution]

Put the following in the custom format script of the field.

The string starts with 10 asterisks then the number entered into the field gets commas inserted to separate the thousands and gets added to the 10 asterisks then we just grab the last 10 characters from the string and you get your padded value.

event.value = String("**********" + event.target.value.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ",")).slice(-10);

[jasonw51098449]

Thanks! it works like a charm!