Forum Discussion

AddamODell's avatar
AddamODell
Qrew Trainee
4 years ago

Need help with a report formula

Hello Everyone, 

 I am still pretty new to quick base when it comes to certain functions and I need assistance in the formula set up for a report.  Basically what im trying to do it I have our sales team activity tracker for the week and for the day so I would like to have the reports reset after their allotted time.

Can any one shed some light on how to create the formula for the following: 

Reset at end of day 

Reset at end of week 


Thank you for the assistance

------------------------------
Addam ODell
------------------------------
Formulas and functions
reports and charts

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    4 years ago
    Can you explain more details about what do you mean by reset? Do you mean you just want reports of what activity was done for the current day? If that is the case then make a report where the shelter on date created is today.
    If you want another report of activities during the Current week, then you can make another report where the filter is where date created is during the current week.


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • EvanMartinez's avatar
      EvanMartinez
      Qrew Elite
      4 years ago
      Hi Addam,

      I agree with Mark if what you are looking to do is have only records from the current day or current week show up in a report instead of a formula you typically want to use the Filters option when customizing the report. When you filter on a date field you have options for the current day, week, month, etc. So you can easily create reports based off of the date in your fields or if you are wanting to identify any record that was edited by someone you can also use the Date Modified field since that updates whenever someone works no a record and saves changes.

      ------------------------------
      Evan Martinez
      Community Marketing Manager
      Quick Base
      ------------------------------
    • AddamODell's avatar
      AddamODell
      Qrew Trainee
      4 years ago
      Thanks this worked!!

      ------------------------------
      Addam ODell
      ------------------------------