I am looking for a way to change the column values for multiple items using the same mutation. I use change_column_value to do this for one item at a time, but the number of items I have on my board make this process inefficient. How can this process be done iteratively? If possible, where can I find an example of it?
Yes, you can use any language you want to create a simple iteration. Here is a classic for iteration using JS as a basic example:
myFunction () {
for (let i = 0; i < usersList.length; i++) {
monday.api(`mutation {create_notification(text: "This is my text", user_id: ${usersList[i]}, target_id: 1234567890, target_type: Project) { id }}`);
}
}
We do not have recommendations on where to write or host developers scripts. We usually write our code in Visual Studio Code if it is helpful as a reference. For testing, I usually use the terminal in visual studio code, run a file using Node and expose to the internet using ngrok. Again, these are not recommendations, just some references.
I appreciate the references. I currently do not possess much knowledge on using Node. Where can I learn the steps I need to take to make use of this script? Can you direct me to someone or any particular source?
Any tutorial like the ones @anon29275264 sent, can be good starting points. There are many of them for free online on Youtube. There are also usually various courses on platforms like Udemy or Platzi if you would rather use those. Again, these are not recommendations, but rather some references for you to have.