Skip to main content
Best answer

Line item search and replace null value with 0

  • December 14, 2021
  • 1 reply
  • 835 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?

Best answer by SamBBest answer by SamB

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!

View original
Did this topic help you find an answer to your question?
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

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7427 replies
  • Answer
  • December 17, 2021

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!