Qrew LegendIn the past I have use this technique to create a variable number of child records.
I create an Admin Record in a table with just 1 record to record the Record ID# of the Focus Masters. I create a relationship where One Masters has many Admins and I look up any fields which will be required to determine how many Child record will need to be created from Masters down to the admin record.
Then I create a helper table say with 100 records in it. Using a formula based on the the native Record ID field or another field that I populate I make sure that there is a field numbered 0 to 100. Call this [Month#].
Then make a formula field to calculate the first day of the month based on a starting date plus the number of Months in [Month#].
I then create a formula field with a value of 1, to link to the Admin record and lookup any fields I need to determine if the month is valid to be imported into Statuses.
Then you will have to use your formula skills to come up with a checkbox formula Field to determine which of those 100 future months are valid to be created a a status record.
So then the last step would be to have a button which initiates a pipeline which would set the admin record on the focus master thus causing the helper table records to auto check box if they are valid to be created as a status record and then have the pipeline look for those valid records and create status children.
