Question

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

  • 24 October 2023
  • 1 reply
  • 44 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

Userlevel 7
Badge +6

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!