About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

How to show 0 number in Monday.com's Board

  • 18 August 2022
  • 9 replies
  • 124 views
H

I am using Zapier to transfer data from Shopify to Monday.com. It seems every field equals to 0 doesn’t show as 0 in Monday. It just blank. Is there any way to display those 0 value in Monday?

 

icon

Best answer by christina.d 14 September 2022, 08:25

View original

9 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @harveysun 

Good question.

Check your Zap Runs details to see the DATA IN/OUT for each Zap step to help you troubleshoot: https://zapier.com/app/history/

 

We’d need to see screenshots with how your Zap steps are configured in order to have proper context.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
H

I screenshot each step and take filed “total_tax” as example.

First step output
The corresponding column in Monday
Data transfer to Monday

 

Troy Tessalone
Userlevel 7
Badge +14

@harveysun 

Can you show how your Monday Zap action step is configured with the fields mapped from the Zap trigger step?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
H

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

 

Troy Tessalone
Userlevel 7
Badge +14

@harveysun 

Try adding double quotes around each of those mapped variables.

 

Per the Monday GraphQL API docs: https://api.developer.monday.com/docs/number

 

Updating a numbers column

You can update a numbers column with both a simple string or a JSON string.

 

 
Simple strings

To update the numbers column, send a string containing a float or int.

For example: "3"

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
H

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

It seems this doesn’t work. I tried to test it, the result is still the same.

 

Troy Tessalone
Userlevel 7
Badge +14

@harveysun 

I was able to replicate the issue with 0s.

I suggest opening a ticket with Zapier Support: https://zapier.com/app/get-help

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
jesse
Userlevel 7
Badge +9

Hey @harveysun just checking in here! It looks as though our support team got back to you and said:

Would you please try escaping the added double quotes in the fields in the Zap editor like so:
 
\"...\"

Were you able to try that and if so, did it help? If not, we definitely recommend continuing to troubleshoot with the support team in your open ticket with them. 

Keep us posted! It looks like you’re so close to getting this working. 🙂

christina.d
Userlevel 7
Badge +9

Hi friends. I wanted to pop in and mention it looks like @harveysun is running into a bug in the Monday app. 😔

They were added to a bug report and will be emailed once a fix is in place. We’ll also be sure to update the thread once that takes place.

Thanks for flagging this in the Community!

Reply


Terms & Conditions