You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello,
I need to update 2 selected cell in a google sheet. I don't want to create a table for 2 fixed data in my workflow.
(I change the edited line in a loop and need to update row by row)
When I use fixed data it works fine.
For example : [["Publié","01/04/2424"]]
but if I change to [["Publié",{{variable@today}}]]
it doesn't work, I have the error : [body] "values" must be an array On the Google Sheets block
I tried to set a var to an array, for exemple : myVar => [["Publié",{{variable@today}}]] and use {{variables@myVar}} in the googlesheet block
also by using JS block...
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hello,
I need to update 2 selected cell in a google sheet. I don't want to create a table for 2 fixed data in my workflow.
(I change the edited line in a loop and need to update row by row)
When I use fixed data it works fine.
For example :
[["Publié","01/04/2424"]]
but if I change to
[["Publié",{{variable@today}}]]
it doesn't work, I have the error :
[body] "values" must be an array On the Google Sheets block
I tried to set a var to an array, for exemple : myVar =>
[["Publié",{{variable@today}}]]
and use{{variables@myVar}}
in the googlesheet blockalso by using JS block...
But it doesn't help
can someone help me ?
regards,
Annabelle
Beta Was this translation helpful? Give feedback.
All reactions