Automation to add multiple records to a child table.

Question

I have 2 tables that are related. Projects -&gt; Milestones. Each project has scheduled start and completion dates. Depending on the duration of the project (Completion-Start) I have x number of weekly milestones , i.e. ToWeeks(Duration). How do I create an automation that adds a record in the project child table that represents each of the X number of milestones including the start date for each of the milestones. I would like to do this addition of project milestones on a schedule for all projects and by a trigger in a Project.child table result after the automation runs should look like this:Project name&nbsp; &nbsp; Milestone # Start DateABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;​1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Project Start DateABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Project Start Date +1 weekABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Project Start Date +2 weeksABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Project Start Date + 3 weeks...ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Project Start Date + X weeksThe duration of weeks changes so I am trying to get a history of information in the child table.------------------------------George Bramhall------------------------------

markshnier__you · Answer

There are a few solutions, but how long (how many weeks) is your longest possible project?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

georgebramhall2 · Answer

in looking at our nearly 100 Active projects, the longest duration is 73 weeks and our shortest is&nbsp; week.------------------------------George Bramhall------------------------------

markshnier__you · Answer

I can generally describe the approach I would use in this situation but it might need an hour of one on one consulting to get this working.

I would set up a helper table with a single record in it called automation focus. What a project is created or when the user pushes a button this record would be updated with the record ID of the parent project record and the number of weeks. It will also need to be supplied with the start date of the project.

That would also be a table with say 200 records in it with record ID is numbered from 1 to 200. This table would receive the information from the automation focus record by one of the relationship and that's with no the record ID of the parent record and the number of weeks record. This 200 record table would then have the calculations for the mile stone dates and would have a checkbox feel to say whether or not the particular date was needed. For example if the project was only five weeks then only the first five records would be checkboxed.

Then the process would run a saved table to table copy and copy the check box records or the day before five or 73 of them across to be children of the focus project record.

georgebramhall2 · Answer

I was thinking I was going to need a 3rd table for this to work. I follow your plan for the most part. Let me take a stab at it and then will let you know if I need some additional consulting time.------------------------------George Bramhall------------------------------

Forum Discussion

Automation to add multiple records to a child table.

Related Content

Using Grid Edit to Edit Multiple Records at Once

Edit Multiple Records at Once with Grid Edit

Modify multiple rows within the same group using Single Record ?

Custom Record Titles

Pipelines automation to change record owner