Hi,
I have tried to use some of the automations available to complete a task that will auto-update a second column (Completed) and empty the first column (order number) - Board 1, after the order status board - board 2, changes to complete. I’ve not had any luck doing it. Do you guys know if there is a way o achieve this automations?
TIA
Norma Osorio
Do you want when status change to “X” on board 1 then change status on board 2 with “Y”. If that is case then you need to use make(if these both items are same).
If you go to the “built-in” automations in the “automation center”, choose “status change” you’ll find a recipe where a mirror status changing can change a status on the board.
So on board 1, create a mirror of the “completed” status column from board 2.
When mirror of completed changes to completed, change completed to complete
Now you can have:
When completed changes to complete, clear order number (assuming order number is not the name of the item).
Assuming you just want a status change on a connected item to change a status on this board (which you can then use to do other automations) there is no reason at all to use make.
I’m making the assumption you’ve got the items connected of course (because what is the point otherwise?)
Hi,
No, I want my second board to update a second column (completed orders) with the current “Order Number” once the “Work Status” column has been changed status to “Complete” in my first board.
I want to have a history of all the order numbers for a specific item number. Right now, I have to be updating completed orders (integer) column, once I complete a work order.
Board 2
Board 1
Thanks in advance,
Norma Osorio
Hi Cody,
Thanks for your support. have tried your approach, but sadly it does not work for what I want to achieve.
I want my second board to update a second column (completed orders - integer) with the current “Order Number” once the “Work Status” column has been changed status to “Complete” in my first board.
I want to have a history of all the order numbers for a specific item number. Right now, I have to be updating manually the completed orders (integer) column, once I complete a work order.
Would you have any other approach, I can try? I have been searching another way to approach this with chat GPT.
This is the code I am getting using chat GPT. Do you think it will work? I don’t want to jump into it and then realize that I have messed up my boards.
Chat GPTCODE
import monday
api_key = ‘YOUR_API_KEY’
monday_api = monday.Monday(api_key)
order_form_board_id = ‘YOUR_ORDER_FORM_BOARD_ID’
order_form_items = monday_api.get_items(order_form_board_id)
for item in order_form_items:
order_number = item.get_column_value(‘Order Number’)[‘text’]
work_status = item.get_column_value(‘Work Status’)[‘text’]
if work_status == 'Complete':
# Step 3: Update GAC Board
gac_board_id = 'YOUR_GAC_BOARD_ID'
gac_item_id = 'GET_GAC_ITEM_ID_FROM_ORDER_NUMBER'
# Fetch the existing Completed Orders value from GAC
existing_completed_orders = monday_api.get_item(gac_board_id, gac_item_id).get_column_value('Completed Orders')['text']
# Update GAC with the new Completed Orders value
new_completed_orders = item.get_column_value('Completed Orders')['text']
monday_api.change_item_value(gac_board_id, gac_item_id, 'Completed Orders', {'text': new_completed_orders})
You’re going to struggle with what chat gpt suggests on anything monday code related.
What type of column is it you’re copying the value from, and what type of column is it you’re copying to?
It looks to be connect boards columns? So you want to move the connection from the active orders to the completed orders column? Active and completed are on the same board though correct?
