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

@kevinaz

Good question.

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

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

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

@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 I confirm that I don’t need it.
So 0 is would be the problem ?
With another value it should work ?
 

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

@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 
It is not only with 0, also with negative numbers. Indeed it works with numbers above 0