The special phone field type was a number field that only supported phone numbers. With the sunsetting of the field type in RPM, you will need to migrate from using the phone number field to using a formatted text field to retain the data. You can also delete the field if you do not wish to retain the data.
To migrate from the special phone field to a text field, go to the Top Menu >> Setup.
In the setup, select to the process that needs to be modified. When in the process go to the Fields tab.
On the form you will be looking for the field type Special Phone. Click Edit on this field.
In the field edit, click on Advanced.
In this drop-down checkmark Convert this field to a text field option. Click Finish.
A warning will come up letting you know that once the field type has been converted it cannot be undone. Click Finish.
This will convert your special phone field to an ordinary text field without a pattern. You can leave it as it is or set the field to use a pattern to reflect a phone number. To set the pattern, click on Edit for the field.
Set Enforce patter to Yes and enter your preferred phone number format.
With the enforced pattern now set, go to the process view page, and create a view with the form Number and phone number text field.
With the view now created, click Download in the top right to export the data to a spreadsheet.
In Excel, to convert from a string of numbers to the phone number format. Open the downloaded spreadsheet and enter the following formula into a blank column:
="(" & MID(B2, 1, 3) & ")" & MID(B2, 4, 3) & "-" & MID(B2, 7, 4)
"B2" in the formula will represent the first cell containing the phone numbers on your spreadsheet. You can change this cell in the formula if your phone number field is in a different cell. Fill the formula to the bottom of your spreadsheet data. You should now see the phone number formatted into the enforced pattern.
Select all of the the formatted phone numbers in the column and Copy them. Right Click the highlighted column and then Paste just the Values into the original Phone Number column to replace the data.
Delete the formula column. You should be left with just the Form Number and formatted Phone Number field.
Go back to the process in RPM. Select More and then Import.
Click Browse... and select your spreadsheet. Then click Upload.
For Existing data, set it to Overwrite. Click Import.
If you receive any errors, ensure the pattern for the field is formatted the same as it is on your spreadsheet. If no errors are shown, click Done to complete.
Your phone numbers should now be formatted in the correct text pattern.