Skip to main content
Question

Troubleshooting price calculation errors in Zapier using Formatter

  • September 30, 2025
  • 8 replies
  • 34 views

I’m trying to add up prices i extracted from my google form using formatter, but its saying invalid format. I dont know if the error is from the format i used in the google form in terms of numbers or from my zappier. Please help

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • September 30, 2025

Hi ​@Busaxo11 

For us to have more info about what you are referring to post screenshots showing how your Zap steps are outlined and configured in the CONFIGURE tab while in EDIT mode with the field mappings visible.


  • Author
  • Beginner
  • September 30, 2025
This is a picture of my zap

 


  • Author
  • Beginner
  • September 30, 2025
Also included is a picture of my google form

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • September 30, 2025

@Busaxo11 

Issues:

  1. You have 2 variables mapped into the same input field
    1. Fix is to have 1 variable mapped per input field
    2. In other words, 2 variables, means 2 input fields, each with 1 variable
  2. The value for each variable is not a number, rather the variable value is “sample text question answer”
    1. Fix is to make sure you test your GForm with real data, then pull thru a trigger example to use to test your Zap action steps
    2. Make sure to test your Zap trigger step again after submitting the GForm

 


  • Author
  • Beginner
  • September 30, 2025

Thank you for the help so far, i have adjusted the first issue. but i still have issues with the google form.


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 1, 2025

@Busaxo11 

Try this order of operations:

  1. Submit the GForm with real data
  2. Go to your Zap trigger step and test in the TEST tab to pull thru your real GForm submission
  3. Test your Formatter step using the real GForm submission data

  • Author
  • Beginner
  • October 1, 2025

thank you for the response. I’m still having the same issues


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 1, 2025

@Busaxo11 

Help us have current context, by posting screenshots showing how your Zap steps are now outlined and configured along with any errors from testing.