@ablx and @david thanks for the replies.
@ablx regarding your suggestion. “make a cell that contains the list of allowed users or user and then apply the filter”. If I am understanding your helpful idea, the entire list will see and edit the note. This would not satisfy the third requirement “Each logged in user can create their own private note about Dwight.”. Or am I misunderstanding?
Think of the use case of HR and management. Users each want to take notes about Dwight, without Dwight or others seeing the notes. CRM has very similar needs for private notes about customers.
Another way to conceptualize this, is it would function exactly like a “comment” component on a detail page, with the tweak that only the author can see and edit their private entry.
From a data perspective, since its a many-to-many relationship (all employees each maintain private notes about all employees) I think a separate sheet/tab would be required (like App:Comments created by Comment component)… to tie each private note to each subject to each detail page.
@david when will “per-user columns” exist? Will it enable all the functionality detailed above? Alternatively, could the existing comment and/or note components have an option for “private” (only author can see comment/note) and be later editable by author? Augmenting existing comment or note components to be private would “add private note on detail view” as well.