Best answer

Line item search and replace null value with 0

  • 15 December 2021
  • 1 reply
  • 351 views

Hi

I try to set up a Zap between Shopify and accounting.

I have one line item “Discount application index: null, [0], null” and one line item “Discount application: 10”

I want to create a new line item using the first line item where null is replaced with 0 and [0] with the value from the second line item. How can I do that?

icon

Best answer by SamB 17 December 2021, 11:10

View original

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 +11

Welcome to the Community, @smort! :)

Null values in line items are typically ignored, but I did come across a workaround posted in a related thread that may help. It suggests you could potentially use a Formatter (Numbers > Spreadsheet-Style Formula) action to convert the null value into a different value:
 


Hopefully that’ll do the trick!