Zapier Formatting

Formatter by Zapier is a tool that allows you to manipulate and transform data in a variety of ways. With Formatter by Zapier, you can take data from one app and format it in a way that is consistent with another app. For example, you can take data from a web form and format it to match the requirements of a database.

Together, these tools can automate workflows for data collection, manipulation, and management. In this context, one of the most common needs is formatting date/time and currency data. With Formatter by Zapier, you can easily convert date/time and currency data from SpreadsheetWeb Hub apps to match the requirements of other apps or databases, ensuring that your data is consistent and accurate across all platforms. In the next sections, we will show how to use Formatter by Zapier to format date/time and currency data from SpreadsheetWeb Hub apps.

Date Time

When it comes to handling date and time data, there can be challenges in ensuring that the data is formatted correctly. This is where Formatter by Zapier comes in. By using Formatter by Zapier in conjunction with SpreadsheetWeb Hub, users can easily format date and time data to meet their specific needs, saving time and effort while ensuring accuracy and consistency across different platforms.

EU Date to US Date

If the source date format is in European style (day-month-year), you may see calculation errors on the values calculated by SpreadsheetWeb Hub app in Zapier.

Instead of resolving the issue by formulas in Excel, use Zapier’s Formatter app’s Date / Time tools to parse your date and convert it to a desired format.

Insert the app after your trigger or app that returns an EU Date and before the SpreadsheetWeb Hub app in a zap.

Select Date / Time event on the Formatter.

Select Format option in the Transform dropdown to see the formatting related inputs.

  • Input: The field you want to pass to SpreadsheetWeb Hub
  • To Format: The format of the output date. We suggest selecting a common US Date or “year-month-day” which are recognizable by SpreadsheetWeb Hub applications like Excel itself.
  • To Timezone: Fill this in if your datetime field has a timezone. Skip it for date-only values.
  • From Format: the format of the source date. Select the matching format of the value you want to send.
  • From Timezone: Fill this in if your datetime field has a timezone. Likewise skip for a date value without time.

You can test the Formatter app like any other in Zapier to see the output date.

If the output date is in correct format, edit the SpreadsheetWeb Hub action and replace the date with the formatted one. You need to assign the output value from the Formatter.

Once set, retest the SpreadsheetWeb Hub action. You will get the correct results.

Other date formats

You can parse and convert various date types with Formatter.

Currency

When working with data from web applications, it’s important to ensure that the data is accurate and consistent, especially when dealing with financial information. However, the formatting of this data may not always be compatible with other apps or systems. That’s where Formatter by Zapier comes in. By using Formatter by Zapier, you can easily format currency from SpreadsheetWeb Hub Apps to ensure that it is consistent and accurate across different platforms.

It is likely to see a #VALUE! error as an output if you are dealing with international transactions based on local currencies. The SpreadsheetWeb Hub applications may not handle uncommon currencies like Excel.

To handle this kind of situation the numeric value should be stripped. If you need, you can reformat the out value after calculations are made. Zapier’s Formatter app can cover both operations easily.

Parsing number from a custom currency

Insert the app after the source data and before the SpreadsheetWeb Hub app.

Select Text event and click Continue to be able see text-related actions.

Select Extract Number option in the Transform dropdown to see the input and select the currency value from your source app.

Test the Formatter app like any other in Zapier to see the output value. It should display the number without a currency symbol.

If the value is correct, edit the SpreadsheetWeb Hub action and replace the currency with the numeric value. You need to assign the output value from the Formatter.

Once set, retest the SpreadsheetWeb Hub action. You will get the correct results.

Formatting a number

If the raw numeric value seems dull, you can easily format it to desired currency with an additional step. Once again, the Formatter app can help us.

Add another Formatter app after the SpreadsheetWeb Hub app to work with calculated values. This time select Numbers as event in the Formatter app.

Select Format Currency option in the Transform dropdown to see the currency formatting related inputs.

  • Input: The numeric field you want to format.
  • Currency: The currency you want to apply.
  • Currency Locale: The locale to be used for the currency formatting.
  • Currency Format: The format of the currency. You can determine formatting aspects like using a symbol ($) or letters (USD) or separation of thousands.

Test the action to see the formatted number.

Hundred-based percentage values

When working with data collected through SpreadsheetWeb Hub Apps, it is common to encounter percentages in the hundred-based format (e.g. 25% or 75%). However, some applications may require these values to be formatted in decimal or other formats.

Not every platform handles numeric values with the same approach. While some of them use the formatting for a visual aspect some others alter the value itself. Percentage values are one of the numeric data types you may fool you by using percentage (%) symbol near a number while holding the integer value. For example, keeping as 12 while displaying 12%.

If you use this kind of data in your calculations, you will see that your result is multiplied by 100. The opposite scenario is possible as well.

This is where Formatter by Zapier can come in handy. By using Formatter by Zapier, you can easily manipulate the percentage values to fit your specific needs.

Instead of changing the formulation in your Excel file of your SpreadsheetWeb Hub application, you can use Zapier’s Formatter app to do simple math operations like multiplying or dividing on the zap itself.

Insert the Formatter app after the source data and before the SpreadsheetWeb Hub app.

Choose Numbers event to access math operations and press Continue to access Actions.

Select Perform Math Operation at the Transform dropdown to see the operation inputs.

  • Operation: The math operation to be performed on the inputs.
  • Input: The numbers you want to calculate. You need to select the number you want to multiply or divide as well as 100 as a number.

Click Continue and Test the operation.

If the value is correct, edit the SpreadsheetWeb Hub action and replace the previous percentage with adjusted value. You need to assign the output value from the Formatter.

Once set, retest the SpreadsheetWeb Hub action. You will get the correct results.

Formatter by Zapier is a powerful tool that can be used to format and manipulate data from SpreadsheetWeb Hub Apps in a variety of ways. Whether you need to format date/time values, currency, or hundred-based percentage values, Formatter by Zapier provides a user-friendly and efficient solution. By using this tool in conjunction with SpreadsheetWeb Hub Apps, you can streamline data management and automate workflows, saving you time and effort. With its versatility and ease of use, Formatter by Zapier is a valuable asset for any organization looking to optimize their data processes.

Previous Updating SpreadsheetWeb Hub Applications with Google Drive