Attribute Input Mask: Numbers with Two Decimal Places

Hello,

I am trying to create a mask for dollar amounts.  we are using non-stock items to track our Capital equipment and use attributes to log purchase price.

I have tried the mask $#,###,##0 

I have tried the reg expression of ^\d{1,7}(\.\d{1,2})?$, (and a couple other variations, Thanks Chat GPT)

but the combo just isn’t working.  I want to be able to enter 12345.67 and mask $12,345 or $12,345 or 1234567.89 and get $1,234,567

Any thoughts?

Thanks,
Jeremy

You’re hoping for two related-but-different outcomes: formatting and rounding (or technically truncation, in your example).

You haven’t really indicated what about it isn’t working. Have you tried the individual pieces separately?

I think regex will only prevent you from entering certain formats, not change the format. (You could prevent the user from entering numbers with decimals.)

Masking should display the number in a defined format (with , and $)

​@darylbowman Well I was hoping for both…

If I want to enter 123.45 - 123456.78 how do I get $123 - $1,234,567?

When I enter the masks above it seems to work left to right and require the 7 digits or look funky.  Can i get the mask to grow from 3 to 7 digits?  

I tried this regex ^\d{3,7}$ and that limited the decimal point entry. 

Do I need to just format on the GI data?

Thanks

If that's the desired outcome, that would be much easier.