Question

Jobber error: Invalid Syntax: Only numeric values are allowed

  • 11 February 2024
  • 14 replies
  • 49 views

Userlevel 1

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?

 

 


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

Userlevel 7
Badge +14

@WorkflowMagic 

Can you show the OUTPUT from that Formatter step?

Userlevel 1

@Troy Tessalone 

Userlevel 7
Badge +14

@WorkflowMagic 

Try mapping this variable.

 

Userlevel 7
Badge +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

Userlevel 1

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

Userlevel 7
Badge +6

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

Happy Zapping! ⚡️

Userlevel 7
Badge +14

Hi @WorkflowMagic 

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

 

Userlevel 1

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

 


 

 

Userlevel 7
Badge +14

@WorkflowMagic 

Try this formula:

SUM([VARIABLE],0)

Userlevel 1

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

 

 

 

Userlevel 7
Badge +14

@WorkflowMagic 

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

Userlevel 1

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

 

 

 

Userlevel 7
Badge +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

 

 

Userlevel 1

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