Available on plans:
Free
Pro
Team
Enterprise
Use Formatter to change number formats. You can modify numbers in three ways:
- Currency: Convert numbers to currency formats.
- Number: Localize numbers into different regional number format conventions.
- Phone number: Standardize phone numbers into a specific format.
This is helpful when you need a different format in later steps in your Zap.
1. Add a Formatter step
- In the Zap editor, click the Action step. A dialog box will open.
- In the search box, search for and select Formatter. The right sidebar will open to the Setup tab.
- Click the Action event dropdown menu and select Numbers.
- Click Continue to continue to the Configure tab.
2. Set up your transform
Currency
This transform will allow you to format numbers into currency formats (e.g. $1234.56, €100).
- Click the Transform dropdown menu and select Format Currency.
- In the Input field, map the field containing the currency number you want to style.
- Click the Currency dropdown menu and select your desired currency.
- Click the Currency Locale dropdown menu and select your desired currency locale.
- Click the Currency Format dropdown menu and choose from the pre-defined format options.
- You can also use a custom value and refer to the Unicode formatting rules for additional options.
- Click Continue to continue to the Test tab.
NoteThis transform will not convert the amount into another currency.
Number
This transform allows you to specify how numbers are grouped and where decimal points are placed (for example 1,234.56 into 1 234,56).
- Click the Transform field dropdown menu and select Format Number.
- In the Input field, map the field containing the number you want to style.
- Click the Input Decimal Mark dropdown menu. Select which character should be used to separate the whole part of a number from its decimal part.
- Click the To Format field dropdown menu and select from the pre-defined format options.
- Click Continue to continue to the Test tab.
NoteThis transform cannot round or pad numbers.
Phone number
This transform allows you to format phone numbers with country codes and validate them against the selected country code (for example +1 (123) 456-7890).
- Click the Transform field dropdown menu and select Format Phone Number.
- In the Input field, map the field containing the phone number you want to style.
- Click the To Format field dropdown menu and select the format.
- (optional) Click the Phone Number Country Code dropdown menu and select the country code.
- You can also set the country code using a custom value.
- (optional) Click the To Format field to open the dropdown menu.
- Click Continue to continue to the Test tab.
3. Test your action
Test your action to verify it is formatting the data correctly.
- Click Test step.
- The Data out tab will display the Output with the new formatted data.
- If the new data is not what you expect, you can adjust the transform settings and retest the step again.
Once you’ve set up your Formatter action, you can use the results in further actions in your Zap.