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
------------------------------
Original Message:
Sent: 06-29-2020 09:13
From: Mark Shnier (YQC)
Subject: Need help with a report formula
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
Original Message:
Sent: 06-29-2020 08:59
From: Addam ODell
Subject: 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
------------------------------