Skip to main content

I am trying to add these line items from Jobber but getting "Invalid Syntax: Only numeric values are allowed". What should I do to avoid this issue?

 

 

That’s awesome @WorkflowMagic! Big thanks to Troy for lending a hand here.

Happy Zapping! ⚡️


@Troy Tessalone I believe the output text worked, thank you very much!!


@WorkflowMagic

If that doesn’t work, then a Code step can be used to loop the values and SUM.

https://zapier.com/apps/code/help


@WorkflowMagic 

Try mapping this variable.

 


@Troy Tessalone 


@WorkflowMagic 

Can you show the OUTPUT from that Formatter step?


@Troy Tessalone yes, I shared it in the second photo but resharing 

 

 


@WorkflowMagic 

You should map the 1 variable that has all the concatenated text values.

Can you post screenshots with how your Formatter > Utilities > Line Items to Text

 

 


@Troy Tessalone now I get the original issue The app returned "Invalid Syntax: Only numeric values are allowed".

 

 

 


@WorkflowMagic 

Try to first convert the line items to text with this action: Formatter > Utilities > Line Items to Text


@Troy Tessalone I did not get an error with that formula but the outcome is not correct.. The deal amount should sum to $350. Am I missing a step?

 

 

 


@WorkflowMagic 

Try this formula:

SUM((VARIABLE],0)


@Troy Tessalone thanks for the reply.. so when using that I get an error.. Do I need to separate the line items? 

 


 

 


Hi @WorkflowMagic 

The data is formatted as line items, so follow the guidance of the tip.