I’d like to know if there is a way of creating subitems based on a number column when a status changes. The total number of subitems created should be the same as the number column and the number column can be any number. For example if an item has a number column with value 3, the automation should create 3 subitems; if the number column is 2, the automation should create 2 subitems.
Is it possible to achieve this is one automation whitout having multiple automations as the number column is not predefined.
You can either use you’re existing status column or if needed you can create a new status column with numbers and just create an automation for each status. Something like - “When status changes to 1, create 1 subitem”, “When changes to 2, create 2” and so on.
@Fantasy-Media-Team I need this type of automation but to apply to all items in the board. The reason why is that I need some type of trigger to create subitems based on parent columns and pull in the column values for the name so this automation does that but just for a specific item, whereas I need it to work for all items (around 7k). The automation of yours I was looking at is “When status changes to x, create a subitem on ITEM in BOARD NAME.” Is there a way to have this apply to all items and not just one?Thanks!
The way automations work is that they require a trigger (an action) to get them working. This usually originates from a column changes.
What you can do to solve this is simply use batch action of a column change, would that work?