Help

Convert line items into text strings

Last updated:

Not all apps support line items. If you need to send line item values to an app that doesn’t support line items, you can use Formatter to convert your line items into text strings.

Tip

Line items appear as offset, numbered lists. Each set of line items will be grouped and indented under one number.


1. Add a Formatter step to your Zap

  • In the Zap editor, go to the 2. Do This step. If you don’t see this step, click the + icon to add a new step.
  • In the Built-In Apps section, select Formatter by Zapier.
  • In the Choose App Event section, click the Choose Action Event dropdown menu and select Utilities.
  • Click Continue.

2. Customize the line item to text transformation

  • In the Customize Utilities section, click the Transform dropdown menu and select Line-item to Text.
  • In the Values section, click the Input dropdown menu and select a field from a preceding step that has line-item data.

Text to line item input field.

  • (Optional) In the Separator field, enter the symbol that separates each line item. Most line items are comma-separated values and will be separated at all commas by default.
  • Click Continue.

3. Test your line item to text transformation

  • In the Send Data section, click Test & Review or Test & Continue.
  • If the transformation is successful, the step data from the trigger will be converted into an individual text string for each line item value, as well as a single text string including all line item values. You can either see the data received or continue directly to your action step

Formatter by Zapier test.

After creating your text string with Formatter, you can use this plain text in further actions in your Zap.


Need More Help?

Contact Support

Tell us about your problem, and we’ll find you a solution or you can email support.
Get Help

Hire an Expert

We have a directory of professionals across the globe who are ready to help.
Find a Zapier Expert

Zapier Community

Connect with other Zapier users and industry professionals to get help crafting the perfect workflow.
Check out the community