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 SamB
Welcome to the Community,
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!
+11Welcome to the Community,
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!
Build and deploy automations from AI tools you already use. With Agentic Management, if anything breaks, the agent diagnoses the issue and proposes a fix.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
