Discussions

Expand all | Collapse all

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

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

    Posted 01-18-2018 11:43
    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?


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

    Posted 01-18-2018 11:54
    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


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

    Posted 01-18-2018 12:06
    hi gaurav

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

    Thanks 
    sandeep


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

    Posted 01-18-2018 12:12
    Sure. When you create a report then, choose the Grid Edit type report and select the columns and save it.



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

    Posted 01-22-2018 09:07
    hi can you help how to do this report.


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

    Posted 01-22-2018 09:19
    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


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

    Posted 01-22-2018 11:15
    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


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

    Posted 01-18-2018 11:58
    I'm sure that's what Grid Edit is for ????