Skip to main content

Help needed for bulk edit column values

  • October 13, 2022
  • 3 replies
  • 1264 views

Hi, I am looking for some help writing script for monday.com where I need to change multiple items & their connected column values. I have got to a point where I need support on writing and executing the script in monday.com. thank you

3 replies

Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • October 16, 2022

Hello @Edie and welcome to the community!

I hope you like it here 💪

There is no one mutation that can change the column values of multiple items at the same time.

As a workaround, you could use this approach to send more than one mutation in the same request.

Is that what you need help with or do you have any questions regarding the syntax used in connect boards columns?

Cheers,
Matias


  • Author
  • New Participant
  • October 17, 2022

Hey Matias,

Thank you for reaching out to me, very much appreciated!

I think the best way I can describe what I need, is to have the queries done and mutations done at the same time, but I know I must create the “Script” to do that…

Someone mentioned Python to me, so if I create what I need to be done in a way where I press a button and it does it for all items - thats what I need.

My reason is I have a CRM built in monday.com, but there is one connected column which is not two way, i would like to update the new two way connected column with all the values at the same time (without doing it mnaually~).

Thank you,


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • October 18, 2022

Hello @Edie!

Yes. You can create a script that performs an HTTP request (or many) to query data, and then one or more requests with mutations in them.

There are multiple ways of doing it. You can use the language of your choice.

If you want to use Python, I do not have experience with it, but I am sure you can find many useful topics here in our community of devs using it 🙂

If you need someone to do this for you, you should check our “hire an expert” section here!

Hope that helps!

Cheers,
Matias