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?
- I am assuming you want the physical column to update in the projects
- I am assuming Task is the part of Projects as a ref table
- Create a new physical column type ‘Number’
- Create two step action to update (Number + 1) the related projects when progress is updated in the tasks
Example app: