Some of its capabilities include:
Converting text to the number (e.g., "$12,345.67" to 12345.67) for easy comparison in If/Else conditions with number operators.
Formatting currencies to their respective locales before sending emails or SMS to contacts, ensuring a professional appearance.
Formatting United States phone numbers as international numbers (e.g., adding "+1" country code) before storing or sending them via email, SMS, Slack, or a custom webhook to another platform.
Here are some practical business examples for each of the Number Formatter Action features:
Text to Number:
a. E-commerce order value calculation: An online store receives order data as text, like "3 items at $12.50 each." The Text to Number feature can extract the numerical values, enabling the calculation of the total order value.
b. Sales data analysis: A company receives sales data in a text format such as "Revenue: $10,500.00." Using Text to Number, they can convert it to a numeric value for easy analysis and comparison.
c. Financial report data import: A business imports financial data from a spreadsheet, with values like "€2,500.00." Text to Number can convert these values for seamless integration into the Pest AI reporting features.
d. Survey response analysis: A marketing firm collects survey data with text-based responses like "I spent £150 last month." Text to Number can convert these values for further analysis and customer segmentation.
e. Social media data processing: A brand extracts numeric data from social media posts, like "We reached 10K followers!" Text to Number can convert this data to numerical values for tracking and reporting purposes.
Format Number:
a. International sales reports: A multinational company needs to present sales data in region-specific formats for easier comprehension by their international teams.
b. Customized invoices: A business generates invoices with region-specific number formatting, catering to the preferences of their international clients.
c. Data export: A company exports data from their CRM to share with a partner in another country, requiring the conversion of number formats to match local conventions.
d. Client reports: A marketing business prepares reports for clients in different countries, adjusting the number formatting to match local preferences.
e. Product pricing updates: An e-commerce store updates product prices on its website to accommodate different number formats based on the customer's location.
Format Phone Number:
a. SMS marketing campaigns: A company standardizes collected phone numbers into a consistent format for more effective SMS marketing campaigns.
b. International calling: A customer support team formats phone numbers to include country codes, ensuring successful connections to international customers.
c. Data validation: A business verifies and corrects the formatting of phone numbers in their CRM to improve data accuracy and reduce communication errors.
d. Personalized communication: A sales team adjusts the phone number format to match the customer's region, making the communication more relatable and personalized.
e. Lead management: A lead generation company formats phone numbers to ensure proper routing and assignment to relevant sales agents.
Format Currency:
a. Personalized pricing display: An e-commerce store displays prices in the local currency format based on the customer's location for a better shopping experience.
b. Invoicing: A business generates invoices with currency values formatted according to the client's country, ensuring clarity and professionalism.
c. Financial reports: A company prepares financial reports for stakeholders in multiple countries, formatting currency values to match local expectations.
d. Marketing materials: A marketing businesscreates promotional content with region-specific currency formatting to appeal to international audiences.
e. Budget management: A project manager converts currency values in their budget to a standardized format for easy comparison and analysis.
Random Number:
a. Unique discount codes: An online retailer generates random discount codes for a limited-time promotion to encourage sales.
b. Lottery-style giveaways: A company runs a giveaway where customers are assigned random numbers, and the winners are selected based on a random number draw.
c. Randomized product recommendations: A subscription box service uses random numbers to select items for inclusion in their customers' personalized
d. A/B testing: A company uses random numbers to assign website visitors to different versions of their website for A/B testing. This helps ensure a fair and unbiased distribution of visitors between the test groups.
e. Customer support ticket assignment: A customer support team assigns incoming support tickets to agents based on random numbers. This method helps evenly distribute the workload among agents and ensures that no single agent is overwhelmed with requests.
To use the Number Formatter Action, follow these steps:
Inside a workflow, add the Number Formatter Action
In the Number Formatter action, choose the Text to Number option in the Action Type dropdown.
a. Select Field: Choose a suitable field for text-to-number conversion from Contact fields, Custom fields, Custom values, or Inbound Webhook Trigger.
b. Input Decimal Mark: Define the character used to denote the decimal portion of the number.
c. Output: Use the result in further actions in your workflow with {{number_formatter.2.result}}
In the Number Formatter action, choose the Format Number option in the Action Type dropdown.
a. Select Field: Choose a suitable field for number formatting from Contact fields, Custom fields, Custom values, or Inbound Webhook Trigger.
b. Input Decimal Mark: Define the character used to denote the decimal portion of the number.
c. To Format: Select the required format from the list.
d. Output: Use the result in further actions in your workflow with {{number_formatter.2.result}}
In the Number Formatter action, choose the Format Phone Number option in the Action Type dropdown.
a. Select Field: Choose a suitable field for phone number formatting from Contact fields, Custom fields, Custom values, or Inbound Webhook Trigger.
Please Note:
If you choose the Format Phone Number Action Type, you would only be able to choose Phone Number related fields
b. To Format: Select the required format from the list.
c. Country Code: Select the required country code from the list.
d. Output: Use the result in further actions in your workflow with {{number_formatter.2.result}}
In the Number Formatter action, choose the Format Currency option in the Action Type dropdown.
a. Select Field: Choose a suitable field for currency formatting from Contact fields, Custom fields, Custom values, or Inbound Webhook Trigger.
b. Currency: Select the required currency format from the list.
c. Currency Locale: Select the required currency locale format from the list.
Please Note:
Currency locale refers to the regional settings and conventions used to display currency values, taking into account the local formatting rules, symbols, and language preferences. It determines how currency values are formatted and presented based on the region or country where the currency is being used.
For example, the currency locale for the United States uses the US Dollar symbol ($) and formats currency values with a comma as the thousands separator and a period as the decimal separator (e.g., $1,234.56). In contrast, the currency locale for Germany uses the Euro symbol (€) and formats currency values with a period as the thousands separator and a comma as the decimal separator (e.g., €1.234,56).
Using the correct currency locale ensures that your customers or users can easily understand and interpret currency values, as they will be presented in a familiar and expected format.
d. Output: Use the result in further actions in your workflow with {{number_formatter.2.result}}
In the Number Formatter action, choose the Random Number option in the Action Type dropdown.
a. Specify the Lower Range and Upper Range.
Please Note:
The Lower Range and Upper Range in the Random Number action type are the parameters that define the minimum and maximum values, respectively, within which a random number will be generated. By setting these values, you can control the range of possible numbers that can be produced by the Random Number action.
For example, if you set the Lower Range to 1 and the Upper Range to 100, the Random Number action will generate a random number between 1 and 100, inclusive. This functionality can be useful for creating unique codes, selecting random samples, or generating dynamic content within your CRM workflows.
b. Specify the Decimal Points
c. Output: Use the generated random number in further actions in your workflow with {{number_formatter.2.result}}.
Please Note:
When selecting fields, ensure they suit the chosen formatting operation to avoid errors or unexpected results.
A: Absolutely! Inbound Webhook Trigger can retrieve numbers from external APIs and format them accordingly.
A: You can use multiple instances of the Number Formatter Action in a single workflow to perform various formatting operations.
A: The Random Number feature generates numbers within a specified range. While it does not guarantee absolute uniqueness, the odds of generating the same number multiple times decrease as the range increases. To further ensure uniqueness, you can implement additional checks in your workflows to track previously generated numbers and prevent duplicates from being used. This combination of a wide range and proper tracking will help minimize the likelihood of non-unique random numbers in your applications.
A: The Number Formatter Action is designed specifically for formatting numbers. For date values, consider using a dedicated date formatting action or tool.
A: The Number Formatter Action supports formatting numbers using the Arabic numeral system (0-9). Formatting numbers in languages with non-Arabic numeral systems would require a specialized tool or custom implementation.
