Is it possible or native to Quickbase, to create a crosstab (Matrix Format) for the users to enter data

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
Is it possible or native to Quickbase, to create a crosstab (Matrix Format) for the users to enter data, where users can enter the data in the cells just like in excel?
Photo of sandeep sandeep

sandeep sandeep

  • 932 Points 500 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,756 Points 5k badge 2x thumb
Hi Sandeep,

You can create a grid edit report which looks like excel sheet where you can enter the data like in excel.

Do let me know if this is what you are looking for.

Thanks,

Gaurav Sharma
Photo of sandeep sandeep

sandeep sandeep

  • 932 Points 500 badge 2x thumb
hi gaurav

yes iam looking for the same,can you help how to do.

Thanks 
sandeep
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,756 Points 5k badge 2x thumb
Sure. When you create a report then, choose the Grid Edit type report and select the columns and save it.

(Edited)
Photo of sandeep sandeep

sandeep sandeep

  • 932 Points 500 badge 2x thumb
hi can you help how to do this report.
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,756 Points 5k badge 2x thumb
Hi Sandeep,

Sure, I can help you. But, I need to first understand the table and relationships of your app where you want to create this report. Could you please some more information about fields name and other related details if there is.

Thanks,

Gaurav
(Edited)
Photo of sandeep sandeep

sandeep sandeep

  • 932 Points 500 badge 2x thumb
hello Gaurav,

No Relationships with any table and size field type multiple choice in that drop down i gave s,l,m,year field type multiple choice in that drop down  i gave 2009,2011,2012,2013 ,2014,2015,2016,2017
Photo of Michael Graham

Michael Graham

  • 66 Points
I'm sure that's what Grid Edit is for ????