SourCherry Help Centre
HomeWorkflowsWorkflow Actions

Workflow Action - Number Formatter

TABLE OF CONTENTS


Overview

The Number Formatter workflow action is used to format and generate numeric fields. It includes several functionalities like converting text to numbers, formatting numbers, formatting phone numbers, formatting currency, and generating random numbers.


Action Name

Number Formatter


Action Details

Text to Number

Converts text representations of numbers into numeric format. For example, "$12,345.67" to 12345.67.



Action Details:

FieldDescriptionMandatory
Action NameThe name of the action, which can be customized.Yes
Action TypeDefines the action, set as Text to Number.Yes
Select FieldChoose the field containing the text representation of a number.Yes
Input Decimal MarkSpecifies how the decimal is marked in the input (e.g., period).Yes


Example Workflow Configuration:


----------------------------------------------------------------------------------------------------------------------


Format Number

Formats a number according to the defined settings, such as decimal places and thousands separators.



Action Details

FieldDescriptionMandatory
Action NameThe name of the action, which can be customized.Yes
Action TypeDefines the action, set as Format Number.Yes
Select FieldChoose the field containing the number.Yes
Input Decimal MarkDefines the current decimal mark used in the input number.Yes
To FormatThe desired output format for the number (e.g., period).Yes


Example Workflow Configuration:


----------------------------------------------------------------------------------------------------------------------


Format Phone Number

Standardises a phone number into the desired format (e.g., (123) 456-7890).



Action Details:

FieldDescriptionMandatory
Action NameThe name of the action, which can be customized.Yes
Action TypeDefines the action, set as Format Phone Number.Yes
Select FieldChoose the field containing the phone number.Yes
To FormatThe desired format for the phone number (e.g., E.164).Yes
Phone Number Country CodeSpecifies the country for the phone number.Yes


Example Workflow Configuration:


----------------------------------------------------------------------------------------------------------------------


Format Currency

Formats a numeric value as currency, taking into account locale-specific settings.



Action Details

FieldDescriptionMandatory
Action NameThe name of the action, which can be customized.Yes
Action TypeDefines the action, set as Format Currency.Yes
Select FieldChoose the field containing the numeric value.Yes
CurrencyThe currency type (e.g., USD, EUR).Yes
Currency LocaleThe locale format for the currency (e.g., en-US).Yes


Example Workflow Configuration:


----------------------------------------------------------------------------------------------------------------------


Random Number

Generates a random number within a specified range.




Action Details

FieldDescriptionMandatory
Action NameThe name of the action, which can be customized.Yes
Action TypeDefines the action, set as Random Number.Yes
Lower RangeThe minimum value of the generated random number.Yes
Upper RangeThe maximum value of the generated random number.Yes
Decimal PointsDefines how many decimal points are allowed.No


Example Workflow Configuration: