Forum Discussion
SuryaExpert
7 years agoQrew Assistant Captain
Evan...so far so good. But since there could be more than 1 (even more than 20) such people who may want to watch a given project, I would have to put them in a separate child table: "Watchers and the Watched". Since a project can be watched by multiple watchers and a watcher can watch multiple projects, this data has to reside in a many-to-many relationships table. Now, whenever a modification is done on any given project record, the email has to go out to all those who are watching this project (from the "Watchers and the Watched" table). Just like watching github repos, except this is Projects in QuickBase.