How do I change the format for phone?

[becky.harris]

Hello! I’m trying to create data with Phone but will need it to come through as xxx-xxx-xxxx. Currently it displays as 1-(xxx) xxx-xxxx. Does anyone know how to format this field to display without the country code and parentheses?

Thank you in advance!

[yoni]

You could add a formula to the field: https://www.mockaroo.com/5ce4f9b0 (the fx button)

The formula I used replaces the ###-(nnn) with nnn- . It’s not the most elegant solution, but it serves as a quick example.

this.gsub(/^\d+-\((\d+)\)/, '\1-')