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:
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: