Conditional User List
Looking for a solution where I can select multiple users on a record that meet a certain criteria. Ideal scenario is I have a table for "Project Managers" and a table for "Projects". I want to be a...
Forum Discussion
Hi Niraj,
I just wanted to follow up on this question to say that Mark absolutely hit the nail on the head for the best way to do this. Creating a table of just your PMs and creating a join table for a many to many unlocks so many future options for reporting and organization that tend to be really valuable as an app and its usage grows. It is also the best way to control dynamically based on the data which PMs show up, for example those who are active or even setting it up so only PMs with less than 4 active Projects show up, etc. Using the relationships and reporting to help filter you can get a lot of fine control over what data shows and also the ability to adjust that filtering as needs change.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
I just wanted to follow up on this question to say that Mark absolutely hit the nail on the head for the best way to do this. Creating a table of just your PMs and creating a join table for a many to many unlocks so many future options for reporting and organization that tend to be really valuable as an app and its usage grows. It is also the best way to control dynamically based on the data which PMs show up, for example those who are active or even setting it up so only PMs with less than 4 active Projects show up, etc. Using the relationships and reporting to help filter you can get a lot of fine control over what data shows and also the ability to adjust that filtering as needs change.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------