Customize

Format Phone Number

Summary

Create a string converted from the phone number into the specified format.

How to use

You can get the original phone number value by using expressions to access another field or the result of another action.

To set the result of the calculation to another field, enter the target field into the parameter “Target Field (Optional)”.

Use expressions when using the result for other actions without setting it immediately.

The formatted string is set as the result of the action.

To access the conversion result, use an expression to reference this action in other actions.

For example, if the action of “Format Phone Number” is the first action, set the value in the parameter “Set Field Value” as follows:

=$1

By specifying it like this, you can extract it.

Parameters

Set Phone Number, Format, and Country Code or Region Code, and Target Field (Optional).

Phone Number

Specify the phone number before conversion.

To access the value of another field, enter the field code as follows:

=Text_1_2

Insert an equals sign “=” before the field code to access the value of that field.

Format

Select the type of format after conversion.

  • Domestic: The format for Japan would be 090-0000-0000, and for the US, it would be (201) 000-0000, specific to each region.
  • Domestic (numbers only): It is in a form that removes non-numeric symbols such as hyphens and parentheses from the format of “Domestic”.
  • International: It is the standard format for international calls. The plus sign “+” and the country code are at the beginning. For Japan, it is in the format of +81 90-0000-0000.
  • E.164: It is formatted according to the international standard E.164. It will be in the form of +919000000000.

Country Code or Region Code

Specify the country associated with the phone number when the “Phone Number” provided does not include the country code.

Specify “JP” to refer to Japan and “US” to refer to the United States. Alternatively, if it’s Japan, you can specify using the international phone country code, such as 81.

Target Field (Optional)

Use this parameter to set the results to another field. You can omit this parameter if you do not set the results directly in the field but use it in another action.

If you select a field inside a table, all rows of that table will be processed. For exceptions: See (*1)

*1: If you set a Condition that only applies to some table rows (such as the Condition “When Fields Value Changed”), the value will be set only for those affected by that Condition.

Compatibility with krewSheet

This action is designed to work seamlessly with krewSheet.

However, the following restrictions apply to the parameter “Target Field (Optional)":

  • The results cannot be assigned to a field that was retrieved through a Lookup.
  • The following field types can be set when a record is saved (e.g. when you select the Condition “Before Record Saved Excluding Deleted"): If you want to gain more technical knowledge, refer to the krewSheet documentation .
    • Fields not included in the krewSheet view’s columns
    • Fields set to read-only in krewSheet
    • Rich text field