Skip to main content

I am trying to set up a Zap that updates a field on a Trello card by adding the total price when a Shopify order is placed. I have tried two layers of formatting to try to get it to recognize the numbers as numbers, but it’s still saying only numeric values are accepted. Please help. I’m at my wits’ end, and I can’t keep shouting “they are numbers!” at my screen and hoping it works.

The values:

The attempt

What it’s telling me:

The results

The trigger is a Shopify order. This pulls a custom field on a Trello card. It is then meant to add the total price to the value of this custom field and update it on the card, but I have the workaround steps of formatting the field contents into a number and then removing the commas from that formatting. Can anyone help me to set this up properly please? Thank you!

Welcome to the Community, @moltenmaterials🙂

The formula that Formatter action is expecting to receive would need to be in this format SUM(2950.31,155.66). So I expect it’s the “=” and “+” signs in that Formula field which are causing the error. Try removing the equal sign (=) and change the plus sign (+) to a comma (,) instead:

82b7907baa7760f8e76068f84ef26af3.png
Can you give that a go and let us know if that fixes it?


Welcome to the Community, @moltenmaterials🙂

The formula that Formatter action is expecting to receive would need to be in this format SUM(2950.31,155.66). So I expect it’s the “=” and “+” signs in that Formula field which are causing the error. Try removing the equal sign (=) and change the plus sign (+) to a comma (,) instead:

82b7907baa7760f8e76068f84ef26af3.png
Can you give that a go and let us know if that fixes it?

That did it, thank you~!