Skip to main content
Question

How to format Stripe tax rates for invoices in Zapier: From (,10,20) to item1:0, Item2:20?

  • October 24, 2023
  • 1 reply
  • 91 views

hi there,

 

I am trying to create an invoice with different vat rates and the data is coming from stripe as follow fro the 3 items invoiced

tax_rates:(,20,10)

so the first Item as NO vat, the second one has 10% rate and the last one is 20%)

the outcome from zap for each item is as follow

  • Item1:””
  • item2:”20,10”
  • item3:”20,10”

how can I get from tax_rates:(,10,20) this 

  • Item1:”0”
  • item2:”20”
  • item3:”10”

Thank you for your help

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • October 30, 2023

Hi there @cwr,

Welcome to the Community! 🎉

You can probably use the Formatter (Numbers > Spreadsheet-Style Formula) action to convert the null (empty) line item to "0".

The following post that shows an example of how this works:

Hopefully, this helps!