Updating another table from the row in another table

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?

0 1 46
1 REPLY 1

  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-53...

Top Labels in this Space