Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

Re: New App

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

6 Replies

Sort By
  • MikeSanders's avatar
    MikeSanders
    Qrew Member
    2 years ago
    LOL, i think what you're saying is right.  Whenever there is a date in either of the 3 date fields, i want to add up the Items value and display the total, by market and show a total for all markets.

    ------------------------------
    Mike Sanders
    ------------------------------
    • MikeSanders's avatar
      MikeSanders
      Qrew Member
      2 years ago
      BTW, I'm happy to wait until you're finished.  I don't want to disturb a good ride!

      ------------------------------
      Mike Sanders
      ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago
    On the other hand, if you were saying that it's record just has a single mile stone deep then just do a summary report to group Rose by city and then enable column grouping by milestone day.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      2 years ago
      If you have a situation where one project record has three different milestones deep feels on the same record and that kind of reporting is important to you then you need to change the structure of your application.
      The correct structure for that would be one project as many mile stone dates. And your summary report would be on the mile stone dates table and the recording could be simple.
      If there are different types of milestone dates for example project started or construction started or sign off complete, then on the mile stone dates trial table there would be a tape filter identify what type of milestone date it was.


      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
    • MikeSanders's avatar
      MikeSanders
      Qrew Member
      2 years ago
      It's 3 different fields with unique dates

      ------------------------------
      Mike Sanders
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        2 years ago
        Lunch stop now. So if that recording is important to you like I said you need to change your application design so you have a relationship where one project has many mile stone dates. Then you would run the report off the trial table of mile stone dates. Children of course can't get any look up field easily from the parents so you can look up anything else you need like the city down to the child to be able to use that field in your summary report.

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