matrix style form

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have a matrix style spreadsheet  which relates to each project I have.  I can obviously create a table to add this to the app.  The only concern is that in doing so  I will be defining every single cell as a field and the naming convention requiring me to relate to a dept will make it very barbarous exercise.   A screenshot of the sample spreadsheet is attached.  From users perspective they need to add data in a grid edir format to be in line with spreadsheet they use. So will need to restrict the data entry. 

What is the best way to deal with such matrix style data entry?  




PS:  There a a few calculated columns which can be created with great issue.  It is the green highlighted cells which will be required for data input. 

Photo of Arshad Khwaja

Arshad Khwaja

  • 0 Points

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
No problem.

Set up a standard project with a child table set of those 20 records. That child record will have about 12 fields. Those 12 columns I see.

Then use the native QuickBase Copy a Master detail wizard in App Management to set up a button to Copy in this 20 standard child records from your master tamp,ate project.

So the user will create a project, click to import those 20 records, and then go into grid edit to fill in the matrix.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks. Two questions. How do I ensure that user always uses the grid edit option and what is the correct way to create master to detail. I always get confused with the options shown.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
The relationship will be One Project has Many Store Attributes.  Once you have set up the sore attribute table and set up a model Project with those 20 child records, then use the Link in App properties to create the Copy Master detail button.

During setup it will ask you if you always want to use the same Master Project. Your answer is yes, and point to you master template example project.

 If you really do want to stop users from editing the matrix  records one by one, just take the data entry fields off their form and instead show a message on the form directing the user to use grid edit.