Formatting A Column for a Code

[Devina_Maxwell]

I need my app to show my code in the following format 999-999-999 , my spreadsheet already does this but when it shows in the APP its looks like this 999999999, Thanks in Advance Devina

[Aleksi]

You would need to use text field instead of number field. If you need to do that with the same field, you could create an Event action that will convert the value from 999999999 to 999-999-999 when saving the record. It would be something like…LEFT([Column],3)&"-"&MID([Column],4,3)&"-"&RIGHT([Column],3)

[Devina_Maxwell]

Thank you

[Aleksi]

You’re welcome