Updating another table from the row in another table

AppSheet AppSheet Q&A
1

I have a table Projects and table Tasks. I would like to update column “Progress” in table Projects when i add a record into table Tasks/column Project progress. Any ideas?

2
  1. I am assuming you want the physical column to update in the projects
  2. I am assuming Task is the part of Projects as a ref table
  3. Create a new physical column type ‘Number’
  4. Create two step action to update (Number + 1) the related projects when progress is updated in the tasks

Example app:

https://www.appsheet.com/Template/AppDef?appName=UpdateEventAction-531778&appId=UpdateEventAction-531778#UX.Views.Equipment