Skip to main content
Question

Jobber error: Invalid Syntax: Only numeric values are allowed


Forum|alt.badge.img

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?

 

 

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.

14 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @WorkflowMagic 

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

 


Forum|alt.badge.img
  • Author
  • Beginner
  • 10 replies
  • February 11, 2024

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

 


 

 


Troy Tessalone
Forum|alt.badge.img+14

@WorkflowMagic 

Try this formula:

SUM([VARIABLE],0)


Forum|alt.badge.img
  • Author
  • Beginner
  • 10 replies
  • February 11, 2024

@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?

 

 

 


Troy Tessalone
Forum|alt.badge.img+14

@WorkflowMagic 

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


Forum|alt.badge.img
  • Author
  • Beginner
  • 10 replies
  • February 12, 2024

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

 

 

 


Troy Tessalone
Forum|alt.badge.img+14

@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

 

 


Forum|alt.badge.img
  • Author
  • Beginner
  • 10 replies
  • February 12, 2024

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

 

 


Troy Tessalone
Forum|alt.badge.img+14

@WorkflowMagic 

Can you show the OUTPUT from that Formatter step?


Forum|alt.badge.img
  • Author
  • Beginner
  • 10 replies
  • February 12, 2024

@Troy Tessalone 


Troy Tessalone
Forum|alt.badge.img+14

@WorkflowMagic 

Try mapping this variable.

 


Troy Tessalone
Forum|alt.badge.img+14

@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


Forum|alt.badge.img
  • Author
  • Beginner
  • 10 replies
  • February 12, 2024

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


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6466 replies
  • February 13, 2024

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

Happy Zapping! ⚡️