Is there a way to create fields in a master table and have them only show up as they are associated to a group or project program

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I am creating a master project management app. Within the app, I will create home pages for each program and will filter the page and reports based on a project "nickname" and group.

While the app will contain master tables and fields that will carry across each project, I will ultimately needs special fields for each of the different programs.

How can I create these fields in the master projects table (our a fields table) and have them only show up in the projects they are related to.
Photo of Joey Zint

Joey Zint

  • 1,708 Points 1k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
I suggest using form rules to control which fields appear on the form.  However you will need to have differenet versions of reports for the differenet programs
Photo of Joey Zint

Joey Zint

  • 1,708 Points 1k badge 2x thumb
I have the reports taken care of. Since we use a program nickname, I am duplicating the reports and filtering by the nickname and name the report such as "Program Nickname" - Active Project. So if I create fields...associate them to a project nickname....use a form rule then this is the best way to handle that. Would you put those fields in under their own section header and then simply hide that section based on the project nickname?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
Yes, if at all possible stick to showing and hiding whole section, for your own sanity.  But common fields which are used for data entry will need to be in a common section as a data entry field may only appear once on a form.
Photo of Joey Zint

Joey Zint

  • 1,708 Points 1k badge 2x thumb
One more....would it make since to create a table for the misc field by nickname or put them all in the master Project table. I want to make it as simple as possible to create new fields as we add new programs and do not want to dirty up master tables with misc fields
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
I'm not quite sure what you are saying but you may be onto an important thought.  If you can have these Program "Attribute" records be child records, then that is the best solution.  Then you would use the native Copy Master Detail functionality to automatically import the correct children for each Standard Program Type.
Photo of Joey Zint

Joey Zint

  • 1,708 Points 1k badge 2x thumb
I am think a table for those names related for the particular projects like this


Field Name      Program Nick Name
Field 1              Program A
Field 2              Program B
Field 3              Program C
Field 4              Program C

So on and so on. So if I want to add a new program field, I add it to the field table and pull it in based on the program nickname.