Column Manipulation - Green
"When any column changes, copy mirror column to suitable column"
Description: This integration checks to see if any column changes. If so, then the mirror column will be copied to the column of your choice. | Trigger - Any column change will be the trigger Action block - You can choose which mirror column will be copied Columns - You can choose which column the mirror will be copied over to |
Column - Any column change will be the trigger
Mirror Column - You can choose the mirror column that you want to be copied
Suitable Column - You can choose which column the mirror column will be copied to
"When column changes, copy new value to this column"
Description: This integration checks to see if the chosen column changes. If so, then copy column to the column of your choice. | Trigger - You can choose which column change will be the trigger Action block - You can choose which column will be copied Columns - You can choose which column the new value will be copied over to |
Column - You can choose which column is the trigger
New Value - You can choose what value you want to be copied
This Column - You can choose which column the new value will go to
"When status changes to something, copy mirror column to this column"
Description: This integration checks to see if a specific status changes. If so, then the mirror column will be copied to the column of your choice. | Trigger - You can choose which status is the trigger Action block - You can choose which mirror column will be copied Columns - You can choose which column the mirror will be copied over to |
Status - You can choose which status column is the trigger
Mirror Column - You can choose the mirror column that you want to be copied
This Column - You can choose which column the mirror column will be copied to
"When button is clicked, copy mirror column to this column"
Description: This integration will check if a button is clicked. If so, then the mirror column will be copied to the column of your choice. | Trigger - You can choose which button is the trigger Action block - You can choose which mirror column will be copied Columns - You can choose which column the mirror will be copied over to |
Button - You can choose which button is the trigger
Mirror Column - You can choose the mirror column that you want to be copied
This Column - You can choose which column the mirror column will be copied to
"When a column changes, copy special column to this column"
Description: This integration checks to see if the chosen column changes. If so, then the special column will be copied to the column of your choice. | Trigger - You can choose which column change will be the trigger Action block - You can choose which column will be copied Columns - You can choose which column the special column will be copied over to |
Column - You can choose which column change will be the trigger
Special Column - You can choose which column will be copied
This Column - You can choose which column the special column will be copied over to
"When item is created, write this text as item name"
Description: This integration checks to see when an item is created. If so, then the item name will be changed to the outline you have written. | Trigger - When an item is created will be the trigger Action block - You can write out and customize how you want the item name to look Columns - Based on the text outline, this will change the item name |
Item - When an item is created it will trigger
Text - You can write out how you want the item name to look
Item Name - This will change according to the text outline
"When a column changes, write this text as item name"
Description: This integration checks to see if the chosen column changes. If so, then the item name will be changed to the outline you have written. | Trigger - When the chosen column changes will be the trigger Action block - You can write out and customize how you want the item name to look Columns - Based on the text outline, this will change the item name |
Column - You can choose which column change is the trigger
Text - You can write out and customize how you want the item name to look
Item Name - Based on the text outline, this will change the item name
"When an item is created remove (copy) and FW:/RE:"
Description: This integration checks to see when an item is created. If so, then (copy) and or "FW:/RE" will be removed from the item name. This comes handy when duplicating items. | Trigger - When an item is created will be the trigger Action block - You can choose to remove either (copy) and or "FW:/RE" from the item name Columns - Based off the option chosen in the action block, it will remove that text from the item name |
Item - When an item is created will be the trigger
Remove - You can choose to remove either (copy) and or "FW:/RE" from the item name
Item Name - Based off the option chosen it will remove that text from the item name
"When column changes write URL pattern and text pattern to link column"
Description: This integration checks to see if the chosen column changes. If so, then the URL will turn the text pattern into a link. | Trigger - When the chosen column changes will be the trigger Action block - You can choose the format the link will be written in Columns - You can choose which link column the link will be stored |
Column - You can choose which column change is the trigger
URL/Text Pattern - You can choose how you want you link displayed
Link Column - You can choose where the link will be stored
"When column changes write this text to column"
Description: This integration checks to see if the chosen column changes. If so, then the chosen column will be written as text. | Trigger - When the chosen column changes will be the trigger Action block - You can choose the target column the text will be stored Columns - You can choose the text column |
Column - You can choose which column change is the trigger
Write - You can choose what column you want to be copied
Text Column - You can choose where the text will be stored
"When status changes to something write this text to column"
Description: This integration checks to see if a specific status changes. If so, then the chosen column will be written as text. | Trigger - When the status column changes to something will be the trigger Action block - You can choose the target column the text will be stored Columns - You can choose the text column |
Column - You can choose which status change is the trigger
Write - You can choose what column you want to be copied
Text Column - You can choose where the text will be stored
Column Requirement's - Pink
"When column changes create an update if any of these columns are empty"
Description: This integration checks to see if any of the chosen columns are empty when a specific column changes. If so, then an update will be written. | Trigger - You can choose which column is the trigger Action block - You can write out a customizable update using conditional fields Columns - You can choose which columns to be "watching" when the trigger column changes |
Column - You can choose which column is the trigger
Update - You can write out a customizable update using conditional fields
Columns - You can choose which columns to be "watching" when column changes
"When status changes if any of these columns are empty set status to something if not to something else"
Description: This integration checks to see if any of the chosen columns are empty when a specific status changes. If so, then a status will be changed. | Trigger - You can choose which status column is the trigger Action block - You can choose which columns to be "watching" when status get changed Columns - You can choose which status will get changed based off the trigger |
Status - You can choose which status column is the trigger
Columns - You can choose which columns to be "watching" when status get changed
Status - You can choose which status will get changed based off the trigger
"When an update is created if any of these words are found change status to something if not change it to something else"
Description: This integration checks if any specific key words are left inside an update. If so, then a status will be changed. | Trigger - When an update is left on an item Action block - You can choose the key words you want to check for Columns - You can choose which status gets changed based off the trigger |
Update - Leaving an update will be the trigger
Key Words - You can choose the key words you want to check for
Status - You can choose which status column gets changed
"When an update is created and files are attached (including inline images) set status to something if not set status to something else"
Description: This integration checks to see if files were uploaded with an item update. If so, then an status will be changed. | Trigger - When an update is left on an item Action block - You can choose whether to include or exclude images when leaving an update Columns - You can choose which status column gets changed |
Update - Leaving an update will be the trigger
Files - You can choose to include or exclude checking for files when an update is left
Status - You can choose which status column gets changed
Date Changes - Orange
"When date arrives push date by some days keeping the time"
Description: This integration checks to see when a specific date arrives. If so, then push the date by "x" amount of days while keeping the time. | Trigger - You can choose any date column as the trigger Action block - You can choose how many days you want to push the date by Columns - You can choose to add a time to the date |
Date - You can choose which date column is the trigger
Push Date - You can push the date by "x" amount of days
Time - Choose whether or not to add a time with the date
"When status changes to something push date by some days keeping the time"
Description: This integration checks to see if a specific status changes. If so, then push the date by "x" amount of days while keeping the time. | Trigger - You can choose which status column is the trigger Action block - You can choose how many days you want to push the date by Columns - You can choose to add a time to the date |
Status - You can choose which status column is the trigger
Push Date - You can choose how many days you want to push the date by
Time - Choose whether or not to add a time with the date
"When column changes set date to number days after date ignoring time"
Description: This integration checks to see if a specific status changes. If so, then it performs an automatic update to a specified date field in a record, based on changes in another column. | Trigger - You can choose which column change is the trigger Action block - You can choose how many days to set after date has arrived Columns - You can choose the date column to set |
Column - You can choose which column change is the trigger
Set Date to Number - You can choose how many days you want to push the date by
Time - You will not have to worry about the time being in factor
"When column changes update timeline with start date and end date"
Description: This integration checks to see if a specific column changes. If so, then automatic updates to the timeline will be made based on changes in a the date columns. | Trigger - You can choose which column change is the trigger Action block - You can choose which timeline to update Columns - You can choose which date columns are updating the timeline |
Column - You can choose which column change is the trigger
Update Timeline - You can choose which timeline to update
Date - You can choose which date columns are updating the timeline
"When column changes update start date and end date from timeline"
Description: This integration checks to see if a specific timeline column changes. If so, then it will automatically update the start time and end time date column based on changes in a the timeline column. | Trigger - You can choose which timeline change is the trigger Action block - You can choose which date column to update Columns - You can choose which timeline column its updating |
Column - You can choose which timeline column change is the trigger
Start date and End date - You can choose which columns to update
Timeline - You can choose which timeline columns are updating the date columns
Formula & Calculation's - Blue
IMPORTANT: Formula & Calculations use math.js syntax, which is different from the formula column syntax you're likely used to on monday. Please review the documentation below, we have provided a list of supported operations and functions.
Supported Operations
+ (Add)
– (Subtract)
* (Multiply)
/ (Divide)
! (Factorial)
^ (Power)
mod (Modulo, aka Remainder)
( ) (grouping & order of operations override)
Supported Functions
abs(x) – Calculate the absolute value of x.
ceil(x) – Round x towards plus infinity.
fix(x) – Round x towards zero.
floor(x) – Round x minus infinity.
lcm(a, b) – Calculate the least common multiple for a and b.
lcm(a, b, c …) – Calculate the least common multiple for all values a, b, c….
max(a, b, c, …) – Returns the maximum value of all values a, b, c….
min(a, b, c, …) – Returns the minimum value of all values a, b, c….
round(x [, n]) – Round x towards the nearest integer. If n is given, round x to nearest number of n decimal places.
sign(x) – Compute the sign of x.
sqrt(x) – Calculate the square root of x.
sum(a, b, c, …) – Returns the sum of all values a, b, c….
xgcd(a, b) – Calculate the extended greatest common divisor for a and b.
concat('x', 'y', 'z') – Used to link things together in a series or chain. **Note: If you want to add a space in between your values, use this function here: ( ' - ' ). The parentheses don't need to be there!
"When status changes to something calculate formula and store result in this column"
Description: This integration checks to see when a specific status changes. If so, then a calculation will be made using a formula. | Trigger - You can choose which status column is the trigger Action block - You can create a customizable formula or calculation Columns - You can choose which column to store the result or calculation |
Status - You can choose which status column is the trigger
Formula - You can create a customizable formula or calculation
This Column - You can choose which column the result will be stored in
"When this column changes calculate formula and store result in this column"
Description: This integration checks to see if the chosen columns changes. If so, then a calculation will be made using a formula. | Trigger - You can choose which column change will be the trigger Action block - You can create a customizable formula or calculation Columns - You can choose which column to store the result or calculation |
Column - You can choose which column change is the trigger
Formula - You can create a customizable formula or calculation
This Column - You can choose which column the result will be stored in
"When column changes copy sum of numbers mirror to target column"
Description: This integration checks to see if the chosen columns changes. If so, then it will copy the chosen numbers mirror column to the target column. | Trigger - You can choose which column change will be the trigger Action block - You can choose the mirrored number column Columns - You can choose which column to store the result or calculation |
Column - You can choose which column change is the trigger
Numbers - You can choose which mirrored numbers column to copy
Target Column - You can choose which column the number will be stored in
Item Updates - Yellow
"When a column changes, create a checklist update with this text"
Description: This integration checks to see if the chosen column changes. If so, then a checklist will be added as an update. | Trigger - You can choose which column change is the trigger Action block - An item update will be created Columns - You can choose how your checklist is written |
Column - You can choose which column change is the trigger
Checklist - A checklist update will be created
Text - You can choose to modify the text of the update
Important Info:
When writing out your checklist, you need to put an "o" before each checked item to make it a checklist. For Example: "o Check Email" and "o Check Email"
"When a status changes to something, create a checklist update with this text"
Description: This integration checks to see when a specific status changes. If so, then a checklist will be added as an update. | Trigger - You can choose which status column is the trigger Action block - An item update will be created Columns - You can choose how your checklist is written |
Column - You can choose which status column is the trigger
Checklist - You can write out a customizable update using conditional fields
Text - You can choose to modify the text of the update
Important Info:
When writing out your check list you need to put a "o" before each checked item to make it a checklist. For Example: "o Check Email" and "o Check Email"
"When an update is created, copy update to linked item"
Description: This integration checks to see if an update is created. If so, then the update will be copied to to the item inside the linked column. | Trigger - When an update is created this will be the trigger Action block - Your update will be copied Columns - You can choose which linked column to copy the update to |
Item Update - When an item update is created this will act as the trigger
Update - Your update will be copied
Linked Item - You can choose which linked column the update will be copied to
People Assignment's - Purple
"When button clicked assign (replace) dynamic user to people"
Description: This integration checks to see when a button is clicked. If so, then the user who clicked the button will be assigned to the peoples column. | Trigger - You can choose which button is the trigger Action block - You can choose whether to assign or replace the person Columns - You can choose which peoples columns the person will get assigned to |
Button - You can choose which button will be the trigger
Assign (Replace) - You can choose whether to assign or replace the person
People - You can choose which peoples column the person gets assigned to
"When status changes to something, assign (replace) dynamic user to people"
Description: This integration checks to see when a specific status changes. If so, then the user who changed the status will be assigned to the peoples column. | Trigger - You can choose which status column is the trigger Action block - You can choose whether to assign or replace the person Columns - You can choose which peoples column the person will get assigned to |
Status - You can choose which status column is the trigger
Assign (Replace) - You can choose whether to assign or replace the person
People - You can choose which peoples column the person gets assigned to
"When an update is created assign creator as person"
Description: This integration checks to see if any of the chosen columns are empty when a specific status changes. If so, then an update will be written. | Trigger - Leaving an item update will be the trigger Action block - The user creating the update will be the creator Columns - You can choose which peoples column the creator will get assigned to |
Update - Leaving an item update will be the trigger
Assign - The user creating the update will be the one who gets assigned
Person - You can choose which peoples column the creator will get assigned to
"When person is assigned expand person using field mapping"
**YOU MUST HAVE DEVELOPER MODE ENABLED IN ORDER FOR THIS INTEGRATIONS TO WORK**
Description: This integration checks to see when a person is assigned to an item. If so, then it will populate any mapped fields regarding the person. | Action block - Person assigned will be who the data is coming from Trigger - When a person is assigned Columns - You can choose which column the data will get pushed to |
Person - When a person is assigned will be the trigger
Expand - You can choose which data you want to get
Field Mapping - You can choose which column the data will get pushed to
Mapping
fieldname=>columnId
fieldname2=>columnId2
To find the columnID: Click the three dots on the column you are trying to map and copy the ID (it will be the very first option after clicking the three dots.)
**All of the fields can go to text, long_text, or name columns**
Current Supported Column types:
location=>location
birthday=>date
time_offset=>number
email=>email
phone=>phone
mobile_phone=>phone
country=>country
photo_url/profile_url=>link
time_zone=>world_clock
Subitems - Brown
Non-Supported monday Columns
(Connected Column)
(Mirror Column)
(Formula Column)
(monday Doc Column)
(Meeting notes Column)
(Creative Brief Column)
(Item ID Column)
(Vote Column)
(Tags Column)
(Files Column)
(Creation Log Column)
(Last Updated Column)
(Auto Number Column)
(Progress tracking Column)
(Dependent On Column)
(Color picker Column)
(Time tracking Column)
(Hour Column)
**YOU MUST HAVE DEVELOPER MODE ENABLED IN ORDER FOR SUBITEM INTEGRATIONS TO WORK**
How To Enable it:
Click on your profile icon
Choose "monday.labs"
Search "Developer Mode"
Click "Activate"
"When a subitem is created copy column ID map from parent item to subitem"
Description: This integration checks to see when a subitem is created. If so, then it will copy details from the parent item into the subitem. | Trigger - When a subitem is created Action block - You can choose what is brought down from the parent item to the subitem Columns - You can choose which columns will get copied |
Subitem - When a subitem is created will be the trigger
Copy ID Map - You can choose what is brought down from the parent item
Subitem - You can choose which columns will get copied
Mapping
fieldname=>columnId
fieldname2=>columnId2
To find the columnID: Click the three dots on the column you are trying to map and copy the ID (it will be the very first option after clicking the three dots.)