Who This Is For / When to Use
Use this action when you need to:
Convert text values into numbers for calculations or conditions.
Format numbers, phone numbers, or currencies before storing or sending them.
Generate random numbers dynamically inside a workflow.
Ensure numeric data is consistently formatted across accounts, messages, and integrations.
Overview: Number Formatter Action Types
The Number Formatter action includes five distinct action types:
Text to Number
Format Number
Format Phone Number
Format Currency
Random Number
Each action type is configured independently and returns a reusable Result value.
Adding the Number Formatter Action to a Workflow
Open a workflow and add a new action.
Search for Number Formatter under Internal actions.
Select Number Formatter.
Using the Result Output
Every Number Formatter action generates a Result value.
You can reference this output in later workflow steps, messages, or conditions.
Access the result using the variable picker.
Path format:
{{number_formatter.<step_number>.result}}
Action Type: Text to Number
Converts numeric text into a usable number.
Example: "$12,345.67" → 12345.67
Configuration Steps
Set Action Type to Text to Number.
Select the field containing the numeric text.
Available sources include Contact, User, Message, Account, Attribution, Custom Fields, and Custom Values.
Choose the Input Decimal Mark.
Period (
123.45)Comma (
123,45)
Save the action.
Output
A numeric value returned in Result.
Action Type: Format Number
Formats an existing number into a region-specific display format.
Configuration Steps
Set Action Type to Format Number.
Select the numeric field to format.
Define the Input Decimal Mark.
Choose the To Format option.
Example formats include:
1,234,567.891.234.567,891 234 567.89
Save the action.
Output
A formatted number string returned in Result.
Action Type: Format Phone Number
Standardizes phone numbers into consistent national or international formats.
Configuration Steps
Set Action Type to Format Phone Number.
Select a phone-number-compatible field.
Only phone number fields are selectable.
Choose the To Format option.
Examples:
E164 (
+15413134664)International (
+1 541-313-4664)National (
(541) 313-4664)
Select the Country Code if required.
Save the action.
Output
A formatted phone number returned in Result.
Action Type: Format Currency
Formats numeric values into localized currency strings.
Configuration Steps
Set Action Type to Format Currency.
Select the numeric field to format.
Choose the Currency.
Example: USD ($), EUR (€), GBP (£)
Select the Currency Locale.
Determines separators, symbols, and placement.
Save the action.
Output
A localized currency value returned in Result.
Action Type: Random Number
Generates a random number within a defined range.
Configuration Steps
Set Action Type to Random Number.
Define the Lower Range.
Define the Upper Range.
Set Decimal Points.
Controls trailing decimals (e.g.,
0,2).
Save the action.
Output
A randomly generated number returned in Result.
Common Issues and Fixes
Incorrect numeric conversion
Ensure the Input Decimal Mark matches the source data format.
Phone number not selectable
Only phone-number-type fields are available for Format Phone Number.
Currency appears incorrectly
Verify both Currency and Currency Locale selections.
Unexpected random values
Confirm the Lower and Upper Range values and decimal settings.
FAQ
Can I use Number Formatter with data from external APIs?
Yes. Values received through an Inbound Webhook Trigger can be selected and formatted using the Number Formatter action.
Can I use multiple Number Formatter actions in one workflow?
Yes. You can add multiple Number Formatter actions, each with its own configuration and result.
Does Random Number guarantee uniqueness?
No. Random Number generates values within a range. To ensure uniqueness, track previously generated numbers using workflow logic.
Can I format dates using Number Formatter?
No. Number Formatter only supports numeric values. Use a date-specific formatting action for dates.
Can I force trailing zeros in numbers?
Yes. Use Decimal Points in Format Number or Random Number to control trailing zeros (e.g., 10.00).