Updation of a coloumn values in mltiple rows depending on first value changed

[wabukhari]

My Scenario is: I have an "All Jobs" table in which, for each client there are multiple jobs.  The column "Visit Schedule date" in the "all jobs" table has the value for each job to be done.  The service period and the no of jobs are defined in the "Clients" table with the columns, "First date", "End date" and "No of visits". 
On updating any "visit schedule date", in " Al Jobs",  the values in the same column of the subsequent rows should automatically adjusted with new dates. How it can be done in the app sheet?

[Rafael_ANEIC-PY]

Hello there,

So, basically, you want the app to update all the "visit schedule date" for newer jobs when a job's "visit schedule date" is updated?

You could do that with a bot using a process with it's only step being running a data action on all the rows that should be updated.

Learning automation is kind of a long read, but I suggest you get started here:

https://support.google.com/appsheet/answer/11431791?hl=en&ref_topic=11998887&sjid=333738127360179885...

And I suggest you watch this video as well:

https://youtu.be/OY6UWen2XlM?si=FRMrzdenEkiSPSjE