One way to get this to work, you will need to run a saved table to table import to import the child record into themselves and merge on Record ID# so in fact no new records would be created. The import would map the one date field into the other.
The trick however, is to limit that table to table import to just the child record of the Focus Project.
You can make a table with exactly one record in it and exactly 1 numeric field called [Record ID# of Focus Project]. It will be record ID# of 1. Then make a relationship between that table and your children Ops records based on a field called [Link to Focus Project (=1)] and make that a formula numeric field that will calculate to 1. So the formula is 1. Then look up the [Record ID# of Focus Project] down to the child ops records.
Then build a saved table to table import from ops into ops and limit the import to just where [Related Project] = [Record ID# of Focus Project].
Map the [Actual Start date into the planned start date]
Then build your automation to have two steps.
1. Write the Record ID#of the project into that focus table.
2. Run the import.
Feel free to contact me directly at
QuickBaseCoach.com or we can continue to muddle though this way too.
