The Number Formatter action offers five key features: Text to Number, Format Number, Format Phone Number, Format Currency, and Random Number. These functionalities enhance your workflows by converting and formatting numerical data for various applications.
Features of the Number Formatter Action
Text to Number: Converts text representations of numbers (e.g., "$12,345.67" to 12345.67) for straightforward comparisons in If/Else conditions.
Format Number: Adjusts numbers to specific regional formats, ensuring clarity and professionalism in communications.
Format Phone Number: Transforms U.S. phone numbers into international formats (e.g., adding the "+1" country code) for consistent storage and communication.
Format Currency: Converts currency values to match local conventions, enhancing the professional appearance of emails and SMS.
Random Number: Generates random numbers within specified ranges for unique identifiers or selections.
Use Cases for Each Number Formatter Action Type
Text to Number:
Sales Data Analysis: Converts revenue figures in text format (e.g., "Revenue: $10,500.00") to numeric values for easier analysis.
Financial Report Data Import: Converts values like "€2,500.00" for seamless integration into reporting features.
Survey Response Analysis: Converts survey responses like "I spent £150 last month" for further analysis.
Social Media Data Processing: Converts numeric data from posts (e.g., "We reached 10K followers!") to numerical values for reporting.
Format Number:
International Sales Reports: Presents sales data in region-specific formats for easier understanding by international teams.
Customized Invoices: Generates invoices with localized number formatting.
Data Export: Exports data while matching local conventions for external partners.
Client Reports: Prepares reports with adjusted number formats for clients in various regions.
Product Pricing Updates: Updates e-commerce product prices based on customer location.
Format Phone Number:
SMS Marketing Campaigns: Standardizes phone numbers for more effective marketing.
International Calling: Formats phone numbers with country codes for customer support.
Data Validation: Verifies and corrects phone number formats in CRMs.
Personalized Communication: Adjusts phone formats for better relatability with customers.
Lead Management: Formats numbers for proper routing to sales agents.
Format Currency:
Personalized Pricing Display: Displays prices in local currency formats for an improved shopping experience.
Invoicing: Generates invoices with currency values formatted by country.
Financial Reports: Prepares reports with local currency formatting for stakeholders.
Marketing Materials: Creates promotional content with region-specific currency formatting.
Budget Management: Converts currency values for easier comparison in budget analysis.
Random Number:
Unique Discount Codes: Generates random codes for promotions.
Lottery-Style Giveaways: Assigns random numbers for customer giveaways.
Randomized Product Recommendations: Uses random numbers to select items for subscription boxes.
A/B Testing: Assigns website visitors to different versions for unbiased testing.
Customer Support Ticket Assignment: Distributes support tickets to agents using random numbers for balanced workload.
How to Use the Number Formatter Action
Inside a Workflow: Add the Number Formatter action.
Text to Number:
Choose Text to Number in the Action Type dropdown.
Select Field: Pick a field for conversion (Contact fields, Custom fields, etc.).
Input Decimal Mark: Specify the character for the decimal point.
Output: Use the result in further actions with {{number_formatter.2.result}}.
Format Number:
Choose Format Number in the Action Type dropdown.
Select Field: Choose a field for formatting.
Input Decimal Mark: Define the decimal character.
To Format: Select the required format from the list.
Output: Use the result in further actions with {{number_formatter.2.result}}.
Format Phone Number:
Choose Format Phone Number in the Action Type dropdown.
Select Field: Choose a suitable field for formatting.
To Format: Select the required format.
Country Code: Choose the appropriate country code.
Output: Use the result in further actions with {{number_formatter.2.result}}.
Format Currency:
Choose Format Currency in the Action Type dropdown.
Select Field: Choose a suitable field for formatting.
Currency: Select the required currency format.
Currency Locale: Select the required currency locale.
Output: Use the result in further actions with {{number_formatter.2.result}}.
Random Number:
Choose Random Number in the Action Type dropdown.
Specify Lower and Upper Range: Set the minimum and maximum values.
Specify Decimal Points.
Output: Use the generated number in further actions with {{number_formatter.2.result}}.
Notes
When selecting fields, ensure they are appropriate for the chosen formatting operation to avoid errors.
FAQs
Can I use the Number Formatter Action to format numbers from external APIs? Yes! Inbound Webhook Trigger can retrieve and format numbers from external APIs.
Can I apply multiple formatting operations within the same workflow? Yes, you can use multiple instances of the Number Formatter Action for various formatting tasks.
How does the Random Number feature ensure uniqueness? While the Random Number feature generates numbers within a set range, it doesn’t guarantee uniqueness. Implementing additional tracking can help avoid duplicates.
Can date values be formatted using the Number Formatter Action? The Number Formatter Action is designed for numbers. For date formatting, use a dedicated date formatting tool.
Can I use the Number Formatter Action for non-Arabic numeral systems? This action supports the Arabic numeral system (0-9). For other numeral systems, consider specialized tools or custom solutions.