Forum Discussion

MikeSanders's avatar
MikeSanders
Qrew Member
2 years ago
Solved

New App

I would appreciate any suggestions on the best way to set up a new app to be able to create this simple table:

Market Total Items MS 2 Items MS 3 Items
Houston 17 16 4
Indianapolis 22 0 0
Atlanta 13 7 6
Miami 0 0 0
Los Angeles 0 8 10
TOTAL 52 31 20

Each market has multiple records which have any number of items in the 3 categories.  The different item types are summed to give the number shown above.

It seems like a simple table, but I haven't been able to figure it out.  Please help!



------------------------------
Mike Sanders
------------------------------
  • The items table should just have three fields for:
    • Market (multiple choice or lookup from a relationship) ,
    • Qty
    • Type (multiple choice if there are just a few choices).
    Then use a summary report to make your report.

    The config for the summary report is that group by Rows are Market and "group columns" by type.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------

12 Replies

  • The items table should just have three fields for:
    • Market (multiple choice or lookup from a relationship) ,
    • Qty
    • Type (multiple choice if there are just a few choices).
    Then use a summary report to make your report.

    The config for the summary report is that group by Rows are Market and "group columns" by type.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • MikeSanders's avatar
      MikeSanders
      Qrew Member
      Thanks Mark, is it possible to take the results of multiple summary tables and combine them into a single table?

      ------------------------------
      Mike Sanders
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        If you mean that you have data and separate tables in an application then no it is very difficult to combine that information.
        Imagine if you had a spreadsheet with different tabs and each tab had completely different information in order to combine that becomes very tricky


        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------