Forum Discussion

Qrew Member

3 years ago

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 ...

MarkShnier__You
3 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

Icon for Qrew Legend rank

Qrew Legend

3 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
------------------------------

MikeSanders
Qrew Member
3 years ago
Thanks Mark!

Mike
MikeSanders
Qrew Member
3 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
  Qrew Legend
  3 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
    Qrew Member
    3 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
    ------------------------------