Adjust field length in an itnerace?

[jackhlin]

Hi All! 

For the Gantt Chart view, does anyone know if there's a way to have airtable automatically adjust all dependent task start dates when the predecessor task is moved up (backward in time)?  

I see that airtable automatically pushes out all dependent tasks automatically if a predecessor task is delayed (this is great!) but if a task duration is shortened or end date is moved back, all of the dependent tasks stay exactly where they are. 

Is there a setting or bit of automation I can add to enable automatic date adjustments in both directions?  This seems like a very basic feature for Gantt charts and doesn't quite make sense to have it only for updates in one direction but not the other! 

Jack

[Eric_L]

Hi Jack,

I successfully did that with the following automation:

1. When a record is updated: Table A, watching column Start
2. Find Records: Table A, find based on condition When "Children Column" has any of "Step 1.Record ID"
3. Repeat for : each in step 2
   
   1. Update Record: Table A, Record ID = Current List Item's  Record ID, set Start field = Step 1's Stop field

How does that work?