Hello all, Here is what I’m trying to accomplish, if anyone has any ideas how to go about it: I have a table for a message board.
Each row is a comment, and is tagged to a particular project.
When viewing the project, a user can use an action button to go to a filtered view of the message board, showing only messages for that project. Now, when adding a new message, the user must select a subject.
I would like for the user to be able to either choose a subject that has already been used for a particular project, or else start a new subject.
In this way, the UX for the message board can be grouped by subject. The problem is that when I set the ENUM for the “subject” column to allow other values, it will show all subjects that have ever been used for any project, even though the view is filtered.
I can of course use a Valid if constraint, but then the user will not be able to add his own subject. Does anyone have any ideas how else I might have both a filtered list of previous values and the option to add new at the same time?