Currency field on Record Producer

[Community Alums]

Hi,

There is no Currency field for record producer. 

What is the Script to hard code '$' on one of the field of the record producer and it will only allow number and decimals.

How do I achieve this use case?

Thank you

[Dan119]

Thanks Mark, this worked great, how can we add the comma when the value $1,000.00?  That would be a great addition to your current solution.

Thanks in advance.

[Luc_Sutherland]

You should mark Mark's answer as correct.

Anyway, here is a good regex expression:

^\$[+-]?[0-9]{1,3}(?:,?[0-9]{3})*(?:\.[0-9]{2})?$