I’m trying to build a Coda doc where each user has a “current project”, which is then used in all the other tables such that we know they’re working on that project.
It’s pretty simple to create a table that has a “user column” that references the current user, and a lookup reference to a project table that they can select from, but I run into the following problems:
- I’d like users to be able to either select a project, or enter in a new project, into the same text area, is there a way to achieve this?
- When a user adds a new project, it should become their current project immediately
- I don’t want users to accidentally be able to add two current projects, as this would screw up the flow of the rest of the document.
Would love thoughts on how to achieve this!