Forum Discussion

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

Re: Current Week in a query

If you want to see just 1 number as a result then you would need to put the Formula Query on some kind of admin record which only has one record.

More likely you want to have a similar formula query on a table of Teams so that you will see the hours for each team, so 5 Teams means 5 Team records  = 5 results for hours for each respective Team.

The formula query would need to be changed so that instead of hard coded to Team 6 it would refer to the Team number on the Team Record.

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

4 Replies

Sort By
  • HansHamm's avatar
    HansHamm
    Qrew Assistant Captain
    2 years ago
    Per your normal advice - -  DEAD ON!
    Thank you for your assistance Mark, your the best!

    ------------------------------
    Hans Hamm
    ------------------------------
    • HansHamm's avatar
      HansHamm
      Qrew Assistant Captain
      2 years ago
      Mark from what I am seeing there is no distinct count ability in a query, only in a summary table. Is that correct?

      ------------------------------
      Hans Hamm
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        2 years ago
        It's not impossible but you sort of would need to do some backflips with an additional Formula Query (FQ) to identify the "first duplicate" and then another FQ to just count the first ones.

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