I have had a request from a colleague based on the attached screenshot. It is a Production Plan grouped by [Area] with [Start],[Duration], and [Finish] columns among others. What we are looking to do is if the user changes the [Start] for [Job Card] 000023 from 07:30 to 08:30 all subsequent values for [Start] & [Finish] (by [Area]) in this View will update by +1Hr. Notwithstanding that updating subsequent rows will only be required for those rows whose work starts after the row that is updated. e.g. if [Job Card #] 000025 was updated, only 000026 would auto update.
I would need to implement the same behaviour if the [Duration] value changed also. For example if the [Duration] on [Job Card #] 000023 changed from 4hr to 5hr then that would change the finish time to 12.30 and update all subsequent [Start] & [Finish] times by 1HR.
Hope this makes some sense. Any advice on if this is achievable and how would be greatly appreciated.