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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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

Issue when Changing column value in Monday.com from Google Sheet.

  • 9 August 2023
  • 9 replies
  • 96 views
kevinaz
Userlevel 1

Hello there :-)

I’m in need of help to make a simple zap working.
I’m trying to update a number of an item in monday.com when this item in google sheet is changed.
 


I first selected a record :

 

​​COL$D = 0 is the number I want to update.
COL$L = 1242752333 is the item ID in monday.com - I have all the Monday ID in GoogleSheet to make it easier
 

Here I choose the right board and searching the item by Google Sheet providing monday ID, and the number where I want to see the update happening.

 


And here we can see that it is finding the item, but not updating the number { 4 : { id: solde, value: ”-2431” }}
Instead of 0 I still have -2431.

Any clue will be helpful ! 
Thanks a lot 

icon

Best answer by ken.a 11 August 2023, 11:55

View original

9 replies

Troy Tessalone
Userlevel 7
Badge +14

@kevinaz

Good question.

Try putting double quotes around the mapped variable. “[VARIABLE]”

 

 

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

Hello again @Troy Tessalone !
First thanks for your help, it is much appreciated!
I did it and it stills not working.
 

 

Troy Tessalone
Userlevel 7
Badge +14

@kevinaz 

I was able to successfully test the updating of a Number field on a Monday Item that had an existing value in the Number field.

Wondering if you are trying to update other fields as part of the Monday Zap action as well that may be impacting the Number field from being updated.

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

@kevinaz 

Can confirm you don’t need double quotes around the number value.

There appears to be logic that if you try to set a value back to 0, then it won’t update.

You’d likely have to use the Monday GraphQL API to properly change the value to 0 or clear the value for the column.

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

@Troy Tessalone I confirm that I don’t need it.
So 0 is would be the problem ?
With another value it should work ?
 

kevinaz
Userlevel 1

I’m a bit sad to say it, but it works fine with Integromat :/
I prefer to set that up in no code, I don’t have time to write mutations and query, I’m not a big fan of graphQL I alway prefer to work with REST.
Thanks anyway @Troy Tessalone  <3

Troy Tessalone
Userlevel 7
Badge +14

@kevinaz 

Looks like 0 may be interpreted as a missing (blank/empty/null) value and thus not updating.

When in doubt, test it out with other values.

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

@Troy Tessalone 
It is not only with 0, also with negative numbers. Indeed it works with numbers above 0

ken.a
Userlevel 7
Badge +6

Hi there @kevinaz,

I’m jumping in to see if I can help!

I did some digging into this, and it seems like this is a known bug with the monday.com integration. Our team is aware of the issue and we're working with monday.com on a fix. I've added your email address as another affected member. That does a few things:

  • Bring this to the attention of the integration developers
  • Help track and prioritize fixes
  • Allows us to notify you via email if/when this is fixed

Unfortunately, I do not have an ETA, but I’ve added you to the list of users affected by this issue so we can let you know as soon as we have any updates.

Thank you for your understanding.

Reply


Terms & Conditions