I am currently building a section in my app where users can assign tasks to other users. For example I can add a task to “Bob’s to do list”, when I add this task it will show up on Bobs to do list as well as my own list of items I have assigned that are outstanding. The issue of concern for me is I have buttons in the app so Bob can delete the item when he has completed this task. The problem that occurs is it does not delete the item on my end.
The way I have set this up so far is when someone adds a task to someones to do list it adds two rows in the spreadsheet. The first row is for the specific person it is assigned to and the second row is for the person who assigned the task that way both people can see there outstanding items and it is only seen by the specific people it relates too.
How do I make it so when a person completes the task it deletes the item on both rows rather than just one?
Furthermore does anyone know if you have the private pro version how often it will sync data with google sheets if it has formulas. All it says online is it will sync data with the private pro plan on its own but how often?