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 ...
App builders
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    2 years ago
    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
    ------------------------------
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
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
2 years ago
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
    Qrew Champion
    2 years ago
    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
    ------------------------------
    • MikeSanders's avatar
      MikeSanders
      Qrew Member
      2 years ago
      All of the data is in one table.  I need to sum one column (for 3 different milestone dates, depending on if they are empty or not) and then put those sums in a row for each of 5 cities.  I want the result in this format:

      Market Date 1 Date 2 Date 3
      Denver 17 16 4
      Boston 0 0 0
      Chicago 0 0 0
      Dover 0 0 0
      Evansville 0 0 0
      TOTAL 17 16 4

      I apologize for not explaining this very well.


      ------------------------------
      Mike Sanders
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        2 years ago
        Let me see if I can respond by tation, because I'm on a bicycle now.
        Are you saying that each record has three different milestone dates on it and hence the very same record head and dad getting summarized into any of those three columns?


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