Calculate Future Date and Actions
I am looking to set up a form to calculate a future date based on a completed date field + 30 days and then show a box or possibly trigger a notification when it reaches that date. The form I have...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp, create a formula date field called
30 day Reminder Date
with a formula
[Resolution Completed Date] + Days(30)
Then you can make a report of where Today >= [30 day Reminder Date]
You will also need to have a completed checkbox or status field to filter the report or else this report will grow infinitely.
You can set up up a Subscription to that report to receive it on a scheduled daily or weekly frequency.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
30 day Reminder Date
with a formula
[Resolution Completed Date] + Days(30)
Then you can make a report of where Today >= [30 day Reminder Date]
You will also need to have a completed checkbox or status field to filter the report or else this report will grow infinitely.
You can set up up a Subscription to that report to receive it on a scheduled daily or weekly frequency.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Thanks! That helped!
------------------------------
Alex Freeman
------------------------------
