Create total number of subitems based on an item number column

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.

Thanks

Do you have a known range of numbers? like 1-5 or could it be 1-200 (which i think is the subitem limit)

Hey @bibujakera

We developed an app called subitem automations that’s solves this use case.
Here’s how it works -

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.

You can find it in the monday.com marketplace in the platform or here - monday.com: Apps Marketplace

Hope that helps!

Hi @codyfrisch ,
It can be 1-10.

Thanks

Hi @Fantasy-Media-Team ,

Thank you for your feedback.
I will check the app and see if it will be applicable for us.

Regards,

@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!

Hey @joeciliberto,

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?

If you want to discuss further I’m available at - daniel@fantasymedia.io

Hi @bibujakera I think you need to create 10 automations, Automation would be

  • When Column changes and then condition if number is 1 then create subitem and so on.